Finding Key Lookups In Cached Execution Plans
Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe...
2010-07-29
5,317 reads
Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe...
2010-07-29
5,317 reads
Now that the PASS SQLRally (formerly known as the spring event) has a name it's time to start building a...
2010-07-22
678 reads
In case you missed it the Program Session (60 min. long) selections are now available on the 2010 PASS Summit...
2010-07-21
504 reads
If you're a PASS member you may have noticed in this morning's Community Connector that the 2011 spring event I...
2010-07-14
541 reads
I received an unexpected but certainly not unwelcome email last night letting me know that I've been selected to present...
2010-06-23
412 reads
In March of this year the PASS Board of Directors began kicking around the idea of holding some kind of...
2010-06-21
878 reads
On Tuesday, June 15, I'm presenting Paging DR Availability, You're Wanted in the Recovery Room at the Orlando SQL Server...
2010-06-10
415 reads
I submitted three abstracts for the 2010 PASS Summit this year - two "normal" (75 minute) and one spotlight (90 minute)...
2010-06-08
475 reads
I've been published! My article Troubleshooting Transactional Replicationis featured in the June 2010 issue of SQL Server Magazine (subscription required...
2010-05-28
1,922 reads
Note: This is a very non-SQL Server related post. If you don't want to read something personal about me feel...
2010-05-11
852 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