Using OVER() to Remove Duplicate Rows
Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.
2016-11-08
6,980 reads
Mike McQuillan
Using OVER() to Fix Bad Version Numbers
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,408 reads
Guide to MCITP: SQL Server 2008 BI Developer
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,416 reads
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
9,024 reads
Guide to MCITP: SQL Server 2008 Developer
An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.
2009-08-21
10,663 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
Question of the Day
BIT_COUNT II
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