<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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
administration
Search for
any
content tagged
administration
Add a script
<< Previous 20
Items 21 to 40 of 149
Next 20 >>
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
|
2,238 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
|
3,087 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,692 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
2011/03/17
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
4,997 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
|
3,072 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,526 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
|
4,208 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,910 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,802 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,896 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
|
3,353 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,841 reads
Get SQLServer Name and Uptime SPROC
Stored procedure to provide clean output of system name and uptime since last restart
Read more...
By
Chris Gillham
2010/11/16
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,189 reads
T-SQL generator for sp_configure
The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.
Read more...
By
Rudy Panigas
2010/10/14
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,223 reads
Index defrag script (21005/2008)
This script will allow reindexing (either rebuild or reorg)
Read more...
By
Gregory Ferdinandsen
2010/08/25
|
Source:
SQLServerCentral.com
|
Category:
reindex
Rating:
|
Discuss
|
Briefcase
|
3,142 reads
Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
Read more...
By
Richard Doering
2011/06/29
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,124 reads
Grow\Shrink all datafiles SQL 2005\2008
Generates a script to grow\shrink all datafiles for a database to the same amount
Read more...
By
Allan Roodt
2010/07/23
|
Source:
SQLServerCentral.com
|
Category:
shrink database
Rating:
|
Discuss
|
Briefcase
|
2,153 reads
SQL Server System Report
Report to keep you abreast of various details of an instance, including: general properties, uptime, drive space, db size allocation, growth stats, backups, jobs, unused indexes, & more...
Read more...
By
Sean Smith
2010/06/17
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
6,598 reads
Truncate Transaction - All Databases
Script to help you to truncate TL for all databases.
Read more...
By
Disney Hammerschmidt
2010/05/03
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,892 reads
Attach Database
This script will generate scripts to create each database on a sever for attach.
Read more...
By
Ron Carpenter
2010/03/29
|
Source:
SQLServerCentral.com
|
Category:
server migration
Rating:
|
Discuss
|
Briefcase
|
1,719 reads
<< Previous 20
Items 21 to 40 of 149
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
