2008-11-06 (first published: 2008-09-12)
1,051 reads
Scripts
Get Record count of all tables of current database
This script will return record count of all user tables from the current database
2008-11-05
1,089 reads
Add Primary key
This Store procedure is used to add primary key to all tables in a database, if table does not contain it.
2008-11-04
988 reads
2008-11-04
1,964 reads
Delimited String Parsing Functions - TwoCol set
Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.
2008-11-03 (first published: 2008-08-05)
2,236 reads
SP to find the database usage
This SP helps you to find the data file/s and log usage for a given DB
2008-11-01
1,326 reads
Compare SQL code of 2 objects.
Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments
2008-10-31 (first published: 2008-09-05)
1,130 reads
Find a string in compiled objects
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
449 reads
Insertion and Deletion by using Partition
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
814 reads
2008-10-28 (first published: 2008-07-25)
4,048 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers