Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Reference Rss

   Items 1 to 7 of 7   
 

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2016/01/01 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 10,865 reads

Dependencies and References in SQL Server

It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you need to work out what process is accessing that view you want to alter, or maybe find out whether that table-type you wish to change is being used. What are all these dependencies? How do you work out which are relevant? Phil Factor explains.  Read more...
By Additional Articles 2015/10/23 | Source: SimpleTalk | Category: dependencies
Rating:  Rate this |   Briefcase | 2,969 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 5,042 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 5,042 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 5,042 reads

'Just Google It'

A short editorial explaining the pitfalls of using search engines as reference for DBA's.  Read more...
By Bas de Zwart 2010/08/05 | Source: SQLServerCentral.com | Category: reference
Rating: |  Discuss |   Briefcase | 298 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2016/01/01 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 10,865 reads
   Items 1 to 7 of 7   
 
Tags
calculate (1)    
calendar (1)    
complex (1)    
data (1)    
date (1)    
delete (1)    
dependencies (1)    
dimension (1)    
domain (1)    
editorial (1)    
generate (1)    
google (1)    
insert (1)    
lookup (1)    
merge (1)    
migration (1)    
parameterization (1)    
populate (1)    
static (1)    
update (1)