Geeks With Blogs
Daniel Hester Microsoft Integration Architecture, Frameworks and Technologies SQL Server
SQL Server Table Polling by Multiple Subscribers
Background Designing Stored Procedures that are safe for multiple subscribers (to call simultaneously) can be challenging. For example let’s say that you want multiple worker processes to poll a shared work queue that’s encapsulated as a SQL Table. This is a common scenario and through experience you’ll find that you want to use Table Hints to prevent unwanted locking when performing simultaneous queries on the same table. There are three table hints to consider: NOLOCK, READPAST and UPDLOCK. Both ......

Posted On Wednesday, September 5, 2012 3:09 PM

SQL Server 2008 R2 setup fails on a Windows Virtual PC (VPC) with error code 2337
When installing SQL Server 2008 R2 (Developer, Standard, or Enterprise) within a Virtual PC you may suffer the following problem: “The following error has occurred: The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2337.” The error occurs in the following package: sql_engine_core_shared It turns out that this problem is with the DVD/ISO Mounting Feature in Windows Virtual PC. To workaround the problem you need ......

Posted On Wednesday, May 16, 2012 3:17 PM

Copyright © Daniel Hester | Powered by: