How to Find the Estimation Cost for a Query
Discover how to estimate the cost of a query. Read on to see an example of how to extract the Estimated Cost for execution plans stored in the procedure cache.
Take our short readers’ survey and win a $50 Amazon voucher
Could you spare 3 minutes to help us out at SQL Server Central/Simple Talk? Take this short survey, tell us about who you are and why you come to Simple Talk/SQL Server Central, and you could win a $50 Amazon voucher.
DAX for SQL Folks: Part III - DAX Calculations
Introduction In response to my approach in the pop...
Open Source is Not a Career Path
A reprint from the early days of SQLServerCentral as Steve is on vacation. Here is Steve Jones' Open Source Musings from February 3, 2005.
Improve Row Count Estimates for Table Variables without Changing Code
Table variables can cause performance issues with joins when they contain a large number of rows. In SQL Server 2019, Microsoft has improved how the optimizer works with table variables which can improve performance without making changes to your code. In this article, Greg Larsen explains how this feature works and if it really does make a difference.
Testing SQL Server Stored Procedures and Functions with SQL Data Compare
Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies.
Evaluating Life at Work
It can be hard to evaluate your career and job situation, but Steve has some ideas today.
Can I Offload DBCC CHECKDB To Another Server?
You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing a good job. Who’s a good dog? You are! Good dog.
What is the impact of remote working on estate management?
Distributed workforces have very quickly become the norm. The 2020 State of Database Monitoring survey explores the impact of remote working on estate management and how organisations are responding. You can read the full findings in the free report, here.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers