Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,248 reads
Blog Posts
Decompressing on Compression in SQL Server 2008....
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-08-31
9,522 reads
Notes On the Jacksonville Code Camp
I drove up to Jacksonville Friday afternoon for the 2009 Jacksonville Code Camp led by my friend Bayer White. I...
2009-08-31
1,649 reads
Project Gemini
Dan English put up a blog post on his experiences with installing Gemini. His post is loaded with screen shots...
2009-08-31
1,365 reads
Scripting Server Side Traces
If you’ve never used SQL Server Profiler, you truly don’t know what your missing. And that statement has an intentional...
2009-08-31
1,649 reads
Setting Realistic Goals & Learning to Adjust
There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...
2009-08-31
2,031 reads
SQL Lunch Calendar
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-08-31
1,718 reads
Submitted PASS Board Of Directors Application
Well after much deliberation I have decided to submit an application for the PASS Board of Directors. I embark on...
2009-08-31
1,417 reads
The Pain of Multi-Threading!
Alas, this isn’t really a SQL post, but thoughts on efforts to share work that has been previously done by...
2009-08-31
1,436 reads
reading.
Reading another great book ( I know its old but good book)...Inside Microsoft sql server 2005: T-SQL QUERYING....by Itzik Ben - Gan.
2009-08-30
1,596 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