How To Write Better Queries WebCast
One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek...
2011-02-22
810 reads
Blog Posts
Shameless Self-Promotion - Introduction to SQL Server [Book]
My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The...
2011-02-22
954 reads
SQL Saturday 67 Chicago Pre-con
We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the Hampton Inn right around the corner from the SQL...
2011-02-22
19 reads
SQL Saturday 67 Chicago Pre-con
We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the...
2011-02-22
938 reads
SQLDIY: Manage and Monitor SQL Server Yourself
As an old school DBA and always having cheap frugal employers, I have rolled my own management and monitoring solutions....
2011-02-22
576 reads
SQLskills Immersion Event on Internals and Performance – Day 1
Sonny Bryans Smokehouse Bbq would make an interesting classroom
Today was the first day of my first SQLskills event. The event...
2011-02-22
444 reads
T Minus Three Days to the MCM Test
I take the MCM test on Friday. I’ve been watching videos and reading white papers and blogs for the last...
2011-02-22
1,362 reads
What Should PASS Be?
Andy Warren posted a question the other day (well, issued a challenge actually), “What Should PASS Be?” I’ll let you...
2011-02-22
712 reads
A Wireless Production Server? Sure, Just Enable the Wireless Networking Feature on Windows 2008
Since I have Enabled Wireless on Windows Server 2008, and picked up a better-than-average Asus N wireless card, handling the...
2011-02-21
800 reads
Backups after a DR Restore – MCM
If you have a disaster, and you need to restore to some point in time prior to the last log...
2011-02-21
801 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