Viewing 15 posts - 166 through 180 (of 319 total)
Nice one, thanks Steve. Who solved the Qotd 27.5.2016 shouldn't have a problem. Using
EXECUTE AS SELF is explained here: https://technet.microsoft.com/en-us/library/ms178106(v=sql.105).aspx
January 18, 2017 at 5:40 am
January 12, 2017 at 5:12 am
Rune Bivrin (1/5/2017)
Thank you very much, Uwe!That was a very enlightening question and explanation. Definitely something to add to the tool belt for those pesky edge cases.
Igor Micev (1/5/2017)
None...
January 5, 2017 at 10:10 am
Thanks Steve for the first question of this year. It's an interesting topic, because in MS SQL Server 2016 Entreprise Edition it's quite different, see e.g.
January 2, 2017 at 6:15 am
Thanks to Steve and all those who are preparing for us QotD, I wish you good health and good luck in the new year! 🙂
December 30, 2016 at 5:43 pm
edwardwill (12/21/2016)
The article you cite in support of the answer is silent on the limits to the size of the input string.
Yes in the MSDN HASHBYTES (Transact-SQL) there is no...
December 21, 2016 at 6:07 am
If you were looking for information on this MSDN article https://msdn.microsoft.com/en-us/library/hh710053.aspx ,
the answer would not be easy. I would probably give 1..100. There is no explanation of the value of...
December 19, 2016 at 7:02 am
Simple, but interesting question, thanks Steve. But I shot on Google today too hastily and missed. It was necessary
to start shooting from the MSDN https://msdn.microsoft.com/en-us/library/cc645993.aspx ... :crying:
December 16, 2016 at 5:14 am
sknox (12/15/2016)
Yes, the TechNet article is inaccurate. As per the MSDN documentation (https://msdn.microsoft.com/en-us/library/ms186755.aspx), the parentheses are optional.
+1
and still it is necessary to read in the MSDN https://msdn.microsoft.com/en-us/library/ms191007.aspx
slowly and carefully the...
December 15, 2016 at 7:16 am
paul s-306273 (12/12/2016)
Stewart "Arturius" Campbell (12/11/2016)
Interesting question today, thanks SteveLearned something new.
+1
Yes, +1
And thanks Steve for this question and the useful reference on Windows PowerShell Tutorial.
December 12, 2016 at 5:25 am
sipas (12/8/2016)
Luis Cazares (12/8/2016)
I need to ensure the databases are backed up while...
December 8, 2016 at 2:14 pm
Interesting question, I had to for sure a little search in MSDN. :unsure: Thanks for this reminder Steve.
December 2, 2016 at 5:47 am
Easy one, it is useful to know how to use sp_MSforeachdb. Thanks for this question Partha.
November 30, 2016 at 5:52 am
sipas (11/24/2016)
Actually it doesn't even work for this year.
SELECT DATEPART(DAYOFYEAR, SYSDATETIME()); gives 329
SELECT DATEDIFF( DAY, '20160101', SYSDATETIME()); gives 328
Happy Thanksgiving to all in the...
November 24, 2016 at 7:31 am
Great question. A very useful feature, thanks Steve.
November 22, 2016 at 7:28 am
Viewing 15 posts - 166 through 180 (of 319 total)