If I recall correctly I came across this syntax with help from Erland Sommarskog. I was looking for a way to remove duplicates from...

The angle you derive with the "Partition by" clause is...

I suspect there would be numerous ways to pose the question... maybe

more inadvertantly, like "Have you ever heard of a Resource database?"

I'm not poking fun at the...

I would certainly try to improve the question. Question can trip someone up when they are shot as a curve ball - it doesn't mean the person answering the...

Lynn,

I think it has the possibility of being a better question. Like everything that gets put out here on the web, I expect a good deal of thought should...

When I was attending school [nearly a million years ago], I never appreciated trick questions and at this stage in my life I cannot recall any of those questions. ...

There is always the googal and the googalplex

:blush: As ever; humbled, I am. :blush:

Someone mentioned you can upgrade from EVAL to ANY other edition. Only the following editions are supported for upgrade (within the six months:)

SQL Server 2005 Enterprise Edition

SQL Server...

http://blogs.msdn.com/sanchan/archive/2006/07/27/681086.aspx

"To perform an in-place upgrade of SQL 2005 Eval edition to other SQL Server 2005 full blown editions, simply run the setup and it will identify the existing...

Thanks Herb,

Math is fun - hands down. Your gesture is appreciated.

Are you testing the server to see how much email can go through on a given day? If you punch in the correct answer, which is SP2 of SQL...

This is one of those questions the professors in college speak of when they grade you. The "good profs" (arguably, some may not think them good, I do, but...

I'm not sure how I could be wrong. I constantly do this as many of our tables are so wide that it takes a while to find the column...

Just curious, does the script assume that you have already made a copy of the original on X to drive Y? I'm guessing that the server has to be...