SQLServerCentral: Scripts

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

By Bhudev Prakash 2010/02/01 | Source: SQLServerCentral.com | Category: reporting services (ssrs)

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

By Hugh Scott 2010/01/27 | Source: SQLServerCentral.com | Category: transfer logins administration

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