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

Content with tag truncation Rss

   Items 1 to 3 of 3   
 

Five percent rounded down

By Mike Tanner 2012/10/24 | Category: cast
Rating: (not yet rated) |  Discuss |   Briefcase | 2,166 reads

Using a function to parse/return the Nth field of a delimited column

A useful SQL function to parse a single string with delimited values for the "N"th occurrence  Read more...
By John Burnette 2009/11/06 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 1,262 reads

usp_ShrinkDBLogs

A T-SQL script to truncate your user database logs.  Read more...
By Banyardi Schmardi 2008/11/20 | Source: SQLServerCentral.com | Category: log
Rating: |  Discuss |   Briefcase | 943 reads
   Items 1 to 3 of 3   
 
Tags
cast (1)    
delimiters (1)    
etl (1)    
integration services (ssis) (1)    
log (1)    
parsing column data (1)    
rounding (1)    
shrink (1)    
string manipulation (1)    
t-sql (1)    
user-defined functions (1)