If you have the enterprise version of SS2k5 you should seriously check about partitioning. (SWITCH, MERGE etc)

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

With that you will be able to move millions of rows very...

The first thing I get in mind (and I know it's far from the best solution out there 4 sort operations per line returned) would be using a UDF.

SELECT

CASE...

There's also an upgrade advisor that can help you if you have something more than just common SQL things:

http://www.microsoft.com/downloads/details.aspx?familyid=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

This was the same issue as:

http://www.sqlservercentral.com/Forums/Topic416644-149-1.aspx

Although it might seems that different version of SQL is not recommended, it did upgrade gracefully without any issue (and work correctly for...

For those interested, I did understand that it was a registry issue. Microsoft recommended to change a value in the registry. However, I wasn't part of the conversation and the...

Hi Atif Sheikh

I've read some links that were posted inside the link you posted. It explains some interesting informations but I do not seem to find how much...

Hi rbarryyoung

I'm also confuse about these numbers.

I can provide you with a reference where I got those numbers that I assume are right (but there could be a mistake also)

The...

Hi GSquared

I didn't run into that issue... well not yet. I must size some tables with NVARCHAR(MAX) right now and I had that kind of question in my mind for...

First, let me say that I prefer avoiding duplicate indexes.

However, I feel like it might come handy in a very rare situation. Your point of view and critism are always...

Yes

We have a memory leak and it's closely related on code which use cursors and is the victim's deadlock.

Before jumping to conclusion I'm searching for information on this topic....

Same as chandrasekhar.ms

The first thing that came in my mind was using truth table permutation

OR by NOT(AND) and thus satisfying the request.

Most answers I've read talk about technicals and such details which apply at a different stage from my point of view. Of course I understand that some might find my...

it's a rollup update following SP4 meaning that you need SP4 installed before installing it.

Oh and one last thing

SP are regresive tested while cumulative updates not.

This matter a lot to me

Correct me if I'm wrong but I used to read on the microsoft site that they recommand only installing SP on production server, not cumulative updates.

They are available only for...