Really odd question, unreal. Proves that it is not easy to build up a QotD.:angry:

Thank you Steve, not only for the very practical question ,

but also for being reminded to do the installation of MS SQL Server 2014 SP2.

+1 😉

Thanks Steve and happy weekend to all.

+1

Very interesting is also this article:

http://sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014

+1

The question is interesting, the typos I don't mind, at least I learned

again something new. Documentation is at a good level. Thanks,...

It is good to occasionally repeat the useful things. Thanks Ben for a good question and sharing.:-)

Thanks Steve, a nice question for a good start into the new week. 🙂

+1

Thanks Steve. It's interesting, but not exactly an easy question. 😉 Here is another link to a clear and concise explanation:

https://blogs.msdn.microsoft.com/psssql/2015/03/06/does-rebuild-index-update-statistics/

Thanks Steve, for the interesting question, again I had to repeat the TL 🙂

Well it's described in this article:

https://www.sqlservercentral.com/articles/Administration/100856/

Thanks for your interesting note and the link. For the SELECT * you can...

Thanks for the question Steve. It's a hard thing. Different authors have reported different algorithms. If you apply the algorithms listed in the links below, then the correct answer to...

Thanks Junior for an interesting question with carefully worded answer options 🙂

Thanks Steve for an interesting question and precise explanation. Funny thing is that the answer was easy to find in the article "Aunt" Kathi Kellenberger in SSC Newsletter last Friday.

I repeated again the theme Encryption Hierarchy and Certificates 🙂 Thanks, Igor for this question and a clear explanation.

Happy beginning of a new week, try this :-):

DECLARE @Mytest TABLE (id INT, x XML);

INSERT @Mytest VALUES

(1, CAST(1200 AS XML))

,...