Find Queries Using a Key Lookup Operator
While teaching about Extended Events and Execution Plans last week, Jason, one of the people in the class, asked: Is there a way in Extended Events to find queries...
2021-06-14
6 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Database Fundamentals #30: Create Foreign Keys With T-SQL
You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...
2021-06-07 (first published: 2021-05-24)
430 reads
Database Fundamentals #30: Create Foreign Keys With T-SQL
You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...
2021-05-24
5 reads
Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-19 (first published: 2021-05-10)
539 reads
Query Store on Azure SQL Database
Under the covers, Azure SQL Database is just good old fashioned SQL Server and this includes Query Store on Azure. While many things can be different when working with...
2021-05-14 (first published: 2021-05-03)
209 reads
Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-10
5 reads
Using Extended Events Live Data With Azure
In my last post I showed some shortcomings of Extended Events, however, it is possible to use Live Data with Azure. Let’s explore exactly how that works. To get...
2021-04-26
29 reads
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow the system. While Azure provides all sorts of wonderful assistance within Azure SQL Database, you’re...
2021-04-22 (first published: 2021-04-19)
211 reads
Extended Events: Embrace the XML
While XML is, without a doubt, a giant pain in the bottom, sometimes, the best way to deal with Extended Events is to simply embrace the XML. Now, I...
2021-04-12 (first published: 2021-04-05)
242 reads
Extended Events: Avoid the XML
One story I hear over and over goes like this: I tried setting up Extended Events, but then I saw the output was XML so I stopped. Look, I...
2021-04-08 (first published: 2021-03-29)
372 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers