Lot of TDE questions lately. Is anyone using this feature?

Not sure how 12% missed this one. I'll take the 7 points though.

Everyone should submit a question. It's a great learning experience.

The explanation gives the correct answer and the answer is wrong. I want my points!

I didn't think it was that obvious of an answer.

Good question. I looked at it quickly and would have answered wrong and I hadn't double checked and caught the smalldatetime.

Easy question if you don't talk yourself into thinking it's a trick question.

I learned something new today. Good question.

JTS - yes, I believe you are correct. The exist() method is searching the entire XML document for the argument and is not part of an AND condition for each...

I believe book2 wasn't selected because the Rating was <3 and the query was looking for books with a rating >=3.

Jan has is correct. There is 3 possible returns. If a valid Domain and Group are provided the function will a 0 or 1 depending on whether the user is...

I have never had a need to enable lightweight pooling. We are using CLR stored procedures though and find them very beneficial.

I almost selected all them figuring it was a trick question. I guess that what I should have done because I missed it as well. :unsure:

A quick and dynamic solution would be:

create table #testing (eventname varchar(1000))

insert #testing (eventName) VALUES ('SqlServerCentral website is a great help for me.')

insert #testing( eventname) values ('this is a test -...

SQL Server 2008 has a Date datatype which will solve your problem when you are able to upgrade.