When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.
It pays to continuously learn more about your job. SQL Server is so large, it really is a lifelong effort to drive yourself forward to master more and more.
As winter approaches, many of us get ready in our personal lives, but Steve Jones notes that we might want to make sure we have regular preparation taking place on our systems for difficult times.
In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.
It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model introduced in SSIS 2012. Where there are tens or hundreds of SSIS packages to deploy, this system is essential.
This Friday Steve Jones is looking to see what data you're tracking about your life.
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.
What do you do when you want to receive critical server health alerts?
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers