This is a Windows 2003 X64 Enterprise with 32GB of memory running SQL 2000 SP4 32bit with hotfix SQL2000-KB899761-v8.00.2040-x86x64-ENU.exe to solve...
Hi everyone, The server is finally bolted in and the storage is ready to be configured. As usual some advice is more than welcome. Yes, 146GB is not...
I have a table with four indexes and during some routine maintenance I ended up creating a new filegroup for just this one index. I placed two files...
Trying to move a PK from one file to a different file on a 2000 server database here is what the new SMS scripts out: USE [Database] GO ALTER TABLE...
Can anyone explain the relationship between the following: name,rows,reserved,data,index_size,unused transaction,49587599 ,22,087,312 KB,11,564,200...
We currently have two DB on the same machine and two different instances. A new server is being purchased and will have 2003 64bit with 2005 SQL. The...
I have a PE 6600 with 4 CPU and Hyperthreading. I'd like to know how to decide which 4 cpu should be selected when configuring the SQL server through...
Is there any way to determine which indexes span multiple files? Thanks Andrea
In a new server I'm configuring I'm debating whether to go with 32GB at 400MHz (PC3200), 48GB at 333MHz (PC2700), or 128GB at 266MHz (PC2700)]...
Separate names with a comma.
