Good question for which I has hesitated before finding the good answer.

So thanks for it as I have had to dive in my hidden remembrance as I have not...

I have hesitated for 5 minutes and I remembered that we can find synonyms in the expansion sets. It is true I have not used full-text search since 3 years.

Anyway...

Hugo Kornelis (5/21/2015)

---

g.britton (5/20/2015)

---

Great question! It illustrates the benefits and dangers of using unaliased column names in queries. IIRC SQL looks in the current namespace for a match...

Thanks for this question which seems easy according to me.

I was surprised by the low percentage of good choice ( 33% ) , but I understood when I discovered that...

Nice question on a topic which I have rarely used excepted with my old Developer edition 2008.

I have only hesitated about CUM_DIST which I have already seen but for 2012...

Thanks for this interesting question.

I am not usually using ranking functions , it is why I attended a session about them during the last SQL Server Days and the...

Interesting question on a topic ( SISS ) which is not my favorite one.

I think I did not find the good answer because I was thinking only about the special...

Interesting question but an easy one only because I am studying "Microsoft SQL Server 2012 Internals" from Kalen Delaney and I have finished the 6th chapter ( Special Storage a...

Surprised by the existence of the INTEGER type which is not appearing in the list of integer data types which includes only bigint , int , smallint and tinyint ....

Hi Tom ,

Confirmed with this link :

about the system databases.

It has been also the topic of a question in a forum ( other than SQL Server Central ones )...

Question which seems easy according to me.

After the previous question about CTE , I have (re)studied CTE.

For the names of the columns in the display , I am preferring aliases...

You should have a look at this link and you will understand the "good choice"

If you are not registered on the MSDN/TechNet forums , replace https by http at the...

Backwards always supported ? Not sure ...

Because the library is changing and you can have problems with classes changing from dll .

It is why I am always advicing to import...

I knew that the tempdb database cannot be dropped but I have hesitated about the reason. After having thought 2 minutes , I eliminated because it was in use (...

Easy question especially when we know this old post

But when MSDE 2000 was released , the maximum number of connections was 5 ( under some circumstances 10 ).

It remembers...