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

Content with tag Scripts Rss

   Items 1 to 9 of 9   
 

Universal foreach aka sp_uforeach

This script is a universal foreach stored procedure. You can loop through everything with the help of if.  Read more...
By Robert Virag 2013/09/24 | Source: SQLServerCentral.com | Category: scripts
Rating: |  Discuss |   Briefcase | 1,494 reads

Do you regularly run queries and scripts in SSMS?

SQL Server Management Studio is where most SQL scripts and queries are run, and although it does a decent job, it doesn't provide much help storing, sharing and managing the scripts particularly in the context of a team. Red Gate is considering building functionality into SSMS to help its users consume and share queries and scripts. Please help us by completing this short survey to help us define the requirements.   Read more...
By Press Release 2013/04/12 | Source: Red-Gate | Category: scripts
Rating: (not yet rated)  Rate this |   Briefcase | 3,370 reads

Grouped Failover, a 2008R2 version of Availability Groups

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.  Read more...
By Remko de Boer 2013/01/24 | Source: SQLServerCentral.com | Category: scripts
Rating: |  Discuss |   Briefcase | 457 reads

Find data difference between two datasets

Find data difference between two datasets  Read more...
By Atif-ullah Sheikh 2010/10/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,672 reads

SSRS Expressions Tips and Tricks

Some of the expressions and functions that have come in handy while developing reports in SSRS  Read more...
Rating: |  Discuss |   Briefcase | 19,300 reads

Tally Table - Character Date Validation

Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied...  Read more...
By Seth Phelabaum 2009/12/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,220 reads

Review of SQLZip

Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider!   Read more...
By Andy Warren 2002/04/16 | Source: SQLServerCentral.com | Category: product reviews
Rating: (not yet rated) |  Discuss |   Briefcase | 5,668 reads

Review of Data Compare v.151

In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!   Read more...
By Andy Warren 2001/10/31 | Source: SQLServerCentral.com | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 8,742 reads

BCP Data Dynamically

This tip will show you how to BCP data out of every table with one command.   Read more...
By Brian Knight 2001/06/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 7,363 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (2)    
advanced querying (1)    
backup / restore (1)    
blogs (1)    
code (1)    
date manipulation (1)    
expressions (1)    
foreach (1)    
function (1)    
grouped failover (1)    
management studio (ssms) (1)    
miscellaneous (1)    
product reviews (1)    
replication (1)    
reporting services (ssrs) (1)    
reviews (1)    
sql server 2005 (1)    
sql server 7 (1)    
stored procedure (1)    
tally table (1)    
tips and tricks (1)