Communicating Effectively at the Workplace
This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-08
2 reads
This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-08
2 reads
Watch this week's video on YouTube
Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren't aware of how it...
2019-10-01
6 reads
Watch this week’s episode on YouTube. Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren’t aware of how...
2019-10-01
254 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
994 reads
Watch this week’s video on YouTube! A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with...
2019-09-24
56 reads
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
2 reads
This post is a response to this month’s T-SQL Tuesday #118 prompt by Kevin Chant. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...
2019-09-19 (first published: 2019-09-10)
1,120 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
3 reads
Watch this week’s episode on YouTube. Last week’s post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace....
2019-09-16 (first published: 2019-09-03)
521 reads
Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....
2019-09-12 (first published: 2019-08-27)
1,784 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