Re-blog – November 18 – November 24
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-11-25
894 reads
Blog Posts
Destroying a Windows Cluster
I haven’t posted for a while but thought I’d dust off the blog and get a post out. I have...
2011-11-24
5,344 reads
MS DTC and sys.dm_tran_active_transactions
A sql reindex command was being blocked by two active transactions in MS DTC. Use
sys.dm_tran_active_transactions to report more detail on...
2011-11-24
2,234 reads
SQL Server 2012 licensing details
AdvertisementsMicrosoft’s SQL Server 2012 (AKA SQL Server code-name ‘Denali’), new details have been released http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx.
1. What is new in SQL...
2011-11-24
4,468 reads
ALTER INDEX permissions
Developers like to have some control over the development process. An example is index building. Asking aDBA repeatedly for changes ...
2011-11-23
1,068 reads
DBA in Space: Behind the Scenes—Question 5
Part 1 of Question 5—The question.Part 2 of Question 5—The follow up to the question.This is a continuation of my...
2011-11-23
599 reads
DBCC WritePage
DBCC WritePage is a dangerous undocumented DBCC command. It’s useful in your sandbox to change data, crash objects, and do...
2011-11-23
2,836 reads
Running a TPC-C workload on SQL Server
I have a lot of customers with some impressive SQL Server workloads, those databases
are several hundred GB large, with several...
2011-11-23
7,982 reads
Speaking at Spring 2012 SQL Server Connections in Las Vegas
I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas,...
2011-11-23
1,094 reads
SQL Deep Dives 2 on the Kindle
Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted the book for travel purposes. I decided I really...
2011-11-23
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