Update statistics in all database (sp_updatestats)

This script permit executes the sp_updatestats in all databases at same time.First I create the stored procedure above in an admin database, for sample I create one database with ADMIN name where I put all administration objects create for me. You can create this sp in exist db, if you want.Now you can execute this […]

4.5 (2)

2005-04-14 (first published: )

4,015 reads

Blogs

SSIS Scaleout: Cannot open certificate store on the machine

By

When attempting to connect a worker node to the current Master node of a...

Adding a License to GitHub

By

I’ve rarely thought about licensing my code, but it’s something to be aware of...

Weekly reading #29

By

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...

Read the latest Blogs

Forums

Automatic decimal round off

By VSSGeorge

Automatic decimal round off is happening for a column having datatype Decimal (6,2). I...

unable to restore db

By vsamantha35

Hi All, Unable to restore/refresh a database. I was able to kill the sessions...

cpu and duration of SQL profiler and cpu_time and duration of Extended event

By 892717952

Sorry for troubling you  for the following questions, thanks! 1. when I use SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers