Sign in | Join | Help

Piotr Rodak

if datepart(dw, getdate()) in (6, 7)
use pubs;

This Blog

  • Home
  • Contact

Syndication

  • RSS
  • Atom
  • Comments RSS

Search

  • Go

Tags

    • bcp
    • BLOB
    • bug
    • bulk insert
    • c#
    • collation
    • concurrency
    • configuration
    • data access
    • data import
    • database maintenance
    • deadlocks
    • distributed transaction
    • download
    • error
    • errors
    • ETL
    • events
    • format files
    • linked server
    • locking hits
    • MARS
    • Numbers table
    • OLE DB
    • OPENQUERY
    • performance
    • photography
    • practices
    • Profiler
    • programming
    • Reporting Services
    • revelations
    • scientific notation
    • script
    • security
    • source code
    • SSIS
    • SSRS
    • Sybase
    • Tally table
    • textsize
    • tips and tricks
    • trace flags
    • trigger
    • troubleshooting
    • truncate
    • t-sql
    • util

Navigation

  • Home
  • Blogs
  • Forums
  • Photos
  • Downloads

Archives

  • March 2010 (1)
  • February 2010 (2)
  • January 2010 (4)
  • December 2009 (2)
  • November 2009 (1)
  • October 2009 (2)
  • September 2009 (1)
  • July 2009 (1)
  • June 2009 (1)
  • May 2009 (1)
  • April 2009 (1)
  • March 2009 (1)
  • November 2008 (1)
  • April 2008 (1)
  • December 2007 (1)
  • November 2007 (3)
  • October 2007 (2)

Browse by Tags

All Tags » deadlocks (RSS)
  • concurrency
  • locking hits
  • performance
  • trace flags
  • troubleshooting
  • t-sql
04 January 2010 22:10

updlock, holdlock and deadlocks

We have a process that manages sliding window over a number of tables in our reporting database. This process is triggered by first call to our reporting ETL. There is table that contains two dates that are important for the partitioning and business...
Posted by Piotr Rodak | 1 comment(s)
Filed under: t-sql, performance, trace flags, deadlocks, concurrency, troubleshooting, locking hits
 
Powered by Community Server (Commercial Edition), by Telligent Systems