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

Blogs

On Dynamic Ports, Named Instances, and Firewalls

By

Recently I had a client and their vendor trying to configure a firewall for...

Daily Coping 13 Jul 2020

By

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

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Read the latest Blogs

Forums

Help needed in getting all AD users and groups

By Mysterio

I have very limited knowledge with server management. I need to extract AD users...

What do you like for third party database backup/restore for SQL server & Azure

By melissa.hamilton

Hi all, my company currently uses SQL server native tools to perform nightly backups. ...

Find the last occurrence of \ character and get the left of string.

By sathwik.em91

How to find the last occurrence of '\' in the following  string  and get...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers