Managing Transaction Logs
A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.
2012-01-03 (first published: 2008-10-31)
71,896 reads
A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.
2012-01-03 (first published: 2008-10-31)
71,896 reads
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish...
2011-11-11
1,577 reads
Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in...
2011-11-09
1,925 reads
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,672 reads
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
749 reads
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
2011-09-01
7,783 reads
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,179 reads
Coming to the PASS Summit in October this year? Excellent!
I say excellent, because Grant (blog|twitter) and I are presenting a...
2011-08-09
766 reads
A wrap up from MVP and expert Gail Shaw on her experiences of training with SQLskills.
2011-07-27
798 reads
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,243 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers