I've got a single box running IIS and SQL server 2005. At the moment, everything's running off a single RAID group.
I'd like to move some of the files to a second RAID group to see if I can improve performance -- perfmon shows significant disk queueing. Is there a "normal" way to set this up? If not, what's the best way to determine which parts of the db to move to reduce disk contention? (I'm using simple logging.)
Thanks for any help!
Hi ng,I need some input/suggestions for a very small layout.The situation: Some groupings of thumbnails. For every picture (thumbnail)there is a "big" picture. Thats it basically :) On the front the scenario isthis:A user clicks "Autumn". The user is presented with the "Autumn" thumbnails.If he click a thumbnail, the corresponding big image is displayed. Well, uget the picture :)Hoe is this most efficiently implemented in table-layout? I mean....do Icreate a table called "images" and have a column called "is_thumb"? Or do Ibetter make 2 tables...Or better make a "relation/type" table too?--?Thanks,/Summa
View 4 Replies View Relatedhello,all
I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure) from C Disk to D Disk(its space is very large) .
is it possible to do it ?
if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal report connectstring ) ?
thanks in advanced!
I designed a report in reporting services 2005. When i look at the view layout for the report everything is aligned correctly but if i go to print preview one matrix is shifted up or down. I have tried to put the matrix inside a rectangle but the issue is still present. Does anyone know why this is happening or any suggestions on what to do to fix it.
Thanks
Scott
If I return the Average, Minimum, and Maximum values for the counter Physical Disk: Avg. Disk Queue Length, and those values are 10, 0, 87 respectively, which value do I use to compute the Avg. Disk Queue Length for a 4 disk array(RAID 10): Average, Minimum, or Maximum? The disk(lun) is on a SAN.
-- Initialize Control Mechanism
DECLARE@Drive TINYINT,
@SQL VARCHAR(100)
SET@Drive = 97
-- Setup Staging Area
DECLARE@Drives TABLE
(
Drive CHAR(1),
Info VARCHAR(80)
)
WHILE @Drive <= 122
BEGIN
SET@SQL = 'EXEC XP_CMDSHELL ''fsutil volume diskfree ' + CHAR(@Drive) + ':'''
INSERT@Drives
(
Info
)
EXEC(@SQL)
UPDATE@Drives
SETDrive = CHAR(@Drive)
WHEREDrive IS NULL
SET@Drive = @Drive + 1
END
-- Show the expected output
SELECTDrive,
SUM(CASE WHEN Info LIKE 'Total # of bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS TotalBytes,
SUM(CASE WHEN Info LIKE 'Total # of free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS FreeBytes,
SUM(CASE WHEN Info LIKE 'Total # of avail free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS AvailFreeBytes
FROM(
SELECTDrive,
Info
FROM@Drives
WHEREInfo LIKE 'Total # of %'
) AS d
GROUP BYDrive
ORDER BYDrive
E 12°55'05.25"
N 56°04'39.16"
Hello,
I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something? Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set? Thanks in advance.
John
Hello,
this is my configuration :
1) 3 disks in RAID5 that hold the SQL data
2) 1 disk in RAID0 that holds the only paging file.
What will happen to the SQL data (DB) when the disk that holds the paging file crashes?
Kindest regards,
Luc.
Hi all,
Ok here goes,
I have a three tier system using SQL server 2000, we are currently experiencing IO bottle necks on our SCSI Raid 10 array, which holds the Data and the logs in separate partitions.
So my options as I understand it are:
Get Enterprise edition
or
Get another physical raid 10 array and separate the logs and data i.e. data on one array and logs on the other array.
I would like to try the latter but I am totally unsure how much difference this will make or whether it will make any difference at all.
Does anyone know how much performance increase I will get from using two arrays as opposed to one?
Any other advice on this scenario would be greatly appreciated.
Thanks
found it
View 3 Replies View RelatedI have a form that I created that groups make and model and it totals all the fields to make 1 entry on the Layout. I then am trying to get the layout to SUM those values but it does not. For example we have 2
Make, Model, Totals
CV, P2100, 50,000
CV, P2100, 52,000
CV, P2100, 48,000
CM, R3200, 50,000
CM, R3200, 53,000
CM, R3400, 20,000
CM, R3400, 22,000
As you can see above we have 2 Makes CV and CM, with Diff models.
The code i used totals the make, model, and totals for the parts.
Results look like this.
Make, Model, Total
CV, P2100, 150,000
CM, R3200, 103,000
CM, R3400, 42,0000
I tried to use the SUM function and it takes all older totals and places that at the bottom creating a Larger value than what should be posted.
the CM total should be 145,000 and the CV would be 150,000.
Here is the code I am using for this and this parts right I am just having issues with the layout not posting the correct numbers.
SELECT equip.eqpphybr, equip.kequipnum, equip.kmfg, equip.kmodel, equip.kserialnum, equipdet.glsrc, equipdet.glamt, equipdet.gldate, equipdet.action,
CASE WHEN action = 'b' THEN glamt ELSE 0000000.00 END AS RentalBilling,
CASE WHEN action = '6' THEN glamt ELSE 0000000.00 END AS Depreciation,
CASE WHEN action = 'a' THEN glamt ELSE 0000000.00 END AS Repairs, equip.eqprecdt, equipdaily.cnvf001, equipdaily.cnvf00109, equip.eqpstatus
FROM equipdet INNER JOIN equip ON equipdet.kequipnum = equip.kequipnum INNER JOIN equipdaily ON equip.kequipnum = equipdaily.kequipnum
WHERE (equipdet.gldate BETWEEN @fromdate AND @thrudate) AND (equip.eqpstatus <> 'SO')
ORDER BY equip.kmfg, equip.kmodel
__________________________________________________________________-
For the layout its looks like this with 2 groupings.
Below is the headers in same order as the =Fields
Br,EQ#, MFG, Model, S/N, ACQ Date, ACQ Cost, Book Value, Rental Billing, Depreciation, Repairs
---------------------------------------------------------------------
(This is row 1 inserted as a group with expression =Fields!kmfg.Value)
=Fields!eqpphybr.Value, =Fields!kequipnum.Value, =Fields!kmfg.Value, =Fields!kmodel.Value, =Fields!kserialnum.Value, =Fields!eqprecdt.Value, =Fields!cnvf001.Value, =Fields!cnvf00109.Value, =SUM(Fields!RentalBilling.Value), =SUM(Fields!Depreciation.Value), =SUM(Fields!Repairs.Value)
---------------------------------------------------------------------
(This row is set as a group by =Fields!Kmodel.Value)
ACQ Cost, Book Value, Rental Billing, Depreciation, Repairs
---------------------------------------------------------------------
Totals: =SUM(Fields!cnvf001.Value), =SUM(Fields!cnvf00109.Value), =SUM(Fields!RentalBilling.Value),=SUM(Fields!Depreciation.Value) / -1, =SUM(Fields!Repairs.Value)
---------------------------------------------------------------------
(I added a row from the =Fields!Kmodel.Value to get percents.)
Depreciation, Repairs
---------------------------------------------------------------------
=IIF(Sum(Fields!RentalBilling.Value)<>0,Sum(Fields!Depreciation.Value)/Sum(Fields!RentalBilling.Value),0)/-1, =IIF(Sum(Fields!RentalBilling.Value)<>0,Sum(Fields!Repairs.Value)/Sum(Fields!RentalBilling.Value),0)
We have a report that is printed landscape and contains a main table with values. Inside this table we also want to create a "sub-report" table based on two other criteria (charges and credits), but this data is still grouped with the main table. Here is a simple schematic of the report
XXXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXX Charges
XXXXXXXXX
XXXXXXXXX
Credits
XXXXXXXXX
XXXXXXXXX
XXXXXXX
We have placed a rectangle in the last column of the main table to accomodate two other "sub-tables": one for Charges and the other for Credits. We need to keep the heighth of each row in the main table the same (without extra white space) so we cannot move the second table for Credits below the table for charges.
I hope this makes sense and anybody with any suggestions, it is appreciated.
I'm developing a system in .NET to record and manage marks for classroom attendance. To enable staff to print-out the registers, I need to output the data in a printable format. My first thought on this was to use Reporting Servcices, however there are a number of caveats.
I'm using the matrix control to handle the displaying of the students with the class dates and attendance marks. After 25 columns are output this should wrap to a new page, is this possible?
When wrapping to a new page, the first 3 columns should remain the same with the other 18 being the next lot of class dates.
There needs to be 25 rows shown, regardless of whether or not there are actually 25 rows returned from the dataset.
Essentially the layout for this is strictly controlled. Is RS the correct tool for this or is there something else I can/should use?
Example register layout
NO. STUDENT ID 01/01 08/01 15/01 22/01 29/01
1 ADAM SMITH 123456 X X X X X
2 JANE WILSON 748386 X O O X X
Hey, guys
I have got problem of designing a report table. The table is created based on 5 field dataset output, student name, semester, unit name, unit code and exam mark. e.g.
StudentID Semeter UnitName UnitCode Mark
------------------------------------------------------------------------------------------------------------------------------------
123456 1, 2006 Database IT001 85
123456 1, 2006 XML IT002 82
123456 2, 2006 Web Development IT003 76
123456 2, 2006 ............
etc
and there is supposed to one table for one semester and the student ID and Semester must be in the first 2 rows and all the other data is column based as normal, which is like
StudentID 123456
Semester 1, 2006
------------------------------------------------------------------------
UnitName UnitCode Mark
Database ITN001 85
XML ITN002 82
StudentID 123456
Semester 2, 2006
------------------------------------------------------------------------
UnitName UnitCode Mark
Web Development ITN003 76
I only can create the table using grouping but the layout is column based.
Does anybody know how can I design the table to achieve the above table layout.
Thanks in advance.
Regards,
Jeff
I started the project with the goal of using 2005 Reporting Services as the reporting mechanism. Our graphic designer has created a layout that has been approved by the company and I am attempting to translate that layout to a report design that gives similar output.
I have discovered during the course of working with reports that true free from data layout is not possible. What I was expecting was the ability to design a layout for data in the body section of the report, and that layout being repeated for each row of data in the database.
I understand that tables and lists exists that allow repeated data to be displayed, but is it possible to repeat data in a custom freeform layout with 2005 Reporting Services.
Imagine if you were creating a report that looked like an ID card for each record. Would such a layout be possible with this reporting service?
If not, could someone direct me to a reporting application that does? Does Crystal Reports satisfy this requirement? I liked Reporting Services because it allowed one to design once and output into several popular formats, but the design portion doesn't appear to be as freeform as I was lead to believe.
Thanks
Hi,
When I preview my Reporting Services Report in VS2005 the report uses 2 separate pages. Even when there is very little data on Page 1 it will display something on Page 2.
How do I get all data on the one page?
Thanks.
I'm having a problem with my deployed reports. Once they have been deployed to a server then the layout changes and some parts of the report move around to line up with the edge of a matrix or the bottom of a table even through they do not actually overlap. The layout also changes depending on whether report items are visible or hidden, with tables moving away from hidden items but lining up witht hem when they are visible.
This also sometimes happens when moving between the layout and preview tabs in reporting services although this is not so much of a problem.
Has anyone else experienced the same problems and if so did you find a solution?
I have had a lood through the forum but although folks seem to be having a lot of issues with layout I can't see a problem quite like this one.
We have a number of customer reports which need to be exported to PDF and to look quite smart. They are single page reports with things like address and customer info at the top, followed by the main report, all of which can have a variable number of rows. Then at the bottom is some supplementary information which can also vary quite substantially in size. All I want is for the main report to hug the top of the page and the supplementary one to hug the bottom of the page - and I only really care what it looks like in PDF format. The problem is that I can't seem to achieve this. As the area at the top expands the bottom section moves up and down the page. I'd be quite happy to set aside a fixed area at the bottom of the page for the supplementary report, but I can't even work out how to acheive that! You would think that the obvious answer would be to put it in to a footer, but for some reason you can't put data elements in to headers or footers (why?). Any help would be greatly appreciated.
Hey,
I have MS SQL database.
I have procedure:
code:--------------------------------------------------------------------------------
CREATE PROCEDURE dbo.Reg_DropTable
@ModuleId varchar(10)
AS
declare @TableName varchar, @kiek numeric
set @TableName = 'reg_'+@ModuleId
begin
DROP TABLE @TableName <- HERE I GOT ERROR
end
GO
--------------------------------------------------------------------------------
I got error when using variable with tables names.
How to do this?
Ps. Number is send to this function and it must drop table with name Reg_[That number]
I have a report that i have totaled and working correctly and I am able to get the 2 columns to sum up but I need to get those 2 sumed columns to be divided to get the gross prof %.
The columns that I have summed are
=Sum(Fields!eqpsldamt.Value)
=Sum(Fields!grosspro.Value)
I need to take those summed values and divide them but I do not know the propper syntax to do this. I thought it would have been
=SUM(Fields!grosspro.Value) / SUM(eqpsldamt.Value)
But this did not work any help would be great thanks!
I have a report that i have totaled and working correctly and I am able to get the 2 columns to sum up but I need to get those 2 sumed columns to be divided to get the gross prof %.
The columns that I have summed are
=Sum(Fields!eqpsldamt.Value)
=Sum(Fields!grosspro.Value)
I need to take those summed values and divide them but I do not know the propper syntax to do this. I thought it would have been
=SUM(Fields!grosspro.Value) / SUM(eqpsldamt.Value)
But this did not work any help would be great thanks!
I have some old code that was used in cristal reports and thought it might help with my problem. I need this to calcuate intrest for every piece of equipment.
IF ({equipdet.ACQUIRED_DATE} < Date(2007,01,01)) THEN ({equipdet.Book Value}*(CurrentDate - Date(2007,01,01)) * .07/365) ELSE IF ({equipdet.ACQUIRED_DATE} > Date(2007,01,01)) THEN {equipdet.Book Value}*(CurrentDate - {equipdet.ACQUIRED_DATE})*
.07/365
I am just not sure how to write this in the layout view.
Hi
Is there anyway of copying an entire database (table layout, stored procs etc) without the data that the tables contain please?
I have a SQL7 DB (production) that I need to replicate on a SQL200 Server (development) but the DB is very large and all I need is the table structure and the stored procs on the development Server...
Cheers
Hi Guys,
Can I hear your views on this type of DB layout? I have a DB that contains tables which are not linked by FK's etc but rely on one another through SP's. I've never came across this layout before so was hoping you could shed some light on it with your experiences etc.
Also what if many of the tables didn't have PK's this would lead to duplicate data being allowed to be entered into the database. Are there any other issues here?
Regards Butterfly
Hello to everyoneI am using SQL Server Enterprise Manager and I would like to print thestructure of each table of a database, with the purpose to see the wholerecord layout. (In Access there is Analyzer which does that) butapparently I acnnot find anything similar in EM.Who Could help me?Thank you to everyone!RegardsFabio*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies View RelatedI'm trying to create a report like following format. Any idea how can I design it?
'ID', 'Title', 'Answer' and 'Comment' have to span multiple rows which will list 'Response'.
----------------------------------------------------------------------------------------------------------------------------
ID Title Answer Response Comment
------------------------------------------------------------------------------------------------------------------------------
1 | Q1 | B | A | aaaaaaaaaaaaaaaaa
| | | B | aaaaaaaaaaaaaaaaaaaaaaaaa
| | | C | aaaaaaaaaaaaaaaaaaaaaaaaa
| | | D |
---------------------------------------------------------------------------------------------------------------------------------------
2 | Q2 | C | A | bbbbbbbbbbbbbbbbbbbbbbbbbb
| | | B | bbbbbbbbbbbbbbbbbbbbbbb
| | | C | bbbbbbbbbbbbbbbbbbbbbbb
| | | D |
---------------------------------------------------------------------------------------------------------------------------------------
I have a report that needs to show postal addresses. The address is broken down into several fields. The problem I have is some of the address parts are optional. If they are empty, I'm left with nasty gaps in the address. I'd really like next label to reclaim the space of any empty labels.
a quick example
A full address would look like this..
customer name
address line 1
address line 2
town
county
post code
if address line 2 isnt given, I get:
customer name
address line 1
town
county
post code
but I want:
customer name
address line 1
town
county
post code
Can anyone help?
Many thanks,
Paul
win server 2003
sql server 2005
Hi, I need to create a report with the following layout
f1title f2title f3title f4title f5title
+field1 field2 field3 field4 field5
clicking on the + will display
f6title f7title f8title f9title
field6 field7 field8 field9
is this possible?
If it is please describe how.
TIA
Hi,
I have a report that, among other things, contains 3 tables laid out side-by-side horizontally. The first table is conditionally visible and when it is hidden the report contains whitespace instead of the table. The problem is that this causes an unappealing visual look because the other 2 tables look shifted too much to the right.
What is the recommended way for dealing with situations like this? There doesn't seem to be support for specifying the location (i.e. top, left) of elements based on expressions. Am I "stuck" with having to create multiple flavors of the report?
Thanks,
Vitaly
Hello
I need to create something like the following table:
MON TUE WED THU FRI SAT SUN
01/01/07 02/01/07 03/01/07 04/01/07 05/01/07 06/01/07 07/01/07
Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field
08/01/07 09/01/07 10/01/07 11/01/07 12/01/07 13/01/07 14/01/07
Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field Blank Field
The user would enter the start date, in this case the 1st Jan 07 and then this would populate a table. This seems like it should be so simple but I can't work it out, can anyone help please?
Cheers
Hello,
I am trying to come up with a Matrix report using RS 2005 that looks like this one below. I have row data: question, columns data: Ethnicity and Gender, detail data: Gender average response and Ethnicity average reponse. I utlilized Report Wizard to create a report in a Matrix format , however I wasn't able to have Gender and Ethnicity column on the same line. The report wizard groups columns so Gender is a subset of Ethnicity or Ethnicity is a subset of Gender. How can is solve this issuee so that Gender and Ethnicity data is presented in a Matrix format and Gender and Ethnicity are not part of each other.
Thank you!
F
M
Asian
Multi-cultural
Non-resident
Unknown
White
Black
Hispanic
Native American
a. Worked on a paper or project that required integrating ideas or information from various sources
3.95
3.99
3.54
4.50
3.28
4.20
4.18
4.04
3.92
3.90
b. Used library resources
4.26
4.09
4.12
4.33
4.10
4.33
4.26
4.22
4.10
4.10
c. Prepared multiple drafts of a paper or assignment before turning it in
3.97
3.76
3.80
4.50
3.58
3.86
3.95
4.09
4.00
4.00
Please can someone help me with this.
I have created a very simple SQL report which has a title, Image, 3 subtitles and some data fields.
When I view it is my VS designer and preview it looks perfect, however when I deploy and view the the report through my ReportViewer control all the labels get moved around and the entire thing is a mess.
If I then export it to PDF it looks perfect again... I am sure I am missing something obvious but I can't find it.
I have done absolutely no expression formatting or coding at all. It's a plain SQL query and plain result textboxes.
when i add a calculation in the group from my second dataset, it is summing the whole dataset, instead of just for that group. any suggestions?
View 1 Replies View Related