Viewing 15 posts - 76 through 90 (of 236 total)
Consider this an educated guess, "formatted".
Why, go in and allocate a 10 gig DB. Empty machine, lots of free dasd, nothing going on. IO acivity goes through the roof, and...
March 31, 2004 at 9:05 pm
Not sure where you got Money as 2 Decimals, my BOL shows them as 4.
Convert(Char(20),money,?)
? = 1 -> commas and 2 decimals
? = 2 -> no commas and 4 decimals
Not much...
March 31, 2004 at 1:34 pm
database_size is the amount of physical dasd allocated to the DB.
Unallocated space is space within the above that hasn't been assigned a purpose.
Unused is space allocated to various tables, indexes (objects) ......
March 31, 2004 at 1:20 pm
To demonstrate what Brian mentions.
On a TEST system, go into Properties --> Memory. Also fire up Perfmon or even task manager if you are local or remote desktop'd in.
Start playing...
March 31, 2004 at 1:05 pm
I can't help specifically, but will offer an opinion.
There is very little difference in the engine between Std and EE. Except for EE's ability to support more memory, and processors. ...
March 22, 2004 at 11:46 am
One advantage I have towards flat files is recovering very old data. You may not need to retain or restore after a long time. But I have been building a...
March 15, 2004 at 11:40 am
I guess I don't understand.
The diagrammer in EM can diagram an existing DB, there is no way to export the results for electronic documentation. But you can print it, although...
March 12, 2004 at 10:03 am
I would also consider changing the anything greater than 1 to VarChar.
I would have to check the details, I heard this a long time ago in a Seminar from Kalen...
March 12, 2004 at 8:43 am
You should experience any downtime while the Hot spare is rebuilt, but there could be some performance issue's during that time.
The IO subsystem will be very busy rebuilding the drive,...
March 12, 2004 at 7:56 am
Thanks MrSQL, either product will do a good job. I've found Visio good, but not perfect.
As for poorly defined DB, get used to it. You'll find more that way then...
March 11, 2004 at 8:24 pm
First it is Visio Pro, not the regular Visio that includes DB diagramming.
But if in EM you open an existing DB, click on diagram, then create a new diagram, you can add...
March 10, 2004 at 11:36 am
Diagrammer is a good tool for showing an existing DB, if you use the diagramer you go into diagrammer for the DB and add the tables.
Visio Pro is an excelent...
March 10, 2004 at 10:33 am
If this is a single field table with an index on that field you have an interesting issue.
I believe if you index that field (non clustered) and search only on...
March 5, 2004 at 10:36 am
Your basic setup is fairly acceptable.
Consider making the Raid1 bigger with 2 logical drives and moving OS etc to one drive, and the logs to the other. The OS files will...
March 1, 2004 at 9:04 am
As Ed mentioned, you need to stop SQL, or at least take the DB offline to defrag the mdf / ldf.
There is a program, contig.exe, on ??? that will tell...
February 24, 2004 at 11:44 am
Viewing 15 posts - 76 through 90 (of 236 total)