Consequences of Timeout/Error on a Delete statement
Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...
2015-11-02 (first published: 2015-10-21)
5,407 reads
SQLdose
Consequences of Timeout/Error on a Delete statement
Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...
2015-10-21
451 reads
A Basic Introduction of Database, Tables and SQL.
It seems to be the most basic thing but this post is specifically to those who have just started or...
2015-10-29 (first published: 2015-10-20)
2,749 reads
A Basic Introduction of Database, Tables and SQL.
It seems to be the most basic thing but this post is specifically to those who have just started or...
2015-10-20
334 reads
Non-Clustered Index
In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...
2015-10-04
479 reads
Non-Clustered Index
In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...
2015-10-04
323 reads
Clustered Index and related Interview Questions
Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...
2015-09-20
1,966 reads
Clustered Index and related Interview Questions
Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...
2015-09-20
376 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
829 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
449 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