You need to uninstall SQL, then reinstall it using the Cluster name.

Apart from the bottom-level leaf pages, clustered and non-clustered indexes are the same.  Therefore any discussion of I-O load should focus on what happens when pocessing the bottom-level only.

In a...

Automatic shrinking of database files is a great way to get really bad windows disk fragmentation and slow server performance.  My advice is to turn off autoshrink, and stop running...

rhunt,

Scenario 1 and scenario 2 have identical I-O until you want to access the Description column.  Scenario 1 means the page with the description may be in the same extent...

If you are going to take your laptop outside of a secure environment, you should consider encrypting the hard disk so that any confidential data cannot be freely read.

Ther are a...

Yes this sucks, but why should IT people think they would be immune from theft.  Bags have been stolen from tables in drinking establishments from the time that bags, tables...

If you are doing all your DR processes manually you really need to look at scripting most of the activities.  Your failover plan then reduces significantly to 'run scripts a...

There are no issues detaching/attaching (or restoring) SQL2000 database files across different operating systems.  The internal format of the database files is the same regardless of operating system or bit-level of...

The real answer is: 'it depends'

Always remember that a clustered index gives you the opportunity to give best possible performance to a range query that uses the index columns.  If...

Re Eric's problem about losing long posts...  I have had this problem a few times.  There is a timeout limit on creating a new post, and if you exceed this your...

Be aware that using the short form name such as C:\Progra~1\Micros~1\ is taking advantage of wha are known as DOS 8.3 file names.  The generation of 8.3 names can be...

I have used the built-in Windows Disk Defrag tool a number of tims on our non-production boxes while SQL is dealing with user queries.  I have had no problems.

Although this...

Another common problem when scheduling DTS jobs is file permissions.  A good way to debug these is to log on using the SQL Agent account and run your DTS from...

You really need a DR server with similar disk capacity to your main server.  The staff cost of working out how (and proving it works) or doing your DR in...

It may be old but it is still valid...

"SQL Server is wonderful... it inherits all the scalability, reliability and security of Windows"