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

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

Add a script

<< Previous 20 Items 61 to 80 of 2779 Next 20 >>

Grouped Failover, a 2008R2 version of Availability Groups

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover. Read more...

By Remko de Boer 2013/01/24 | Source: SQLServerCentral.com | Category: scripts

Rating:

|

Briefcase | 387 reads

Table-Column Data Profiler

Profile all of a table's columns using Transact-SQL. Read more...

By Todd Owens 2013/01/25 | Source: SQLServerCentral.com | Category: code generation

Rating:

|

Briefcase | 889 reads

List Database Users and their Corresponding Roles

Database Users and their Corresponding Roles and type login. Read more...

By Venkat Kesavarapu 2013/01/28 | Source: SQLServerCentral.com | Category: database users

Rating:

|

Briefcase | 1,328 reads

SQL Job Timeline (Graphical)

This script generates a graphical timeline of all SQL jobs with a variable zoom level Read more...

By Theo Ekelmans 2013/01/29 | Source: SQLServerCentral.com | Category: job

Rating:

|

Briefcase | 1,797 reads

Open transactions on a database

This script will show you all open transactions from any query windows. Read more...

By kyle.eldridge 2013/01/30 | Source: SQLServerCentral.com | Category: transactions

Rating:

|

Briefcase | 1,183 reads

Change database compatability level of all databases

Changes the database compatibility level of all databases to the given level. Read more...

By Harsha Majety 2013/01/31 | Source: SQLServerCentral.com | Category: compatibility level

Rating:

|

Briefcase | 548 reads

Create and Populate a Date Dimension Table

Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes Read more...

By Joseph Morgan 2013/02/04 | Source: SQLServerCentral.com | Category: date dimension

Rating:

|

Briefcase | 990 reads

Powershell - Export Stored Proc results to CSV file

This Powershell script calls a stored procedure and exports the results to a CSV file Read more...

By Mandeep Dulai 2013/02/05 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Briefcase | 1,047 reads

T-SQL Bulk Insert

T-SQL that allows you to import tab delimited text file into correct table based on file name. Read more...

By Ervin Santiago 2013/02/07 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 1,362 reads

Number of Working Days

Number of workings days in a month minus weekends and holidays. Read more...

By Ervin Santiago 2013/02/08 | Source: SQLServerCentral.com | Category: workdays

Rating:

|

Briefcase | 1,065 reads

Script to see Table Row Counts

Script to get #rows in each table Read more...

By Harsha Majety 2013/02/06 | Source: SQLServerCentral.com

Rating:

|

Briefcase | 1,153 reads

Tables and rows listing

Simple script which create a list of all the tables and rows of the selected DB. Read more...

By Claudio Tregambe 2013/02/11 | Source: SQLServerCentral.com | Category: tables

Rating:

|

Briefcase | 816 reads

Generate Repair Statements for Not-Trusted Foreign Keys

Generates "check this foreign key" statements for all not-trusted foreign keys on a server. Read more...

By Orestes Zoupanos 2013/02/01 | Source: SQLServerCentral.com | Category: foreign keys (fk)

Rating:

|

Briefcase | 316 reads

GetDateInString

This function will return a value of date if found within a string, the date format in the string will vary. If no date is found a null value is returned Read more...

By Hilda E 2013/01/17 | Source: SQLServerCentral.com

Rating:

|

Briefcase | 1,135 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table Read more...

By Federico Iori 2013/01/22 | Source: SQLServerCentral.com | Category: truncate

Rating:

|

Briefcase | 644 reads

Database details for Daily checks

Get database status,file details,free space in sql 2005 and 2008 sql versions Read more...

By Rahul 2013/01/16 | Source: SQLServerCentral.com

Rating:

|

Briefcase | 1,697 reads

Recreate a temporary table from TempDB

This Script can be used to pick out a temporary table from tempDB you might want to Check and drop the table before you create it just in case , but I Haven't included it here Read more...

By Tristan Cook 2013/01/15 | Source: SQLServerCentral.com | Category: tempdb

Rating:

|

Briefcase | 976 reads

Finding out whether you are using enterprise level feature

The query tells whether sql server enterprise edition is using any enterprise level features or not Read more...

By Rahul Singh 2013/01/21 | Source: SQLServerCentral.com | Category: sql server

Rating:

|

Briefcase | 972 reads

Finding actual number of physical cpu installed

The below query finds out actual number of physical cpu installed on the server Read more...

By Rahul Singh 2013/01/14 | Source: SQLServerCentral.com | Category: processsor

Rating:

|

Briefcase | 1,317 reads

Script to replace 5 consecutive digits with special character

In a given input string, The script searches for 5 consecutive digits and replaces it with a special character. Read more...

By Tanmayi Mukundan 2013/01/10 | Source: SQLServerCentral.com | Category: special characters

Rating:

|

Briefcase | 688 reads

<< Previous 20 Items 61 to 80 of 2779 Next 20 >>