<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
Administration
Search for
any
content tagged
administration
Add a script
Items 1 to 20 of 138
Next 20 >>
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
Read more...
By
David Kranes
2012/02/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
465 reads
Wait Time - Query\Client
Script helps to get the client and queries that generate longer waiting time.
Read more...
By
Wellington Vitoriano
2011/11/07
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,031 reads
Database Files Physical Location
Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.
Read more...
By
Mohamed Qasim
2011/11/11
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
760 reads
Next grow for all databases per disk
This script lets you to know how much would grow all databases if it would happen at the same time and prevent disk full.
Read more...
By
Gonzalo Moles
2011/10/11
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
684 reads
sp_who3
A compatibility view for DBAs used to using sp_who2
Read more...
By
gerhard-356547
2011/08/01
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,088 reads
Get information from tables
Give information in tables such as type size and description of each of the columns
Read more...
By
kenneth9
2011/07/08
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,113 reads
Verify a database backup using T-SQL
A script to verify a database backup using T-SQL code
Read more...
By
Nakul Vachhrajani
2011/07/11
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,223 reads
Backup all databases & check backups
Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups
Read more...
By
Pavle-192195
2011/05/13
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,003 reads
Killing User Connection(session) connected to the Database.
The script will be helpful to kill all the user sessions before performing the refresh of the database.
Read more...
By
Sourav Mukherjee
2011/04/08
|
Source:
SQLServerCentral.com
|
Category:
kill
Rating:
|
Discuss
|
Briefcase
|
1,967 reads
Index Defragmentation and update stats
A thorough SP for rebuilding indexes.
Read more...
By
Gregory Ferdinandsen
2011/03/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,657 reads
Kill all connection to database
Procedure tries to kill all connections to the specified database.
Read more...
By
Rafal Skotak
2011/03/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
3,374 reads
Unused Indexes in your databases
This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude
Read more...
By
Rabie Harriga
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
4,645 reads
(new) Kill ALL Connections To a SQL Database
Ever puzzled by the database "Currently in Use" error even though you thought all connections had been Killed? That’s because the wrong table SysProcesses was used.
Read more...
By
Richard Lu
2011/02/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,720 reads
SQL Server Port Number Identifier
Find SQL server port number for SQL 2000, 2005, 2008 and 2008 R2
Read more...
By
Rudy Panigas
2011/01/21
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,185 reads
TempDB usage per active session
Lists the TempDB usage per each active session.
Read more...
By
Gianluca Sartori
2011/01/05
|
Source:
SQLServerCentral.com
|
Category:
tempdb
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
2,730 reads
Create SQL JOB to backup database and schedule it
This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.
Read more...
By
Bharat Panthee
2011/01/06
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
1,713 reads
How to get all MSSQL database columns names, data types and length
know all database columns names and data types and lenght with the minimum effort
Read more...
By
Sameh Saeed
2010/12/09
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,610 reads
Table Data Sizes
Script to display how the data is broken up between the tables.
Read more...
By
ngreene
2010/12/08
|
Source:
SQLServerCentral.com
|
Category:
size
Rating:
|
Discuss
|
Briefcase
|
1,772 reads
Script to find table sizes in a database
Script to find table sizes in a database
Read more...
By
Harsha Majety
2010/12/14
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,850 reads
SQL Server Service Check Utility
Script will display current status of SQL server services and even show if not installed. Works on SQL 2005,2008 2008R2. Both 32 and 64 bit servers.
Read more...
By
Rudy Panigas
2010/11/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,412 reads
Items 1 to 20 of 138
Next 20 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
