So what's the value of SQL 2008 cmptlevel? 10, 100? I don't have CTP installed anymore sorry...

Thanks both Jeff and Hugo for the great article and the argument.

It re-affirms the standard DBA answer to any question: it depends;)

Kudos to both of you.

I think the question is for distributed transactions, not for distributed queries.

My understanding is a distributed transaction involves changes, and ACID applies. So the valid choices were SQL 7 and...

Does anyone know the Microsoft.Jet.OLEDB.4.0 engine works with 64-bit SQL 2005 server?

I got this error when accessing a text file using OPENDATASOURCE with Microsoft.Jet.OLEDB.4.0 as the provider:

Msg 7403, Level 16,...

Are we testing SQL knowledge, or English grammar;)

Of course I got it wrong by answering A

This is a great list. My suggestion would be to specify if a cumulative update is public downloadable or not.

As far as I know (I could be way wrong, though),...

It shows geeks don't have humor:hehe:

Prashant Pandey (12/12/2007)

---

Yelena Varshal (12/12/2007)

---

I was surprised at the logic:

"....This link also contain CLR Triggers but they can also be a DDL trigger that is why they cannot be count...

To whomever creeated this question, please check BOL, under "Types of DML Triggers" topic.

It clearly states there are three types of DML triggers. But if you count the FOR trigger,...

To add the list of recommended readings regarding parsing a delimited string, I find Erland Sommarskog's articles are very helpful:

http://www.sommarskog.se/arrays-in-sql-2005.html

http://www.sommarskog.se/arrays-in-sql-2000.html

The 90-day pwd changing policy is set by my security team, not me--otherwise I'd set to 90,000 days;). Their argument is: if any pwd that is generated by us and...

I answered FAT, NTFS, and RAW.

MS discourages RAW file system. But it doesn't say SQL cannot install on RAW.

http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

How do I get 1 point back;)

I have some questions regarding implementing encryption at database level:

Our security people wants to change keys every 90 days. Do I need to

1. change the pwd at service master key?

2....

Very informative. Keep on going!