Viewing 15 posts - 3,046 through 3,060 (of 8,753 total)
Lynn Pettis (10/18/2016)
Eirikur Eiriksson (10/18/2016)
ZZartin (10/18/2016)
Brandie Tarvin (10/18/2016)
Eirikur Eiriksson (10/18/2016)
Just had a Blast from the past😎
Wait... 11 - 13k of RAM? 32-bit?
Where did you dig up this dinosaur? @=)
Damn...
October 18, 2016 at 3:10 pm
rkrpat (10/18/2016)
October 18, 2016 at 3:00 pm
Piling on
IF trigger_nestlevel() > 1 RETURN
Are you using nested triggers?
😎
SET NOCOUNT OFF
Don't need to do this, it has a session scope so useless.
October 18, 2016 at 2:31 pm
Krasavita (10/18/2016)
Do you have any idea how long it might take to sql backup for 600 gb.Thank you
Finger in the air type guess, 8-16 core VM with a 10Gb SAN...
October 18, 2016 at 2:10 pm
ZZartin (10/18/2016)
Brandie Tarvin (10/18/2016)
Eirikur Eiriksson (10/18/2016)
Just had a Blast from the past😎
Wait... 11 - 13k of RAM? 32-bit?
Where did you dig up this dinosaur? @=)
Damn I was 11 years...
October 18, 2016 at 1:50 pm
Sue_H (10/18/2016)
coolchaitu (10/17/2016)
I had applied CU7(cumulative update 7) to SQL Server 2012 EE SP1 instance. After applying, when i queried SELECT SERVERPROPERTY('ProductUpdateLevel'), it is displaying as NULL instead...
October 18, 2016 at 11:01 am
Just had a Blast from the past
😎
October 18, 2016 at 9:50 am
Piling on, using either 19000101 or 99991231 as a date key for missing dates is generally not a good idea and can produce very hard to unravel mess in the...
October 18, 2016 at 4:22 am
coolchaitu (10/17/2016)
I had applied CU7(cumulative update 7) to SQL Server 2012 EE SP1 instance. After applying, when i queried SELECT SERVERPROPERTY('ProductUpdateLevel'), it is displaying as NULL instead of...
October 17, 2016 at 9:33 pm
Jeff Moden (10/17/2016)
aaron.reese (10/17/2016)
When you do code-first designHeh... "Never". 😛
+10000000000000000000
Spent years on fixing that kind of cock-ups, makes me wonder about the evil that men do (sorry CB, wherever...
October 17, 2016 at 10:11 am
Jeff Moden (10/16/2016)
Eirikur Eiriksson (10/15/2016)
Here is a more efficient alternative, beats the c..p out of the string splitting functions
VERY cool concept but, in this case, it appears to be coming...
October 17, 2016 at 12:35 am
Looks fine to me, normally I script transferable logins from the source and after attachment then run the scripts on the destination.
😎
Quick question out of curiosity, why SQL Server 2014...
October 16, 2016 at 5:47 am
ScottPletcher (10/14/2016)
Here's a simple, brute-force -- but still no looping -- method, if you prefer that.
Not very efficient with 7 x ( source scan -> Filter -> Compute Scalar ->...
October 15, 2016 at 6:15 am
rajemessage 14195 (10/15/2016)
now u have written N which is also good , but i am trying...
October 15, 2016 at 5:20 am
karthiknfr_1991 (10/14/2016)
October 15, 2016 at 2:45 am
Viewing 15 posts - 3,046 through 3,060 (of 8,753 total)