Thanks for this easy question. I had only to remember the 3 sessions I have attended during the Techdays and SQL Server days in 2014 ( I have missed...

Thanks for this interesting question.

I have been able to find the good answer only because on last Sunday , I had to fight with the BOL to understand how to...

Thanks for this easy question . Last month , I had to do some search about the state of a database and I found what I wanted in the sys.databases...

Good question about qq. I knew the answer because I got the same one during a job interview ( I got also the good answer because , before this interview...

Thanks for this interesting question. I knew the answer for the 2008 version ( up to 2014 ). For 2000 I used in only in 2003/2004 , for 2005 I...

Another week-end question for tired DBA.

As nowhere in the query I have not seen explicitly a type ( Date , DateTime ... ) , I concluded that it will...

Good question but I have read it too quickly so I gave only Database as answer. Bad luck...but I would have forgotten Endpoint...

Thanks for this interesting question about a topic that I have not used since 4 years after I attended a session about geometry/geography at SQL Server Days.

Thank you for this excellent post but I am thinking that you have missed several points about SMO.

1) SMO appeared with SQL Server 2005 and this version was not good...

A new week-end question but as Carlo noticed it , an easy one for programmers in C# ( or more generally C ).

Thanks for it.

Still a week-end question for tired persons.

It is an easy question to reply as soon as you know that a variable declared thru the Declare statement is...

Easy question as I have used it last month on versions 2012 and 2014 , but I had hesitated a little moment as I was thinking about a possible...

Thanks Gary for this nice QOD even if I have hesitated during 15 minutes because I detected the 3rd choice as the good one but I was thinking of a...

Thanks for this nice question which gives me one point easily on SASS , a topic I have rarely used. I must confess that I am receiving MSSQLTIPS every day...

Interesting question but an easy one , maybe a too easy one as I found the "good choice" only after the 2nd choice ( COUNT(100) is the same one as...