Execution Plans – Nested Loop
The nested loop is a physical operator used to join 2 or more sets of data when the query optimizer...
2012-03-09
1,362 reads
The nested loop is a physical operator used to join 2 or more sets of data when the query optimizer...
2012-03-09
1,362 reads
Nothing like a 24 hour barrage of SQL Server training for FREE!!! Did I mention it was free?
The PASS Data...
2012-02-27
607 reads
I meet Steve when he came down from New England area for SQL Saturday #28 IN Baton Rouge, LA. He...
2012-02-15
735 reads
I will be speaking at the February Baton Rouge SQL Server User Group meeting on Wednesday the 8th. The session...
2012-02-06
669 reads
Janet, my girlfriend, and I went to Colorado Springs a day early, Thursday, to ski on Friday before SQL Saturday...
2012-01-25
704 reads
Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011...
2012-01-17
488 reads
January 8th, 2012 will be the first SQL Saturday for 2012. 104 SQL Saturdays is an amazing number for our...
2011-12-23
754 reads
Subject: Row Versioned Data WarehousesLevel: 200-300 (Intermediate)
Start Time: Thursday, December 15th, 2011 8:00 PM US Central Time
Presenter: Jeremy Huppatz...
2011-12-14
508 reads
Subject: On beyond Zebra AdventureWorks or where did I go wrong?
Level: 200 (Intermediate)
Start Time: Thursday, November 17, 2011 8:00...
2011-11-15
526 reads
It has been a couple of weeks and I have had time to get back in the groove at a...
2011-10-28
1,697 reads
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
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