Update statistics for all tables in any DB

Most of the time even after executing dbcc dbreindex script on database you won't see much improvement in application/DB performance.  Thats because dbreindex creates statistics for all tables but it executes sp_updatestats which is like sample statistics. To get the maximum performance we had to execute Update statistics with fullscan on table. This simple will […]

4.75 (8)

2006-12-22 (first published: )

8,107 reads

Get SQL job status for all servers.

Below script will Get SQL job status for all servers running on the same network. All you have to do is create a linked server with msdb on local machine. Executing this script will give you all job status on any number of servers. Good for an environment where a DBA had to see job […]

5 (1)

2006-09-20 (first published: )

729 reads

Disable and enable constraints and triggers

Often in development environment you want to truncate all the tables to insert new data from production, but you cannot do easily as there were a bumch of Foreign Keys and triggers. Dropping all triggers and FK's and then recreating them again is a tedious job. That to dropping and recreating FK's in a particular […]

5 (1)

2006-09-19 (first published: )

219 reads

BCP OUT tables from any database

This script will help DBA's who wants to BCP out required tables form any database. This script can be run through as a job. Before running you have to create a table in any given database and store the table names in it, which you want to Bulk copy. Query in this procedure will check […]

5 (1)

2005-02-17 (first published: )

273 reads

Grant Read-only permission to user on jobs

create this SQL as a stored procedure and give user execute permissions on it store procedure. that user will be able to see all the jobs and their associated schedules but won't be able to modify, create or execute job. This is particularly a request most often aske dby developer to view jobs/schedules on production […]

2004-11-15 (first published: )

463 reads

Fix orphan users

some times after restore database, you find your logins and users mapping is lossed and no user can now logon to database using application. I faced that many times. To map all your database users with master..syslogins. save this procedure in current database and execute it. All users will be mapped with logins.

2004-11-12 (first published: )

375 reads

Blogs

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Power BI Monthly Digest – July 2019

By

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...

Read the latest Blogs

Forums

https://first2fitness.com/keto-charge/

By PeggyMinard

Gracious, and you may ponder—how'd things turn out with the bacon lovers? Their test...

Changing Hardware

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing Hardware

Always On AG

By Admingod

I was trying to create cluster for AG group and it fails to create...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers