Browse by Tags

Tagged Content List
  • Blog Post: SQL Server Parallelism–The Dark Side

    I just upgraded my dev box from four cores to six cores with a bunch of memory. I was excited to see how fast my multithreaded, data intensive program would run. I launched it and my previously exception free program started throwing SQL Server query timeout exceptions. I was not impressed! Rebuilding...
  • Blog Post: SQL Server 2008 R2 Change Tracking and Backup Fix

    My database server rebooted unexpectedly and I started getting this error each time I’d try to backup the database or do some other operations like dismount, etc. Cannot insert duplicate key row in object 'sys.syscommittab' with unique index '<Index Name>'. Failed to flush the commit table to disk...
  • Blog Post: SQL Server 2008 Column Change Tracking

    I could not find a good description of how SQL Server Change Tracking determines if a column changed so I decided to give it a try in 2008 R2 using the script below.  Basically in the last update statement I update a column to the same value which already exists in the column.  SQL appears...
Page 1 of 1 (3 items)