Technical Article

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: )

16,154 reads

Technical Article

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: )

736 reads

Technical Article

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: )

230 reads

Technical Article

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: )

279 reads

Technical Article

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: )

476 reads

Technical Article

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: )

379 reads

Blogs

Slides from SQL Saturday Los Angeles 2022

By

If you attended my talk at SQL Saturday Los Angeles 2022, then you can...

Creating a HEAD utility for Windows 10

By

One of the things I did often in my first career job was create...

Distributed Replay: The Little Engine That Almost Could

By

Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive...

Read the latest Blogs

Forums

SELECT * FROM ( ... ) X

By FatsGordon

Hi all! I'm trying to understand how does this work. I've read a thread...

Would like to understand a better way of updating data that a cursor if possible

By bswhipp

I have a need to update some data and also create a record of...

SQL Question - Column References

By rjdpa2

Hi. Looking for someone to help with a query I'm tring to run. I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers