Skip to content

The Desert DBA

SQL Server Field Notes by Jeff Iannucci

  • Home
  • About
  • Presentations
  • Contact

Month: March 2022

How to find tables with 0 records using space

March 11, 2022March 11, 2022 ~ Jeff Iannucci ~ 3 Comments

This is a follow up post to the previous one about tables with no records using data space, with the idea coming from twitter of all places. Sometimes on twitter the conversations kill, but after reading that post my friend Chris Wood suggested writing something to FIND those tables.

Which is a solid idea, so let’s get to it. No time to wait too long.

Continue reading →

Search My Posts

Recent Posts

  • What I’ve learned in my first 100 days with a consulting group
  • How to find tables with 0 records using space
  • How can a table with 0 records use so much space?
  • How to get Change Data Capture to work in an Availability Group
  • sp_GetRowcount: How to count the number of rows in any SQL Server table fast

Categories

  • #TSQL2sday
  • Career Help
  • Change Data Capture
  • SQL Server
  • tempdb
  • Uncategorized

Archives

  • June 2022
  • March 2022
  • February 2022
  • January 2022
  • June 2021
  • February 2021
  • October 2020
  • August 2020
  • July 2020
  • May 2020
  • April 2020
  • February 2020
  • January 2020
  • October 2019
  • August 2019
  • July 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018

IDERA ACE Class 2020-21

Proudly powered by WordPress ~ Theme: Penscratch by WordPress.com.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close