Table Space Used in DB
A quick script that provides the sizes of the tables in your database, including schema and choice of sort method
2018-08-07 (first published: 2018-07-29)
649 reads
Luis Chiriff
Advanced Display Table and Column Info
A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.
2014-01-03 (first published: 2013-12-10)
1,691 reads
2010-02-15 (first published: 2010-01-18)
12,923 reads
Find the row with the most data
This script is a quick throw together that tells you which rows in a table have the most data
2008-07-25 (first published: 2008-06-10)
813 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server 2016 seeding automatic stuck
Hi all, Problem help please, I have 2 servers in sql server 2016 and...
will this get replicated to secondary replica
Dear Experts, In Availability Group, if we move ndf file to another drive on...
slow query performance
Hi All, I have a SELECT query which is taking more 8 mins. Can...
Ask SSC