2016-02-05 (first published: 2014-05-15)
3,303 reads
Scripts
Index stats with key,included columns, size - all you can eat
Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition
2016-02-04 (first published: 2016-01-22)
912 reads
Design : Find table with Identities with missing unique constraints
In an OLTP DB, other than an autogenerated Identity , there should be something else on the table which makes the non-identity data unique, as in, unique if you had to drop the ID column.
2016-02-03 (first published: 2016-01-22)
507 reads
Instance wide script to add user (the 4th way)
The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.
2016-02-02 (first published: 2016-01-15)
821 reads
Design : Find and script out Missing Foreign Keys
Find missing Foreign Keys by name, only reference single column primary keys which are on top of an identity,also find where column names reference table with column name ='ID'.
2016-02-01 (first published: 2016-01-21)
1,110 reads
Generic SQL backup with Azure support
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
392 reads
Avoid Transaction Logs volume from filling
Script for preventing the volumes of the transaction logs from filling.
2016-01-27 (first published: 2014-05-13)
3,524 reads
Query Performance Report
The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.
2016-01-20 (first published: 2015-05-13)
5,454 reads
Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,140 reads
SQLPS Meets the DMV's
This is a great wrapper for your DMV's to automate a quick performance metric capture.
2016-01-12 (first published: 2016-01-06)
452 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers