Sean Lange (11/30/2011)

---

Jeff Moden (11/30/2011)

---

Actually, there's a great way to track it without a trigger if you can add a column as Kingston suggested. The difference is that you...

GilaMonster (11/16/2011)

---

Michael Valentine Jones (11/16/2011)

---

My preference is to set the database to read_committed_snapshot and never have to worry about any of this again.

use master;

alter database [MyDB] set allow_snapshot_isolation on;

alter database...

Steve Malley (11/16/2011)

---

My personal preference is to use the statement:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

at the beginning of predominantly read-only stored procs. That way, you don't need the...

Using SNAPSHOT isolation or READ_COMMITTED_SNAPSHOT completely avoids any need to use NOLOCK and avoids its bad side effects.

Since this has been available since the release of SQL 2005, there is...

ben.brugman (11/15/2011)

---

To which snapshot technique are you refering?

We have a single development database but about 20...

Maybe the hidden code is:

waitfor delay '00:00:01.000'

🙂

My guess would be that there is more code on other lines within the TextData column that is not showing in the grid view.

Try looking at the TextData in a...

Restore the DB onto the Dev server, and then make a snapshot.

Then you can run normal testing with transactions, and restore the database from the shapshot when you are done....

If it is critical to have TmpID in order by RealSort, you should use ROW_NUMBER()

DECLARE @TMP TABLE( TmpID INT, TmpDATA VARCHAR);

INSERT INTO @TMP (TmpID, TmpDATA)

SELECT

ROW_NUMBER() OVER(ORDER BY RealSort) as TmpID,

RealDATA

FROM...

The biggest issue is that when you add or drop a column the query will return a different result set and the application will not be prepared for the change...

assefam (11/11/2011)

---

When we backup the database 5 days a go, it was very large log file. Immediately after the back up, we created new log file and deleted the previous...

select DT = dateadd(dd,-6,dateadd(dd,((datediff(dd,-53684,dateadd(mm,datediff(mm,0,getdate())-1,6)+7)/7)*7)-7,-53684))

Results:

DT

-----------------------

2011-09-26 00:00:00.000

Object changes are recorded in the default trace, so the details of when the change happened should already be available if the the default trace files haven't rolled over yet.

This would be a good time to review the application to see if there is truly a need to use a serializable isolation level.

It’s likely that that a less restrictive...

I just thought of the ultimate captive audience:

The Marine boots in the movie Full Metal Jacket being subjected to the spectacular profanity of Gunnery Sergeant Hartman (played by R. Lee...