+1 to have found the correct post in the blog of Brent Ozar.

It is not the 1st time that the BOL documentation is "light" and incomplete.

I found the good answer...

Thanks for this easy question : the use of PIVOT in a recursive CTE is an error since the release of SQL Server 2012 , something I learnt during a...

Hi Lynn ,

+1 for your reply to the last post of Celko .

It is not the 1st time that Celko was writing posts which are showing how he is respecting...

+1

Thanks to have provided the solution .

Thanks for this question which seems very simple and evident ( at least it is my own opinion ).

I am surprised that only half of the voters have found the...

+ 1 Tom.

I am thinking that it is only a discussion about the meaning of words which is really far from the topic of the original question.

I think that you...

+1 for the last reply of Steeve . A good question is really difficult to create without giving too many clues for the solution especially when a question must be...

Just a little add-in to my previous reply.

The link is a full mystery for me. I have understood nothing. I will try to test and understand to-night ( 13:11...

in , I found in the last line of the last part of the article ( Limitations of the xml data type ) :

"It ( xml data type )...

An excellent article about a topic I have never need to use. It is why I am keeping the default value to OFF.

But I think I will test shortly...

Another explanation has been given in a session of the SQL Server 2012 Days in Paris by a person of the SQL Server Support. In a slide , there was...

+1

I have studied CLR for SQL Server 2005 ( long time ) and I knew that the Host Protection Attribute was linked to the Code Access Security ( from a...

Hi SQL-DBA-01 ,

it seems that KEEPPLAN is for mainly for queries using many temp tables

See :

I found only these links which could be interesting for you.

Thanks for this easy question because , to help a friend , I had to read both books from Kalen Delaney about the storage engine 2005 and 2012 ,...

Thanks for this question I faced unsuccessfully during an interview. The interviewer has taken time to explain the good answer.