MeMeMe - Meme Monday: What #SQLFamily Means to Me
I've been pretty busy polishing up my SQLInspire NYC talk, when I realized that it's another edition of Meme Monday. The...
2011-11-07
1,699 reads
Blog Posts
My First Blog Post!
So here it is then, my first ever Blog post!
I'm not cheating here as I am not officially starting to...
2011-11-07
578 reads
Reliving Basic Training, Sort Of
Recently I had the luxury of a long afternoon lunch at Chipotle on a Sunday afternoon, catching up on some...
2011-11-07
801 reads
Resolving 701 There is insufficient system memory to run this query
In recent past while working on an assignment I have encounter an error 701 There is insufficient system memory to run...
2011-11-07
1,929 reads
Slide Decks for PASS, SQL in the City, and SQL Server Connections
I’ve sent my slide decks to the organizers, but I know they don’t always get posted. So I’m putting a...
2011-11-07
948 reads
SQL Server 2012: New Certifications
As a follow-up to my post SQL Server “Denali”: New Certifications, the seven exams for SQL Server 2012 are:
Querying Microsoft...
2011-11-07
3,477 reads
SQL Server A to Z – User-Defined Functions
The alphabet is quickly winding down (so sad). We’re up to the letter U and that stands for User-defined functions.
What...
2011-11-07
1,359 reads
SQL server could not start cannot find object or property (0x80092004)
AdvertisementsSQL server could not start cannot find object or property (0x80092004)
Recently I got a call from my team the users...
2011-11-07
8,232 reads
SQL University: Advanced indexing – Sorting and Grouping
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,699 reads
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time will warp on us. The Las Vegas user group...
2011-11-07
4 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