DCPeterson (5/31/2011)

You are correct. SELECT is part of DML and it even starts its own transaction (assuming implicit transactions) just like INSERT, DELETE, UPDATE... I think the confusion...

Mad Myche (5/31/2011)

---

The SELECT statement may be part of DML, it all depends on the context and who makes the decision. A straight Read-Only SELECT does no manipulation so it...

I haven't read all posts but...

DML is not Data Modification Language. It means Data Manipulation Language and the SELECT statement is also part of it.

Anyway great article. 🙂

I've never seen...

Thanks for the question.

Now could anyone point to an article explaining what re-entrant means?

Best regards,

Although you may use better methods in SQL Server 2008 now, there are many companies which still run MSSQL 2000/2005 and I appreciate the time you took to write this...

I agree that this overriden property behaviour should be better explained in the BOL.

I got it right because I have met this situation before almost by accident.

It offers some flexibility...

Tricky question.

I knew that data compression was only available in the Developer to Enterprise and higher editions but I never tried restoring a compressed backup in a Standard Edition before.

Well,...

Thank you for a great article, Brian.

Nice to see the logon triggers used in a real and useful situation although you explicitly stated that this may not be applied to...

Great question.

I also thought that FKs were made for PKs only. :w00t:

Thank you.

Best regards,

Fortunately I got it right because I somehow knew it'd be a tricky question and I'm studying the new data types in MSSQL 2008. 😀

But I've never tested them that...

Very concise and a great selection of best practices. I will study your advice on filegroups more closely. This is one of those articles that make me keep visiting SQLServerCentral.

Thank...

Thank you for your article, Patrick.

Not only does it cover the implementation of EXECUTE AS but it also demonstrates a very interesting example of certificates and builtin criptography. Much appreciated...

Earlier today before this article was posted I was making an example and showing it to a workmate that it was almost identical to the provided example. I used CTEs...

michael.kaufmann (7/22/2010)

---

Wayne,

first of all thank you for compiling a QotD.

However, I do not quite agree with the solution.

'Unique' is just taking the definition of a clusterd or non-clustered index a...

Amazing article and thanks for the procedural VS set-based analysis with examples.

Much appreciated. 😎