Optimize for ad hoc VS single use plans
Yesterday’s post talked about single use plans. The statements I’m using are also called ad hoc queries. The alternative to...
2019-02-20
352 reads
Blog Posts
Proposed SQL Server defaults: disable lightweight pooling
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
346 reads
Query Store Central Repository – Part 1
I’ve worked for SaaS companies for the last 6 years or so. So our queries are largely the same across...
2019-02-20
201 reads
SQL in the City 2019 in London
We’ve started setting up our SQL in the City Summits for 2019 and the first one is London on April...
2019-02-20
775 reads
Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you do for community, whether it be volunteering, organizing, speaking,...
2019-02-20
8 reads
Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you...
2019-02-20
189 reads
Why do I (they) own that database?
Ever looked at the list of databases and wonder why you own one of them? Or why some other user...
2019-02-20
138 reads
7 more ways to Query Always on Availability groups
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
383 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of the previous version of ADLS (now called ADLS Gen1)...
2019-02-19
111 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of...
2019-02-19
808 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 Cijerah WA {08218154393}
WA:08218154393 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
Alamat Kontak BCA KCU BANDUNG WA {08218154393}
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
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