Viewing 15 posts - 3,046 through 3,060 (of 8,761 total)
Stuart Davies (10/19/2016)
Ed Wagner (10/18/2016)
Ray K (10/18/2016)
djj (10/18/2016)
ZZartin (10/18/2016)
Luis Cazares (10/18/2016)
Manic Star (10/18/2016)
djj (10/18/2016)
Ed Wagner (10/18/2016)
whereisSQL? (10/18/2016)
Revenant (10/18/2016)
crookj (10/18/2016)
djj (10/18/2016)
Grumpy DBA (10/18/2016)
BWFC (10/18/2016)
CurrentCurrant
Food
Hungry
Hungary
Europe
Brexit
Vote
Drink
Martini
Dirty
Clean
Mr.
Anderson
Tapes
Backups
October 19, 2016 at 12:38 am
Jeff Moden (10/18/2016)
Eirikur Eiriksson (10/13/2016)
Further on Jeff's fine reply, here is an example of "Generic" table auditing with few extras for education and entertainment.
Correct me if I'm wrong, please. ...
October 19, 2016 at 12:19 am
rkrpat (10/18/2016)
October 18, 2016 at 11:23 pm
Bruce-12445 (10/18/2016)
Correct me if I'm wrong: I'll create...
October 18, 2016 at 10:56 pm
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
Viewing 15 posts - 3,046 through 3,060 (of 8,761 total)