I have had situations where the Exchange account name is case sensitive.  Normally this case is not an issue, but for some of our mail profiles they only work if...

Most of your time will be spent in I-O, so your 8 processors will not get overworked.

The time will depend on the I-O rate of your disk system, and how...

SQL2005 skills are still a bit hard to find this year.  By next year it will become hard to find people willing to work on SQL2000.  Likewise with VS2005 and...

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...