SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 2202    Next 20 >>
 

Serial ID Auto Generation

Scripts used to create the functionality to auto-generate your very own customized serial IDs.  Read more...
By Larry Sumuri 2010/02/22 | Source: SQLServerCentral.com | Category: serial id
Rating: (not yet rated) |  Discuss |  Briefcase | 56 reads

See the compile time

Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.  Read more...
By Peter Samson 2010/02/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |  Briefcase | 9 reads

Fix users for SQL 7 thru 2008

This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.  Read more...
By Mike Tutor 2010/02/19 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |  Briefcase | 74 reads

Truncate Table Partition command

Procedure to automatically truncate table partition   Read more...
By Vidyadhar Pandekar 2010/02/18 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |  Briefcase | 53 reads

usp_TransposeNRows v2.0

Transpose N rows of a table (v2.0 allows user to specify the table's schema)  Read more...
By j.d.brooks 2010/02/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 98 reads

Find tables unused since last SQL Server restart

This script will return tables that haven't had any user activity since the SQL Server Service was last restarted. SQL 2005+  Read more...
By Ryan McCauley 2010/02/16 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 243 reads

Database Users And Associated Database Roles

This script basically retreives all database users thier database roles for a database.   Read more...
By Larry Sumuri 2010/02/10 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |  Briefcase | 324 reads

Roll Your Own Materialized Views

Simple but elegant alternative to indexed views.  Read more...
By mark.stockwell 2010/02/11 | Source: SQLServerCentral.com | Category: materialized view
Rating: (not yet rated) |  Discuss |  Briefcase | 117 reads

Script to get Server Info

This script will gather a number of Server Information items that are useful in baselining a SQL Server.   Read more...
By Pradyothana Shastry 2010/02/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 464 reads

Search all tables for text

This script will help you search all tables for a specific set of text.  Read more...
By Luis Chiriff 2010/02/15 | Source: SQLServerCentral.com | Category: search
Rating: (not yet rated) |  Discuss |  Briefcase | 235 reads

usp_TransposeNRows

Stored procedure to transpose the first N rows of a specified table  Read more...
By j.d.brooks 2010/02/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 609 reads

How long has passed since SQL Server service started?

Days, hours and minutes since SQL Server service was started  Read more...
By Lars Søe Mikkelsen 2010/02/04 | Source: SQLServerCentral.com | Category: getdate()
Rating: |  Discuss |  Briefcase | 639 reads

Removing Duplicates

Another approach to remove duplicates without using group by  Read more...
By bdba 2010/02/08 | Source: SQLServerCentral.com | Category: removing duplicates
Rating: |  Discuss |  Briefcase | 1,628 reads

Script Table or View structure

This code will let you script a Table or Views structure for source control.   Read more...
By Pratap Prabhu 2010/02/02 | Source: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |  Briefcase | 875 reads

Refreshing Views

It is recommended to refresh a View if a dependency to that view has changed if it isn't schemabound  Read more...
By Cameron Wells 2010/02/03 | Source: SQLServerCentral.com
Rating: |  Discuss |  Briefcase | 516 reads

Listing Subscribed SSRS Reports including Parameters & their Values

This script will allow user to analysis their Subscribed Reports.  Read more...
Rating: |  Discuss |  Briefcase | 372 reads

Extracting Logins From SQL Server

This script will help you transfer logins between one instance of SQL and another.  Read more...
Rating: (not yet rated) |  Discuss |  Briefcase | 1,030 reads

Conversion of rule objects to column check constraints

This script can convert the usage of bound rule objects in tables to column check constraints  Read more...
By Michael Søndergaard 2010/01/28 | Source: SQLServerCentral.com | Category: sp_bindrule
Rating: (not yet rated) |  Discuss |  Briefcase | 194 reads

Conversion of default objects to column defaults

This script can convert the usage of bound default objects in tables to column defaults  Read more...
By Michael Søndergaard 2010/01/29 | Source: SQLServerCentral.com | Category: sp_unbindefault
Rating: (not yet rated) |  Discuss |  Briefcase | 204 reads

Search all columns in every table for a value

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.  Read more...
By Michael Davis 2010/01/25 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |  Briefcase | 1,398 reads
   Items 1 to 20 of 2202    Next 20 >>