List recovery model of databases.
Script will create a sorted list of databaes and their recvoery model. I'm sure there is a more elegant way to do this, but this works in a pinch.
2007-07-23 (first published: 2006-10-26)
1,078 reads
Scripts
Remove index fragmentation
This script will drop and recreated all indexes in a database within a transaction. The script will also add standard nameing conventions to the index names. Any duplicated indexes are removed.
2007-07-20 (first published: 2006-10-24)
1,392 reads
Row count of all tables
Quick and accurate method to get the row count of each table in a given database. Execution time is dependent on the number of rows in each table.-- Girish (gvphubli)
2007-07-20
1,373 reads
Finding missing indexes in sql server 2005
the following scripts helps in finding top 5 missing indexes using the new feature of DMV available in SQl Server 2005
2007-07-19 (first published: 2006-10-23)
5,389 reads
Delete Duplicate Records without using Cursor
This script will delete the duplicate records without using cursor
2007-07-18
674 reads
Show Line of Code Executing in Procedure
Show line of code executing - more details than dbcc inputbuffer
2007-07-18 (first published: 2006-10-16)
920 reads
2007-07-17 (first published: 2006-10-12)
464 reads
Performance problem in SQL Server 2005
I have written stored procedure which simply read each row one by one and update the some column in same table.SP is running fine in SQL Server 2000 and completed within 5 minutes (around 5 million rows)But same SP in SQL Server 2005, its taking around more than one hour (for same number of rows)Note: […]
2007-07-16
526 reads
Running Sum Query
Sometimes you need to calculate a running sum. Uses of this include adding a Month-To-Date column to a query of recent orders. I haven't seen anyone publish how to do this before (using this method).This query works by using the Row_Number() function and recursive query capability of SQL 2005.
2007-07-16
555 reads
User Tables with Size all DBs (SQL 2005 Only)
Hope this is helpful to someone. This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]
2007-07-16 (first published: 2006-10-11)
293 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers