At the default READ_COMMITTED isolation level, you would need to SET READ_COMMITTED_SNAPSHOT ON to get row versioning isolation.

ALLOW_SNAPSHOT_ISOLATION refers to full SNAPSHOT...

vinothr 33504 (10/3/2010)

---

Hi all

I am having a table with columns say A to F. A being the primary key, B unique key. I am creating clustered index on...

CirquedeSQLeil (10/3/2010)

---

Picture being on the down end of the piano going up the stairs - only person holding it there, and everybody else takes a break. Yup - fun...

ALZDBA was asking what you set the properties to. Setting 'max...

Maybe, but you wouldn't have envied me and Justin carrying a sofa and six-burner BBQ up the stairs this morning. Comedy.

Just locally, 5km or so. The new place is on the hillside overlooking the Tasman Sea and Kapiti Island.

Clicky Map Link

Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. And I'm moving house.

Just for completeness, these are the results of the SQLCLR implementation on the original rig, now that I have a machine that can actually use parallelism 🙂

Table 'CsvTest'. Scan count...

Runs from my new laptop attached.

Personal experience of course, but I have yet to work with a PM (much less a BA) that added value to a project. The most successful enterprises I have...

Well excuse me! You didn't give that impression by...

The trace flag is 845...

It was a SQL Server limitation. I don't recall exactly when it...

Thank you, I appreciate it. More in the same style or area of the product?

But...

Paul White NZ (9/7/2010)

---

There is an optimizer quirk that means that some plans using INDEX(0) may include an unnecessary sort (which does not apply to INDEX(1)). I will be...