Technical Article

Drop Statistics

This procedure was created to automate the dropping of statistics on a user specified table.  Very simple code, but handy if the need is there.Replace 'tablename' throughout script with the name of the table intended to temporarily house the statistics name(s).

You rated this post out of 5. Change rating

2002-11-01

1,049 reads

Blogs

Undercover Catalogue 0.4.5 Released – Database Module Bug Fix

By

Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...

Saving Emergency Space on my Laptop

By

With my new laptop, one of the things I realized I’d forgotten to do...

T-SQL Tuesday #178–A Recent Technical Problem

By

This month we have a good invitation from Deepthi Goguri, where she asks us...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

backups failure

By mtz676

Hello All, We have a domain account running sqlserver service.this account has r/w access...

Visit the forum

Question of the Day

Setting Emergency State

Which server role(s) can set a database to the Emergency State?

See possible answers