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,365 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,365 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
610 reads
I meet Steve when he came down from New England area for SQL Saturday #28 IN Baton Rouge, LA. He...
2012-02-15
738 reads
I will be speaking at the February Baton Rouge SQL Server User Group meeting on Wednesday the 8th. The session...
2012-02-06
673 reads
Janet, my girlfriend, and I went to Colorado Springs a day early, Thursday, to ski on Friday before SQL Saturday...
2012-01-25
706 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
492 reads
January 8th, 2012 will be the first SQL Saturday for 2012. 104 SQL Saturdays is an amazing number for our...
2011-12-23
758 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
511 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
529 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,703 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers