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

Content with tag SQLInsider Scripts Rss

   Items 1 to 20 of 239    Older >>
 

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,293 reads

Delete Duplicates in SQL 2000, SQL 2005, SQL 2008 or Higher

Delete Duplicates in SQL Server without using Cursor or Temporary tables  Read more...
By BINU PRASAD.M 2012/06/21 | Source: SQLServerCentral.com | Category: sqlinsider scripts
Rating: |  Discuss |   Briefcase | 3,166 reads

Generate Job Schedule Descriptions

A SELECT statement which includes the alpha description of each job's schedule  Read more...
Rating: |  Discuss |   Briefcase | 4,143 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,414 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,293 reads

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.  Read more...
By Jesse Roberge 2009/07/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 1,201 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,121 reads

Delimited String Parsing Functions - Big2D set

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,061 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,576 reads

Delimited String Parsing Functions - 2D set

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 996 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,249 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 877 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 452 reads

Generate Job Schedule Descriptions

A SELECT statement which includes the alpha description of each job's schedule  Read more...
Rating: |  Discuss |   Briefcase | 4,143 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,293 reads

Find Table Usage

By kgayda 2007/10/23 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,244 reads

Find Table Usage

By kgayda 2007/10/23 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,244 reads
   Items 1 to 20 of 239    Older >>
 
Tags
miscellaneous (131)    
t-sql (123)    
maintenance and management (87)    
indexing (18)    
backup / restore (14)    
data warehousing (12)    
advanced querying (8)    
development (8)    
nums (8)    
table of numbers (8)    
tally (8)    
counter (7)    
sql server 2005 (7)    
mail (6)    
arrays (5)    
delimited strings (5)    
lock and connection management (5)    
parse (5)    
string manipulation (5)    
sql server 7 (4)    
replication (3)    
2-dimensional arrays (2)    
table (2)    
prime (1)    
prime number (1)    
sieve (1)