(2021-Apr-23) Memory is an interesting thing, you may not remember all events from your past, but some sparking moments keep extending their bright beams of light. With the growing time...
2021-05-05 (first published: 2021-04-23)
372 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-04
8 reads
Looking forward to speaking to a brand new conference for us, the Minnesota Developers Conference 2021 on May 4 at 2pmCT. Christine and I will be presenting a talk that...
2021-05-04
14 reads
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to ... Continue reading
2021-05-04
125 reads
Recently I’ve been delving into Chaos Engineering, reading books, watching videos, listening to podcasts etc. and I find it really intriguing….I mean, it just sounds exciting, right? CHAOS Engineering!...
2021-05-03 (first published: 2020-01-29)
309 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-03
3 reads
Foreign keys help to ensure referential integrity between tables. In other words, parent records cannot be deleted if there are child records present. This is a great thing and...
2021-05-03 (first published: 2020-01-31)
515 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-05-03
7 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-05-03
10 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-05-03
6 reads
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers