The identity column, the insert and the linked server.
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted...
2018-06-14
551 reads
Kenneth Fisher
What queries are getting blocked?
Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how...
2018-06-14 (first published: 2018-06-06)
2,689 reads
Interview questions: What’s the first thing you would do if a user reports slowness.
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...
2018-06-08 (first published: 2018-05-28)
4,100 reads
SQL Homework – June 2018 – Alter a database
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL...
2018-06-04
244 reads
Updated query to view data in the error log
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...
2018-05-31
382 reads
The public role
A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....
2018-05-23
473 reads
What are the system databases?
I get to help with technical interviews every now and again, and one of the questions we always ask is...
2018-05-21
519 reads
Why I blog: TSQL Tuesday #102
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given...
2018-05-18 (first published: 2018-05-08)
1,821 reads
The trials and tribulations of REVERTing from impersonation
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure...
2018-05-16
391 reads
Blogging and when to keep your big mouth shut
I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few...
2018-05-14
498 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers