Isolation Levels

Transactions

Isolation levels - Database Engine

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

Which is faster or better for performance ??

hi, which of the (2) is faster or better for performace..  #tempTable or @table i have read information on both..  thanks  

storing business objects as Blob in the DB

We are currently debating how to store BO's within our SQL Server DB.We have a object to relational mapping layer that allows us to map BO's to DB tables. It has been suggested that we take the serialised BO graph and just place it in to a blob within the DB.I'm looking for any pro's 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: Hidden Dangers!

I would like to understand how this is working in the first place. Does anyone have a minute to tell me more about how it works.Also I noticed that it will pick up any servers you have registered and will not pick up the 'local' server if it is noted possibly in the registry as such. 

Trigger to list columns updated

Below is a trigger that I'm TRYING to use (in SQL2000) to list which columns are updated. However, it never stops running and I can't determine why. Apparently the WHILE maybe generating an infinite loop. To test, just change the table name 'admin' in a few places. Any help would be appreciated. ------------------------------------------------------------------ CREATE Trigger tr_admin -- list all […]

RE: sproc problemmmm

I guess I hadn't noticed the Command type drop down box.Once I changed that, it worked like a charm.  Thanks!!!Jarret