Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Deadlocks with read

    Dale,

    You likely have another process (or two) that is performing an insert, update, or delete on the resources of the data you are requesting.  sp_who2 is a helpful system stored...

  • RE: Deadlocks

    Executing sp_who2 from Query Analyzer is a quick way to see if you have any existing blocks.  It allows you to see what blocked by another spid at the time sp_who2...

  • RE: Joins vs More Columns

    Don't forget that with a denormalized table you will be repeating the same information for each each property a person has with multiple values (multiple phone numbers and types, emails,...

Viewing 3 posts - 1 through 3 (of 3 total)