Dealing with High Concurrency with Table Hints

Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.

READPAST vs. NOLOCK

Using NOLOCK and READPAST table hints in SQL Server

Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server

RE: Data Modeling Question

Sounds like you've already gotten some good advice.  I would suggest that you might want to make your Broker & Assistant tables date sensitive, i.e., with a StartDate and EndDate.  This way you don't loose any data when an Assistant is promoted to a Broker status you just record the EndDate as an Assistant and […]

Help using TOP n

I've been struggling with this one for a while.  Guess it's easy when you know how??I am running a query across two views.View A contains People recordsView B contains diary entries for those people records.There are multiple diary entries on View B for each of the View A RecordsI want to run a query giving […]

RE: Yes/No field in sql server table what is the same

Access, I believe simply represents the FALSE boolean value (both in data storage and in VBA script) as -1. Both systems actually just look for the absense of zero, not the existence of 1 or -1. I suppose technically it could be -1, 1, or 5 for that matter since internally, it's looking to see […]