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

Content with tags SQL Server, T-SQL Rss

   Items 1 to 12 of 12   
 

SQL CLR Multi-Threaded File Copy

A CLR Procedure that performs multi-threaded fie copies without external command line tools.  Read more...
By Steve Ledridge 2013/11/19 | Source: SQLServerCentral.com | Category: async
Rating: |  Discuss |   Briefcase | 2,327 reads

Fastest way to find DB object dependencies

One of the fastest ways to find out objects dependencies in SQL Server.  Read more...
By Kshitij Satpute 2013/08/20 | Source: SQLServerCentral.com | Category: dependencies
Rating: |  Discuss |   Briefcase | 1,697 reads

Fastest way to split delimited string in SQL Server

Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.  Read more...
By Kshitij Satpute 2013/08/14 | Source: SQLServerCentral.com | Category: split string
Rating: |  Discuss |   Briefcase | 2,221 reads

Simplest way to search any string in db objects

Easiest way to search for a string in any object within the database.  Read more...
By Kshitij Satpute 2013/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,121 reads

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,727 reads

An in-depth look at change detection in SQL Server - Part 02

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...
By Nakul Vachhrajani 2013/02/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 5,942 reads

An in-depth look at change detection in SQL Server - Part 01

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...
By Nakul Vachhrajani 2013/02/12 | Source: SQLServerCentral.com | Category: change detection
Rating: |  Discuss |   Briefcase | 2,797 reads

Change Tracking - 2008

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.  Read more...
By Nitesh Dedhia 2012/06/18 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 7,351 reads

Identity Values – Two things to know

I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...  Read more...
By Steve Jones 2010/01/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,072 reads

Indexing HierarchyID

The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...  Read more...
By Steve Jones 2009/09/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,311 reads

Replication – Accommodating Application Inserts

Recently I have been involved in lots of projects involving replication.  I have done some things to make replication work...  Read more...
By Patrick LeBlanc 2009/08/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,223 reads

Adding Multiple Columns to a Table With a Single T-SQL Statement

You know, I believe the old saying, “If you don’t use it you will lose it”.  Well, I write a...  Read more...
By Patrick LeBlanc 2009/08/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 32,380 reads
   Items 1 to 12 of 12   
 
Tags
blogs (4)    
checksum (3)    
hashbytes (3)    
binary_checksum (2)    
change detection (2)    
conflict resolution (2)    
patrick leblanc (2)    
rowversion (2)    
async (1)    
c# (1)    
change tracking (1)    
dependencies (1)    
file copy (1)    
indexes (1)    
mssql (1)    
multi threaded (1)    
new feature of sql server 2008 (1)    
nitesh dedhia (1)    
r-bar (1)    
replication (1)    
search (1)    
split delimited string. (1)    
split string (1)    
sql (1)    
sql search (1)    
sql server 2008 (1)    
sqlclr (1)    
xquery (1)