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

I am sorry. Note above I wanted send to Mr. tripleAxe.

You got it right!

With the words of the poet Shakespeare: Much Ado About Nothing. Steve has done a little typo only.

The result is always 65, even if you run eg....

I'm surprised that in the BOL is stated: "Dates cannot be specified; therefore, the date part of the datetime value is not allowed." But the following script can be used...

Thanks for this question. Perhaps even note that the vardecimal storage format is deprecated

and sp_estimated_rowsize_reduction_for_vardecimal is available in SQL Server Enterprise Edition only.

Thanks for this question Steve. Today I had to do with the question of a hard time, really dangerous.:-) Eventually helped me this article, which confirms that it is dangerous:...