Cardinality Estimation for a Predicate on a COUNT Expression
Paul White takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.
2017-05-17
3,222 reads
Additional Articles
Encrypting SQL Server: Dynamic Data Masking
Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.
2017-05-16
3,672 reads
Backing Up SQL Server Databases Hosted on Azure VMs
Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.
2017-05-15
2,743 reads
Why people flocked to the SQL Clone live stream event
On March 29, over 650 people tuned in from around the world to find out more about Redgate's new database provisioning tool, SQL Clone. The webinar answered the FAQs, included some in-depth demos, and gave a look into the technology behind the tool. Catch up with the recording.
2017-05-15
5,212 reads
Backup and restore of a SQL Clone
SQL Server sees the cloned database as a user database, meaning that you can treat it as one, including backup and restore - Steve Jones explains.
2017-05-12
3,815 reads
Displaying Backup or Restore Progress
Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.
2017-05-12
4,017 reads
Performance Myths: Table variables are always in-memory
Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.
2017-05-11
5,730 reads
SQL Data Mask: now featuring configurable masks
SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details.
2017-05-10
4,085 reads
Basic data masking for development work using SQL Clone and SQL Data Generator
This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.
2017-05-08
3,810 reads
Deploying Multiple SSIS Projects via PowerShell
When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky. Nat Sundar describes how he created a Deployment script that is intended to provision a Data Warehouse for System Integrated testing (SIT).
2017-05-08
5,786 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers