usp_get_all_stats_date

This script gathers stats_date and index information for all of the current database. Please feel free to modify it as it is made up of components that are available on this site here- http://www.sqlservercentral.com/scripts/contributions/97.aspand a BOL entry for stats_date.I needed this information and thought I would share it.

2006-07-17 (first published: )

546 reads

Blogs

Are You a Diverse User Group or Event?

By

One of the things that I’ve seen crop up at various points in my...

Daily Coping 18 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

When Read Committed Snapshot Goes Bad – Version Store Filling TempDB

By

We all had those calls, it’s the middle of the night and we get...

Read the latest Blogs

Forums

DB logins permission script out

By sqltester1

Hi, Can anyone share or point me to get -DB logins permissions in a...

UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue

By oRBIT

I've been working a little bit with a few tables here, they've got "CreatedDate"...

Multiple deadlocks occuring on simultaneous deletions from temporal table

By zoggling

We have a stored procedure which is attempting to delete 1-2 rows at a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers