Viewing 15 posts - 166 through 180 (of 715 total)
patricklambin (4/3/2015)
- Plenty of RAM : too easy to be the good choice
- to use OPTIMIZE : never seen...
April 5, 2015 at 2:39 am
W0w, very new 2 me, never tried this b4, thanx.
April 5, 2015 at 2:22 am
SQL-DBA-01 (3/29/2015)
I explored more on the cause.
•You must remember to terminate the statement preceding the CTE with a semicolon, otherwise SQL will throw this...
March 30, 2015 at 6:08 am
Options 2,3,4 gave the exact same result!
March 28, 2015 at 11:32 pm
Ed Wagner (3/27/2015)
I don't use Powershell, so this was a complete guess for me.
Same 🙂
March 28, 2015 at 11:25 pm
Ivanova (3/25/2015)
Don't get too fond of SETUSER. It's been deprecated 😉
It is still in production till version 2014; I am not using it anyway, but it`s not bad to learn...
March 26, 2015 at 2:35 am
I found it very interesting that you could declare '@' as a variable. I did not know that. I could see this happening accidentally at some point, so...
March 24, 2015 at 7:10 am
Very interesting question, thanx.
March 22, 2015 at 3:05 am
Eazzzzy, I think this is the fastest question I ever answered in QotD 😀
March 22, 2015 at 1:16 am
SQLRNNR (3/9/2015)
Toreador (3/9/2015)
Hany Helmy (3/8/2015)
Never used it before SETUSER, but very good question despite of the date issue.
I'm not sure that it is a terribly useful question. What benefit is...
March 19, 2015 at 4:30 am
Koen Verbeeck (3/19/2015)
I need coffee. I was wondering for a minute why I had already answered this question while I just logged on into my computer...
😀
March 19, 2015 at 4:29 am
I though it`s not working with Express edition! good that I made same R&D b4 answer 😉
March 17, 2015 at 10:50 pm
Viewing 15 posts - 166 through 180 (of 715 total)