T-SQL

Useful SQL Query Snippets: Table Sizes

by

I can’t count the number of times I’ve used this query at various sites. It started when I needed to use As with many things these days, I found it on StackOverflow but I want to document it here in case it ever goes missing. While it makes use of the sys. tables (which numerous articles … Read more

SQL Scripts: Record Counts

by

As I’m populating a sample set of data in a SQL Server project, I needed a quick way of identifying what tables I had missed. Here’s what I came up with (but a much faster way is noted below using the sys tables). — Identifies zero record count tablesdeclare @vtb varchar(200)declare @vsc varchar(200) declare x … Read more