Viewing 15 posts - 1 through 15 (of 94 total)
We limit GOTO to a single use-case: DEADLOCK Mitigation loops. We have two SSMS templates: TRAN-bound multi-statement, and Atomic. Commented boilerplate TRY-CATCH code gets the retry loop controls from persisted...
July 19, 2021 at 3:24 pm
Hoping the broken links can be mended... please...
Thanks for re-posting as an editorial - may just be at the right time for a hell-hole of an "unknown" attributes per customer...
August 15, 2019 at 4:59 pm
Excellent extension of Conway's Law - precisely the word used here to describe the c*** frequently encountered, authored by devs at customer sites. But why? Perhaps a major contributor is...
June 28, 2019 at 5:50 pm
LMA was a solution proposed by a Red Gate tech, as SSMS since day 1 of SSMS 2016, let alone 2017, has regularly crashed. I'm not alone with these crashes...
August 8, 2018 at 1:13 pm
August 8, 2018 at 12:32 pm
Yes, this is a slightly negative post!
SIX "SSMS has stopped working" events in succession, just because I need twenty script windows open, and connected to 3 instances, and, and,...
August 8, 2018 at 12:02 pm
Win7 to Win10 - faultless, even on a 2010 Lenovo T61p that accepted a Samsung SSD after a BIOS upgrade. Go the whole hog, said I.
Set it to defer...
March 15, 2016 at 3:36 pm
We sadly lost our original customer and the loss seems irrevocable. Thus, why leave their millions of records in our 10Bn row raw-data table?
So I'm building a somewhat intelligent...
April 1, 2015 at 11:04 am
Steve Jones - SSC Editor (2/27/2015)
Xavon (2/27/2015)
My company uses Express on remote terminals (a couple hundred of them) that replicate up to Enterprise edition on our main server.
I've seen this,...
February 27, 2015 at 10:42 am
Will there be a 14.x article that shows Configuration Properties being converted to Parameters, please?
Or is there already somewhere that this is adequately dealt with on a.n.other site?
Thanks.
January 23, 2014 at 5:23 pm
BigSam (5/23/2013)
We also...
May 23, 2013 at 11:16 am
Adding a CERTIFICATE causes the Schema Tracking trigger to fail - red ink everywhere... SQL2005, but syntax is unchanged for SQL2012. SQLCmd cannot be NULL.
May 1, 2013 at 11:31 am
michaelrounds (4/16/2013)
SAinCA (4/16/2013)
Question, Michael: How do I stop the text version being emitted, please? I've disabled the SQL_DBA_vtext Operator but I still get the text notifications.Thanks.
If the CellList field...
April 16, 2013 at 12:09 pm
Question, Michael: How do I stop the text version being emitted, please? I've disabled the SQL_DBA_vtext Operator but I still get the text notifications.
Thanks.
April 16, 2013 at 10:59 am
Viewing 15 posts - 1 through 15 (of 94 total)