Want to 'trick' SQL Server into performing millions of logical reads to return data, when only are few thousand were really required? In this article, Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the point that it generates and reuses very inefficient execution plans.
2015-09-21
3,875 reads
Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure
2015-09-18 (first published: 2014-01-20)
39,467 reads
Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process large amounts of data. Do we need these techniques now that we can express a SQL task in terms of window functions? Kathi revisits a famous SQL challenge to find out.
2015-09-18
4,213 reads
Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.
2015-09-17
4,246 reads
If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the secondary replica databases with the primary replica - but there are multiple ways to do this. Jonathan Kehayias goes through each, explaining their different benefits and drawbacks.
2015-09-17
2,771 reads
Marcin Policht gives an overview of automated management features based on the SQL Server IaaS Agent Azure VM extension.
2015-09-16
5,861 reads
Read a call to get started using Version Control with your database code with a few ideas on how this can help you.
2015-09-15
6,205 reads
If you don't feel that you are getting helpful and comprehensive feedback from code reviews, it may well be your fault. Unless you are considerate to your reviewers in a number of ways, they might find it difficult to check your code and provide helpful advice. What ways? Michael Sorens outlines the eight golden rules that, if you follow them, might even even make your code a pleasure to review!
2015-09-15
6,927 reads
2015-09-14
2,402 reads
Jeffrey Yao suggests a solution to validate Excel data via PowerShell and Regular Expressions.
2015-09-14
3,457 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Reschedule tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
Refund tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
Tlpn/wa0853.7373-7551 Ruko Mall Of Indonesia Blok B 32-33, RT.18/RW.8, Klp. Gading Bar., Kec. Klp....
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers