Star Join Optimization in SQL Server 2008
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-08
6,198 reads
Date Expression Compilation in SSIS
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-08
3,632 reads
Smarter Intellisense
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
975 reads
Identity Insert Guideline
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
602 reads
Labor Day Comes and Goes as Unemployment Grows......
Labor Day, which marks the unoffical end of Summer in the U.S., is particularly poignant in light of the news...
2009-09-08
858 reads
I’m going to Disney World! (Well, to SQL Saturday Orlando)
I’m going to Disney World! At least that’s what my kids will think when I tell them that I’m heading...
2009-09-08
320 reads
Remember the Milk: Smart Adds
A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task...
2009-09-08
998 reads
Moving your database to a new server
We've had a few articles on how you move databases, but it seems that there are always new people using...
2009-09-08
500 reads
SpeakerRate – Need Your Feedback
Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that...
2009-09-08
771 reads
Windows 7, UAC, and SQL Server
This is just a quick note, almost a continuation of my Access Denied, Not Possible post. I have been working...
2009-09-08
376 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