Considering some of...

and how fast time flies.

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

One point for each post, points for correctly answering QotD according the the number granted by the question.

If you look at the http://www.sqlservercentral.com/TotalScores page, Lynn has 11813 points total, 9960...

I don't have time to redesign the table and rewrite for you.

Once you have the domain in a separate column, then you can use straight forward IN to do direct...

The problem is the leading wildcards in the where clause. Those are not SARGable and hence a table scan is required.

Consider redesigning the table so that the domain of the...

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

SELECT <column list> FROM (

SELECT <column list>, ROW_NUMBER() OVER (Partition By Category Order By (SELECT NEWID())) AS RowNo

FROM Table1) sub

WHERE rowNo <=3

When a backup is restored the DB is recreated in exactly the same state it was at the time it was backed up. If there are no triggers in the...

Bit conditions should be stored in bit columns. One field for each condition. Two reasons.

Storing multiple values in a single field is a violation of First Normal Form. All columns...

Interesting.

Difference in post count between Steve and Jeff and between Jeff and I is almost identical. I suspect...

Grant the lock pages permission. Leaving that unset is asking the OS to swap SQL's memory out for no good reason.

Were the disk counters spiking to 'unacceptable' values or was...

Have a look in the SQL error log. If login failures are logged, which I believe is the default, the failure will be listed there with a state that;s not...

Since the question is almost a year and a half old, I'm guessing it's not longer...

It won't be several unless you're dealing with many millions of pages in the index. The upper levels of indexes are very small in relation to the leaf level and...