SQLServerCentral: Scripts

Click here to monitor SSC

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

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

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>

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

Items 1 to 20 of 2949 Older >>

buffer_memory_mgt

If you ever need to find out what database is using up the most buffer pool resource, this will help. You will also get the object in the buffer for the specific database that is using up the most buffer resource. It will help when troubleshooting buffer related issues. Read more...

By Patrick Akhamie 2014/04/22 | Source: SQLServerCentral.com | Category: buffer mgt

Rating: (not yet rated) |

Briefcase | 35 reads

Find Average Page Life Expectancy

I have a brief note in the query header itself Read more...

By Patrick Akhamie 2014/04/22 | Source: SQLServerCentral.com | Category: ple

Rating: (not yet rated) |

Briefcase | 28 reads

Create notifications for failed jobs with one easy script

Here an easy way to setup alerts for all sql agent jobs. Typically I use this to send an email alert when a job fails. I always setup a group email address rather than individuals to make this a one-time setup. Read more...

By Patrick Akhamie 2014/04/22 | Source: SQLServerCentral.com | Category: sql agent

Rating: (not yet rated) |

Briefcase | 46 reads

Get database size, used space, free space

Gets the size, amount of space used & unused, owner and modify date for all databases in a Sql instance. Read more...

By Trevor Makoni 2014/04/22 | Source: SQLServerCentral.com | Category: file size

Rating: (not yet rated) |

Briefcase | 42 reads

vlfs_Count_for_Each_Database

Here is a short code to count the VLFs in the transaction log for each database in the instance. Read more...

By Patrick Akhamie 2014/04/21 | Source: SQLServerCentral.com | Category: transaction_log

Rating:

|

Briefcase | 42 reads

Find database where table is located

Return a list of databases which contain a table from wildcard table name. Read more...

By Trevor Makoni 2014/04/14 | Source: SQLServerCentral.com | Category: find

Rating: (not yet rated) |

Briefcase | 97 reads

Size of database files for an instance of SQL Server

Size of database files for an instance of SQL Server Read more...

By Andrés Michaca 2014/04/10 | Source: SQLServerCentral.com | Category: file size

Rating: (not yet rated) |

Briefcase | 171 reads

Generated script to update statistics

Generated script to update statistics Read more...

By Andrés Michaca 2014/04/09 | Source: SQLServerCentral.com | Category: statistics

Rating: (not yet rated) |

Briefcase | 147 reads

Reorganize indexes

Generate script to reorganize indexes in a database Read more...

By Andrés Michaca 2014/04/09 | Source: SQLServerCentral.com | Category: indexing

Rating: (not yet rated) |

Briefcase | 166 reads

Exporting data with header using Powershell

Extracting data with header information using PowerShell Read more...

By Louis Li 2014/04/07 | Source: SQLServerCentral.com | Category: powershell

Rating: (not yet rated) |

Briefcase | 155 reads

Format decimal value to fraction using a tally table.

We use a tally table to find the appropriate denominator for a given decimal part of a number. Read more...

By Adrian Facio 2014/04/07 | Source: SQLServerCentral.com | Category: format

Rating: (not yet rated) |

Briefcase | 50 reads

backup, differental and transactions

Backup all databases for an instance (complete, Differential or log of transactions) Read more...

By Andrés Michaca 2014/04/21 | Source: SQLServerCentral.com | Category: backup |

SQL Scripts Manager Compatible

Rating: (not yet rated) |

Briefcase | 642 reads

Count all records the tables

Count all the records from the tables that exist in a database Read more...

By Andrés Michaca 2014/04/24 | Source: SQLServerCentral.com | Category: t-sql |

SQL Scripts Manager Compatible

Rating:

|

Briefcase | 910 reads

Script to Generate Table to Stored Procedure Cross References

Lists Tables and Store Procedure references. Runs a bit slow but appears to be accurate. Read more...

By Marcus Dallasandro 2014/04/01 | Source: SQLServerCentral.com | Category: cross reference

Rating:

|

Briefcase | 182 reads

Restore script genrator for moving dbs

usefull script for moving databases from one server to another Read more...

By Anoop 2014/04/23 | Source: SQLServerCentral.com | Category: restore

Rating:

|

Briefcase | 477 reads

Get the defination of all table type in database

THis script will generate the Drop and create script for all user define table type Read more...

By Mitesh Oswal 2014/04/18 | Source: SQLServerCentral.com | Category: drop table

Rating:

|

Briefcase | 859 reads

Dynamic table unpivot

Generate and execute dynamically select statement for unpivot table Read more...

By kast218 2014/04/17 | Source: SQLServerCentral.com | Category: unpivot

Rating:

|

Briefcase | 716 reads

Search objects in Database

Use this script to search objects in a Database. Also used to check a tables column types and details when no model is accessible. Replace <DATABASENAME> for database name. Read more...

By bpimenta 2014/04/16 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,062 reads

Script out passwords

This script will let you get the passwords for all SQL Server principals. Read more...

By Steve Jones 2014/04/01 | Source: SQLServerCentral.com

Rating:

|

Briefcase | 1,943 reads

Generate script to rebuild indexes in a database

Generate script for reconstgruir ena database indexes Read more...

By Andrés Michaca 2014/04/08 | Source: SQLServerCentral.com | Category: indexing

Rating: (not yet rated) |

Briefcase | 1,152 reads

Items 1 to 20 of 2949 Older >>