Separating Out Indexes
I saw a post recently where someone was asking how to separate out all indexes from the data into a...
2009-10-15
907 reads
Blog Posts
SNESSUG October Meeting
The Southern New England SQL Server Users Group’s October meeting was a bit sparsely attended with 7 attendees. The sponsor...
2009-10-15
704 reads
SQL Lunch/Call for Speakers
Patrick Leblanc has started a new project called…SQL Lunch! The concept is to present a 30 minute topic every two...
2009-10-15
885 reads
SQL MVP Profile of the Week - Michael Coles
As we continue to get ready for the NY\NJ SQLSaturday User Group meeting this October 24, 2009, I had the...
2009-10-15
1,162 reads
SQLSaturday #21 Is Tomorrow (Oct 17)
I’m writing this in advance because I’ll be busy with all the last minute preparations, but I’m looking forward to...
2009-10-15
289 reads
The PASS Board of Directors Election
There has been some great discussion about the upcoming PASS Board of Directors election over on Brent Ozar’s blog. If...
2009-10-15
1,257 reads
120 DBAs and Developers Attend SQL Down Under
The fourth annual SQL Down Under Code Camp was held at Charles Sturt University in Wagga Wagga, Australia this past...
2009-10-14
381 reads
Dev Days – Austin
I’m out of the office today, in Austin, TX (yee-haw!) at the Stack Overflow Dev Days – Austin. There are a...
2009-10-14
761 reads
DRP for SQL Server in French - traduction en français du plan de relève – part 4
La liste des fichiers restaurés devrait se trouver dans le répertoire suivant :
\\ServeurDeBD\Disque$\DirSauvegardesProd\DBlog\
Dès que la restauration a été complétée, nous...
2009-10-14
815 reads
Free T-SQL Database Maintenance Scripts
I often get questions in e-mails, or at user group meetings, for advice on writing T-SQL database maintenance scripts. There...
2009-10-14
4,308 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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