Quest Webcast: Dos and Don’ts of Database corruption
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
647 reads
Blog Posts
SQL Server and the “Lock pages in memory” Right in Windows Server
Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL...
2011-02-14
1,724 reads
The results are in: What Tech Companies Are Doing it Right?
Last week I asked you: What Tech Companies Are Doing it Right?
Which SQL (or SQL-adjacent) tech companies are doing right,...
2011-02-14
880 reads
Working on the Railroad
I work with a client that has an office about 25 yards from a train track and recently the railroad...
2011-02-14
609 reads
Writing A Month Long Blog Series
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog...
2011-02-14
611 reads
DBA 101: Why Don’t People Run Backups
It happened multiple times this week. It happens multiple times every week. Some poor soul is posting on a message...
2011-02-13
721 reads
Evaluating Performance of View and Stored procedure
I got a chance to evaluate performance of both views and stored procedure for high level decision making.
As all of Us knows that purpose/scope...
2011-02-13
11,587 reads
Examining PFS, GAM and SGAM pages
Anyone who can interpret data and index pages will surely think about interpreting PFS, GAM and SGAM pages. I am...
2011-02-13
5,616 reads
SSMS Tools Pack – Script Grid Results
Most of us like things that make our lives easier. When they’re free, it’s just that much sweeter. I would...
2011-02-13
1,582 reads
Get Well Trevor – Call to action!
Tim Ford, SQL MVP and all around Good Guy, has been having a really hard time so far in 2011....
2011-02-12
579 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
Alamat Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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