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)

You rated this post out of 5. Change rating

2006-12-22 (first published: )

20,864 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)

You rated this post out of 5. Change rating

2006-09-20 (first published: )

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

You rated this post out of 5. Change rating

2006-09-19 (first published: )

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

You rated this post out of 5. Change rating

2005-02-17 (first published: )

286 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 […]

You rated this post out of 5. Change rating

2004-11-15 (first published: )

629 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.

You rated this post out of 5. Change rating

2004-11-12 (first published: )

383 reads

Blogs

Monday Monitor Tips: Finding the Hostname for Queries

By

I was chatting with a customer recently and they wanted to know which host...

Can AI Read Execution Plans?

By

Yeah, yeah, second AI post in a row. I promise not to make a...

Streamline Dependency Management in Databases

By

In the intricate world of business, where precision and efficiency are paramount, managing database...

Read the latest Blogs

Forums

SQL Server is terminating in response to a 'stop' request from Service error

By naga.rohitkumar

Dear All, In one of the server its repeatedly restarting sqlserver services and not...

Understanding CROSS APPLY and OUTER APPLY in SQL Server

By Noman072

Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...

Database Files on Shares I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Files on Shares I

Visit the forum

Question of the Day

Database Files on Shares I

I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?

See possible answers