What happens when you use WITH RECOMPILE
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,319 reads
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,319 reads
I have two new books that I can heartily recommend. This isn’t a review of either book since I’ve only...
2009-08-20
564 reads
Well, actually, these are the guidelines for submitting anything to SQLPASS, but it includes the guidelines for SQL Server Standard....
2009-08-13
1,159 reads
For the one or two you that are not reading Buck Woody’s blog (and why aren’t you), you may not...
2009-08-12
700 reads
My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring...
2009-08-12
618 reads
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
936 reads
I was introduced to the Thrive program when my user group held a Thrive event back in March. Since then...
2009-08-09
543 reads
Hrmmm… 198. Up four pounds. That just doesn’t seem possible. I did a tabata on Monday. I did have a...
2009-08-08
530 reads
The PASS Application Development SIG is hosting a web cast next week on Tuesday where I’ll be presenting Understanding Execution...
2009-08-07
818 reads
I’m fairly certain Jack Bauer isn’t involved with this new initiative from PASS. Just as I’m also certain I won’t...
2009-08-03
727 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