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

Scripts with tag Miscellaneous Rss

Search for any content tagged miscellaneous

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

Show all database's tables' columns' collations.

Created view displays all text columns' collations in the current database with the information whether the collation is different from the database's one.  Read more...
By Rafal Skotak 2008/04/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,562 reads

Generating combinations 'm elements from n-element set'

This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.   Read more...
By Rafal Skotak 2008/04/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,127 reads

Generating permutations

This script shows one on ways of generating permutations.  Read more...
By Rafal Skotak 2008/02/27 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 986 reads

Effectively mapping primary key – foreign key relations

This script maps the primary key - foreign key relations regardless if the column names are the same or not.  Read more...
By John Liu 2012/05/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,771 reads

Collation Checker Version 2

this version 2 of my sproc to do various collation checks.   Read more...
By paul_richardson 2007/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 950 reads

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,321 reads

Get the list of permissions of database object

List permissions for an object in various ways.  Read more...
By Deepthi Viswanathan Nair 2013/12/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,447 reads

Table row count using 3 different ways

Three different ways that you can get the count of the rows in a table.  Read more...
By Mohit Nayyar 2011/06/16 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,425 reads
<< Newer    Items 21 to 40 of 834    Older >>