A simple SysProcess query
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,395 reads
Scripts
Verify SQL Server Login and Login Settings
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,746 reads
Script to get Server Info
This script will gather a number of Server Information items that are useful in baselining a SQL Server.
2011-07-25 (first published: 2010-01-19)
7,397 reads
Find tables unused since last SQL Server restart
This script will return tables that haven't had any user activity since the SQL Server Service was last restarted. SQL 2005+
2011-07-22 (first published: 2010-01-28)
5,591 reads
Backup or Restore progess
This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.
2011-07-18 (first published: 2010-02-19)
2,374 reads
consolidated script generator for multiple stored procedures
Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go
2011-07-15 (first published: 2011-03-28)
2,073 reads
Restore database with all necessary files
It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.
2011-07-13 (first published: 2007-12-27)
5,017 reads
2011-07-12 (first published: 2011-07-01)
1,148 reads
2011-07-11 (first published: 2011-07-02)
2,117 reads
Get information from tables
Give information in tables such as type size and description of each of the columns
2011-07-08 (first published: 2011-07-06)
1,481 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
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...
Forums
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
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
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