In THEORY, RAID1 Should outperform RAID5 in reads, as the controller (either SW or HW) could read from either disk to satisfy the request. In the event of a large...

This is a tough one. I was involved with a User Group for a couple of years, and getting responses and attendance was always hard, even though it was held...

Things to look for:

Cache hit Ratios (other queries pre-populating the cache)

Disk Queues (RAID levels etc)

sp recompiles (Always worth a look)

Disk fragmentation (depending on how you copied everything on this could...

Being an old UNIX hack, I would have preferred to see the CHR(13) and CHR(10) in seperate REPLACEs. That would allow it to work with data from other sources than...

From the webpage

Question: What does @@textsize return?

Correct Answer: The maximum size of a text field on the server. 2GB in SQL Server 2005.

Explanation:

This returns the current value of...