spid in Killed/Rollback cannot kill
We come across a situation where we have to kill one spid which was running for quite some time, so...
2011-12-17
3,560 reads
Blog Posts
Undocumented Gotchas of Transactional Replication
Undocumented Gotchas of Transactional Replication
Gotcha - Norelco commercial (1977)
This discussion started on Twitter via the #sqlhelp hash tag. The question that...
2011-12-17
1,391 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is...
2011-12-17
704 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....
2011-12-17
5 reads
Why you may or may not consider using Database Snapshots!
Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...
2011-12-17
8,264 reads
Counting Merge Replication Article Changes
One of the cool things about Merge Replication is that it has the capability of revealing very interesting information regarding...
2011-12-16
2,038 reads
Factless fact table
A factless fact table is a fact table that does not have any measures. It is essentially an intersection of...
2011-12-16
2,641 reads
Get drive & mount points space information in SQL Server 2005 by using CLR Stored Procedure?
As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...
2011-12-16
2,053 reads
My first blog post!
I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.
2011-12-16
536 reads
Open_transaction_count in sys.dm_exec_sessions
This news may be a few months old, but it is worth noting that there is now a column called...
2011-12-16
1,393 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Kontak BCA KCP Semanggi Telp:08218154392
WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers