[Video] SQL Server Deadlocks
SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...
2017-09-08 (first published: 2017-08-24)
2,003 reads
All About SQL
Azure SQL Database – Scaling up
Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...
2017-09-01 (first published: 2017-08-23)
1,312 reads
Azure Automation and SQL Index Maintenance
Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...
2017-08-21
965 reads
SQL Server – So you like to shrink do you?
If you do – shame on you and shame on me because I do.
Moving on, I found strange behaviour within SQL...
2017-08-16
384 reads
Azure Cloud “Fear” Busting #4 – Losing Control?
So the decision to move to the cloud has been made but there is a fear from people that once...
2017-08-25 (first published: 2017-08-14)
930 reads
Interviews and Oranges
What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/
The topic being: Interviewing Patterns and Anti-Patterns....
2017-08-08
318 reads
Azure Cloud “Fear” Busting #3 – There is no going back?
Once you go cloud, there is no going back. This is false and from a database perspective you can migrate...
2017-08-07
437 reads
Azure Cloud “Fear” Busting #2 – Seeking for Better Performance
We all want high performing applications and when you are in the cloud that is no different, if anything it...
2017-08-07 (first published: 2017-07-20)
1,378 reads
Azure Cloud “Fear” Busting #1 – Security
So here we go, the first installment of my cloud blog series. From my experience this concern is a common...
2017-07-26 (first published: 2017-07-12)
1,745 reads
SQL Server Rookie Mistakes
A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG...
2017-07-20 (first published: 2017-07-11)
2,561 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