GilaMonster (4/25/2012)

---

But SQL needs to be stopped when running that. The...

auto shrink 🙂

This is a one-year-old thread. Please start new threads, even if they are similar topics.

I didn't read the umpteen replies to the OP, but ANY TIME I see "ran slow the first time and very fast the second time" I IMMEDIATELY think the IO...

SQLIOSIM is the tool to use to validate that an IO subsystem will properly handle SQL Server IO-style workloads.

Sean Lange (4/24/2012)

---

As another thought you should read this article about using the nolock hint.

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Basically, you should not use it, ever. Dirty reads can be acceptable in some situations...

It seems that once again people went with partitioning without really understanding what it can (and cannot) do for them. If you statement is true that you are partitioned...

Hey Jeff, can you put a downloadable file with the relevant operational code parts of the post? Thanks in advance, and wonderful stuff as always!

>> No one can fault a DBA for saying "look I did the research, reviewed the doc and followed the best practice recommendation from Microsoft".

I absolutely can, and...

Unlike Lynn, I DO know...

<RANT ON>

To anyone interested in using SQL Server partitioning, LISTEN UP:

SQL Server partitioning is a COMPLEX subsystem with MANY gotchas, requirements, provisos, etc!!! You CANNOT POSSIBLY HOPE TO BE...

You may be onto something with the settings for linked server being different. But also make sure you updated all statistics in 2008 database with a FULLSCAN. This...

ricardo_chicas (4/23/2012)

---

Hello all

actually all I did was to reate a loop that read the data 10000 records at the time, that allow me to use one of the main indexes...

Jeff Moden (4/22/2012)

---

I have to ask... since you have to drop and recreate the ColumnStore Index to update the underlying tables, does anyone have any specs on how long it...

With that small number of rows and rows-to-delete, I am guessing you were simply blocked. Run sp_who2 active while you are trying to do the delete to see who...