Translate This Page
Translate this page
Azure Management API
Browse by Tags
Tagged Content List
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...
28 Sep 2011
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...
28 Sep 2011
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...
6 Feb 2011
Page 1 of 1 (3 items)
© 2013 Microsoft Corporation.
Privacy & Cookies