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,012 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

Upgrading from 2016 to 2019 with Encryption

By Richard Warr

Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...

NOT LIKE Alternatives in WHERE clause

By BOR15K

Hello, I need help to improve an existing (hence I cannot change table's structure...

Vulnerability Assessment removed?

By cgumprich

In Brent Ozar's list of links today, I learned that Microsoft has removed the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers