SSG Blog
Insights and news from the SQL Solutions Group.
Recent
Truncate Tables that have Foreign Keys
One of the issues I often run into is the need to truncate very large tables. But if there is a foreign key constraint on
Debugging SQL Server CLR Objects
Just a quick shout out to a great article on how to Debug CLR Projects. https://www.mssqltips.com/tip.asp?tip=1624
SQL Saturday #67 (Chicago)
Headed to Chicago tomorrow for SQL Saturday #67. Heading out a day early to attend a pre-conference seminar on Friday on troubleshooting and performance tuning.
Utah Code Camp
I’ve been doing a lot of traveling lately speakng at SQL Saturday events. This last weekend it was my great pleasure to speak at Utah
This discussion came up on Twitter so I …
This discussion came up on Twitter so I thought I’d blog about it. UPDATE FROM (sometimes called an UPDATE JOIN) is an language construct that
SQL Server Developer Job Description
I was asked by a client today to provide 4 bullet points to include in a job description for a developer position that will be