SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Scripts with tags Data Warehouse, Maintenance and Management Rss

Refine your search with one of the following additional tags (with number of items):

Miscellaneous (22)     SQLInsider Scripts (6)     Lock and Connection Management (3)    
T-SQL Aids (14)     Replication (5)     Mail (3)    
Backup / Restore (6)     Index Management (4)    

Search for any content tagged Data Warehouse & Maintenance and Management

Add a script

   Items 1 to 20 of 29    Next 20 >>
 

How to insert and update from remote linked server

Read more...
By Chris Morton 2007/10/30 | Category: Replication
Rating: |  Discuss |  Briefcase | 1,286 reads

Function to Split a Delimited String into a Table

Read more...
By Andy Brown 0001/01/01 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,470 reads

Send SMS from a trigger

Read more...
By Al Siks 2007/04/16 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 7,165 reads

Format Value To Currency

Read more...
By Al Siks 2006/01/10 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 318 reads

Stored Proc to List Columns for a Primary Key

Read more...
By Charles Hawkins 2006/09/14 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 371 reads

Script to get total rows and space used

Read more...
By Felix Garcia Cruz 2006/08/18 | Category: T-SQL Aids
Rating: |  Discuss |  Briefcase | 527 reads

Function to return the SQL Version Number

Read more...
By Andy Brown 0001/01/01 | Category: Replication
Rating: |  Discuss |  Briefcase | 525 reads

Function to return the SQL Build Number

Read more...
By Andy Brown 0001/01/01 | Category: Replication
Rating: |  Discuss |  Briefcase | 435 reads

UDF: Estimating the size of a table

Read more...
By Jason 2006/06/21 | Category: Data Warehouse
Rating: |  Discuss |  Briefcase | 228 reads

Display Person Initials

Read more...
By Sean Robert Ceton Cooperman 0001/01/01 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 194 reads

Automate renaming columns

Read more...
By jdlambert 2006/04/12 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 246 reads

Analyze a Table Contents

Read more...
By williamhoos@yahoo.com 2005/03/22 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 450 reads

Get Table Count without using COUNT

Read more...
By Additional Articles 2004/10/04 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 250 reads

Proper Case the data in the Table

Read more...
By vidya_pande | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 302 reads

Count and display number of rows in all tables

Read more...
By jasonlu | Category: Data Warehouse
Rating: |  Discuss |  Briefcase | 159 reads

Drop Statistics

Read more...
By jstange | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 347 reads

Frequency of each field in table

Read more...
By Brian Nordberg | Category: Data Warehouse
Rating: |  Discuss |  Briefcase | 91 reads

Proc to Query MSDB..SYSJOBS and SYSJOBSTEPS

Read more...
By jackdonnell | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 632 reads

Proc to Query Syscomments and Sysobjects

Read more...
By jackdonnell | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 354 reads

Get table sizes and rowcounts in MB (for VLDB)

Read more...
By Mike Pearson | Category: Data Warehouse
Rating: |  Discuss |  Briefcase | 537 reads
   Items 1 to 20 of 29    Next 20 >>
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use