I got this script from SQL Server Professional Magazine in an article by Andrew Zanevsky. It performs transactions to fill up virtual log files and continually shrinks the log until the desired level of shrinkage is achieved.
2001-08-08
10,175 reads
This script will kill all users in a given database. Before disconnecting, it can optionally send the user a NET SEND Message giving them a warning to disconnect. To run, simply call it like usp_killusers 'dbname'. Make sure the @dbname parameter is not the master database.
2001-08-08
4,511 reads
When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]
2001-08-08
3,096 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers