If you already have Litespeed you may not want to throw it out. However, if you don't, using row/page compression ion the database, backup compression, backing up to multiple disk...

dma-669038 wrote: We typically go by below DMV based query - it has some limitations, only gives what is in cache since last reboot, but depending on your environment it...

Lets just say that the technical content is proportional to your distance from Seattle. In smaller markets on the far side of the world real technical content is non-existent. It...

Unlike Lutz's sample table in his previous post, Raja's table does have a unique key. Using that and set-based logic the following script works for me, regardless of the number...

Is it possible to get the stored procedure name from a trigger when an update operation was performed? I need to know which stored procedure invoked the trigger on an...

Don't want to provoke any religious wars. However, going...

The base MS KB article is 297861. There are also blog posts by Tibor Karaszi http://sqlblog.com/blogs/tibor_karaszi/archive/2008/08/14/are-inserts-quicker-to-heap-or-clustered-tables.aspx and Kimberly Tripp http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-Continues.aspx

In summary, it is my understanding that...

On the other hand a large heap (no clustered index) would INSERT very slowly (I have come across some prize examples of same). You may also want to check if...

In my view the code fragment from Ahmad is missing a number of considerations that should be taken into account for a practical SQL table-based queueing systems:

* Polling SQL table...

I go with Hugo's explanation, except that the backup of the log does take a finite time. Particularly if you have a large active log then it may take a...