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))

,...

Thanks, Steve for this question, which highlights that the use of SELF is really dangerous. 🙁 If you create a procedure and add WITH EXECUTE AS SELF to it, anyone...

Never knew of it. Thanks, Steve for sharing.

+1, interesting is also calculating a value of tf-idf, see e.g. http://www.tfidf.com/

A useful question with a really interesting script and a very good explanation. Thanks, Steve. 🙂 A more detailed description can be read in

https://www.mssqltips.com/sqlservertip/2894/understanding-grant-deny-and-revoke-in-sql-server/

Thanks Steve for this interesting question. Clearly it is described in the section "Are there any restrictions That limit the Resources of the Governor's effectiveness ?" here:

http://searchitchannel.techtarget.com/feature/FAQ-Using-Resource-Governor-in-SQL-Server-2008-R2-to-allocate-resources#question2

Thanks for the question, Steve, even with a wish. It is good that the good mood is back 🙂

sipas (5/12/2016)

---

Richard Hendrick (5/12/2016)

---

Indeed. The "limit" in this question is ambiguous. I would assume the limit on CPU using resource govenor would be the hard cap limit, not the...

TomThomson (5/11/2016)

---

It's still wrong. See my earlier comment. In SQL Server 2014, there's...

Fine, just relax. Today's question is probably meant as a joke of the day 🙂

Thanks Steve, for this question about collation and also about stored procedure recompilation. I used the following references:

https://msdn.microsoft.com/en-us/library/ms143726.aspx and https://msdn.microsoft.com/en-us/library/ms190439.aspx