Good question 🙂 Scary idea you've come up with! 😎 ... I don't want to think about number of places that might be vulnerable to that

Very good question 🙂

Tests number of areas of knowledge .. what something logically represents vs. what is physically represents

😎

Standard and expected behaviour by SQL :/ SQL devs just have to be aware of it, not really an issue for MS to fix (as there isn't one):cool:

Don't rubbish the editor 🙂 Busy guy and good good site!!! So what if occasional question gets through that gets some people riled, surely some questions should?

🙂 Agree with the above 🙂 question setters please check all answers first 🙂

This has what to do with SQL ... ?

... and the question isn't exactly clear.

I think this is one that could have done with wider 'review' (as with yesterday's question)...

?? Correct answer: SQL Server 2005 RTM

Explanation: SQL Server Service Pack 2 or greater is needed to be fully compatible with Windows Vista and Microsoft Office...

hmmm maybe over-engineered? Surely variable checking should be at presentation tier?

I've grown allergic to dynamic-SQL, tended to find it such a performance killer and generator of bugs in its own...

.... 4 surely - this included AFTER and INSTEAD OF and CLR, so we had to select this even though it also included FOR (even though this isn't really a...

I'm afraid the answer is wrong .... saying that the CLR trigger isn't a DML trigger because they can also be DDL triggers is just daft

Don't know how poster will...

Hi Hugo,

Thanks for pointing out this side of the equation.

Interestingly, according to Microsoft's study guide for 70-443 ... (p. 33)

RAID 1 - Good Read, Acceptable Write

RAID 5 - Excellent read, fairly poor write

As for whether RAID 5 is better...

?? My BOL says:-

"Requires USE permission. USE permission is granted by members of the dbo or sysadmin fixed server roles by executing sp_adduser; or by members of the sysadmin fixed...

Not quite true, according to BOL ...

"The minimum permission required is ALTER on table_name."

DDL_Admin etc. are amalgams of more granular permissions, which can be granted/denied individually (surely?)

Is the document http://msdn2.microsoft.com/en-us/library/ms141766.aspx indicating that 32-bit DTS packages should be run via the Execute DTS 2000 Package Task in SSIS (and that this can be done in...