SKUUpgrade =1 in SQL 2005
One of the things on my todo list for this past week was to upgrade a SQL 2005 Standard Instance...
2009-10-13
745 reads
Blog Posts
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-13
4,001 reads
SQLServerCentral Article on Database Space Capacity Planning
I wrote an article for SQLServerCentral entitled "Database Space Capacity Planning" that demonstrates a database and volume (disk) capacity planning solution...
2009-10-13
1,001 reads
Table Variables Are Only in Memory: Fact or Myth
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
671 reads
A Not Quite Average Sunday
Ever had a day when a bunch of small things run together to create a day you wish you had...
2009-10-12
327 reads
Afraid of Presenting? Try Toastmasters
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,330 reads
Carolina Code Camp - The Good and the Bad
This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was...
2009-10-12
937 reads
Congratulations to John Magnabosco
Congratulations to John Magnabosco for being awarded as a Microsoft MVP. I met John last year at the Indy Tech...
2009-10-12
618 reads
Congratulations to John Magnabosco on SQL MVP Status
See his quiet post about it here. This comes right after finishing up his first book titled Protecting SQL Server...
2009-10-12
284 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-12
3,362 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