Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Administration Rss

Search for any content tagged administration

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 21 to 40 of 171    Older >>
 

List all tables and their respective information.

List all tables in a SQL Server database with the details of them.  Read more...
By Fernando Casas Osorio 2013/03/14 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 2,717 reads

Security Change Snapshot

This script gives a server level snapshot of recent security changes  Read more...
By Nate Hughes 2013/02/28 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 870 reads

Find SQL Statements Consuming tempdb Space

You can use the following query to find the currently active requests, their associated T-SQL statement, and the corresponding query plan that is allocating most space resources in tempdb.  Read more...
By Rahul Singh 2012/12/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,455 reads

Find memory used by particular Database

Using sys.dm_os_buffer_descriptors we can find out how much memory a database or a object is consuming.  Read more...
By Rahul Singh 2012/12/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,464 reads

Get Rid of All Those Pesky 1 MB File Growth DB Files

Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.   Read more...
By Greg Milner 2013/05/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,348 reads

Shrinking all log files on SQL Server 2008R2

It shrinks all log files for the databases created by users.  Read more...
By Igor Micev 2012/11/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,001 reads

SQL Server Uptime

This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)  Read more...
By Chandu Ade 2012/09/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,313 reads

Search for an object across multiple databases on a server.

There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.   Read more...
By Kishore T 2013/04/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,770 reads

SQL Server Index Defragmentation (Updated)

Defrags all indexes in select databases in 2005, 2008, and 2012.  Read more...
By Gregory Ferdinandsen 2014/02/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,321 reads

Display Names and Locations of SQL Database Files and DB Owners

Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.  Read more...
By Charles Brinkman 2012/08/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,491 reads

Count of Objects by Database on a Server

I needed to get a count of objects by database on a server to assess which dbs are good candidates for Red Gate SQL Source Control.   Read more...
By Joe Kennedy 2012/08/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 657 reads

Finding Unused Database Roles

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...
By Brandie Tarvin 2012/07/24 | Source: SQLServerCentral.com | Category: database roles
Rating: |  Discuss |   Briefcase | 1,317 reads

All SQL Version info in one function

This function returns all the necessary version information in a table.  Read more...
By Wilfred van Dijk 2012/05/28 | Source: SQLServerCentral.com | Category: version
Rating: |  Discuss |   Briefcase | 3,083 reads

Session complete status and estimated completion time

A small retake on the popular percent complete script which tell how much more time an executing command will take.  Read more...
By Hemanth Damecharla 2012/03/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 923 reads

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 2014/01/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,171 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,432 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 | 1,132 reads

Next grow for all databases per disk

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.   Read more...
By Gonzalo Moles 2011/10/11 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 980 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 | 3,020 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,438 reads
<< Newer    Items 21 to 40 of 171    Older >>