SQL Server's default transaction isolation level is READ COMMITTED, and I'd suggest leaving it as is. Also, run the update query through Database Tuning Advisor and see what it reccomends.

steveb. (9/14/2010)

---

torpkev (9/14/2010)

---

My biggest annoyance with sa - quite outside of this discussion - is those people who use sa to connect to the database because they don't know...

I use the following script to grant permission to a "power user" role; which isn't an administrator the database but a user who occasionally needs to do things like troubleshoot...

JunkMail Victim (9/1/2006)

---

I've found them to concentrate on the compiled executables of the client applications, but not think much about the unencrypted business logic that resides in stored procedures and...

What do you mean by ReadOnly columns?

If it were me, I'd script it all out. From what I've read, I'd suggest you use the Import and Export Wizzard to copy the required tables. You have the...

A few years back I was trying to debug a...

Each client tool has it's own connection and maybe even different connection settings. For example different values for ANSI_WARNINGS, ANSI_NULLS, QUOTED_IDENTIFIER, etc. can result in different execution plans. Some settings...

Mike Byrd (9/13/2010)

---

At first reading I thought that was a neat idea, but on reflection (and sadly experience), what runs on one machine and one set of data does not...

Jeff Moden (9/12/2010)

---

The "best plan" is dictated only by four things and only two of those really matter where performance is concerned...

4. Code - This is where the true...

The more enlightened economists point out that recessions are a perfectly natural part of long term economic cycles, and it always preceeds some transition to a new paradign. Companies...

When it comes to installing SQL Server Standard and Enterprise edition for a corporate IT groups, these installations are typically performed by a DBA who is familiar with the options...

The following query should give you the last 3 backups for each database and include the columns: database_name, recovery_model, backup_type, size_gb, backup_start_date, backup_finish_date, and duration_minutes.

select * from

(

select...

If Information Technology ever stopped being fun and rewarding, civilization would soon collapse.

What makes the TRUNCATE statement more efficient is that it...