I suspect answer D (one of the correct ones) needs to be "DELETE FROM" rather than "DELETE TABLE".

Thanks Edward.

A good enhancement to server permissions. It addresses a recent annoyance I found with setting up a SQL 2012 service account for use by SQL Compare... I could...

Lokesh Vij (10/4/2012)

---

sam.dahl (10/4/2012)

---

I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that...

How long has SQL 2008 been around? Close to 3 years.

And how long have I known about CONVERT styles for these non-date datatypes? Close to 3 minutes.

Thanks for...

The answer was almost obvious from the "do not run it on production server" recommendation.

But, a good question for highlighting the pitfalls of "float".

I agree. "Precision" is the number of digits capable of being stored by the data type. Whereas "Scale" is the number of digits right of the decimal point.

Easy mistake...

Huh?

Just when I was starting to understand golf....

Correct answer: ROW_NUMBER

Explanation: RANK() is the correct function as it will provide the “gaps” required when two or more...

From BOL:

Returns the current value of the TEXTSIZE option of the SET statement. This specifies the maximum length, in bytes, of varchar(max), nvarchar(max), varbinary(max), text, or image data that a...

Have you used Cluster Admin (or the cluster command) to "move" the disks to server A for the duration of the SQL setup?

That's right. Only local extended stored procs can be called from a UDF.

Sometimes, as a last resort, I have detached the database, renamed the offending LDF file, and then reattached the database... omitting the LDF in the attach command.  This builds a new...

When using the command prompt, and when the default dependency exists between SQL Server and SQL Agent, I most often use the commands:

net stop mssqlserver /y

and

net start sqlserveragent

 

 

 

take a look at:

http://www.microsoft.com/technet/scriptcenter/resources/qanda/aug04/hey0824.mspx

I for one don't find QOD a source of obtuse information.  I most often find the questions interesting, especially this one which - upon further investigation - shows that REPLICATE...

This may not be at all elegant, but why don't you simply remove all privileges of Test_Read?