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

Content with tag IDENTITY Rss

   Items 1 to 3 of 3   
 

QOTD Truncating Identity

By Wayne West 2016/03/10 | Category: identity
Rating: (not yet rated) |  Discuss |   Briefcase | 1,263 reads

Explicit Transactions

There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.  Read more...
By Steve Hall 2015/12/30 | Source: SQLServerCentral.com | Category: explicit transactions
Rating: |  Discuss |   Briefcase | 4,266 reads

Best design for OLTP tables

By Uwe Ricken 2015/08/06 | Category: clustered index
Rating: (not yet rated) |  Discuss |   Briefcase | 1,760 reads
   Items 1 to 3 of 3   
 
Tags
@@trancount (1)    
clustered index (1)    
dbcc checkident (1)    
explicit transactions (1)    
heap (1)    
oltp (1)    
savepoints (1)    
truncate table (1)    
with mark (1)