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 Maintenance and Management, Data Warehouse 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 Maintenance and Management & Data Warehouse

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

Function to Split a Delimited String into a Table

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

Send SMS from a trigger

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

Format Value To Currency

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

Stored Proc to List Columns for a Primary Key

Read more...
By Charles Hawkins 2006/09/14 | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 392 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 | 570 reads

Function to return the SQL Version Number

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

Function to return the SQL Build Number

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

UDF: Estimating the size of a table

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

Display Person Initials

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

Automate renaming columns

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

Analyze a Table Contents

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

Get Table Count without using COUNT

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

Proper Case the data in the Table

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

Count and display number of rows in all tables

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

Drop Statistics

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

Frequency of each field in table

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

Proc to Query MSDB..SYSJOBS and SYSJOBSTEPS

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

Proc to Query Syscomments and Sysobjects

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

Get table sizes and rowcounts in MB (for VLDB)

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