I have, not a peep. Haven't seen DBCC CHECKDB run on any of my servers without me running it, and I have been working with...

fsr645 (8/28/2012)

---

I was investigating the thought process on the 2nd query (using row_num) and I was impressed how Lynn came up with the grp field "TN - row_number() over (partition...

Not that I am aware of.

Also, the 2nd version can be modified slightly to this (basically the same, but different):

CREATE TABLE #Temp

(TNID INT, TN BIGINT);

INSERT INTO #Temp

SELECT 3011170, 4402787100

UNION ALL SELECT...

My last was a SQL Server 2000 version. Since you are using SQL Server 2008, I'd use the ROW_NUMBER() version (the 2nd).

fsr645 (8/28/2012)

---

Lynn,

I tried your second query and it works perfectly. Great work. Will I run to a maxrecursion with this too? What is the max data for the maxrecursion happens?...

Anybody have a SQL Server 2000 instance? Please give this a try:

CREATE TABLE #Source

(TNID INT, TN BIGINT);

INSERT INTO #Source

SELECT 3011170, 4402787100

UNION ALL SELECT 3011170, 4402787101

UNION...

Now someone tells me! Time to hit the desk with my head.

Hate to say it, but mud is clearer. I can't even...

David Benoit (8/28/2012)

---

Additionally, you are using SATA disk which are not going to perform as well. I would be interested to know what the RAID configuration is still. As Lynn...

Here is another option that appears to work for the given test data:

CREATE TABLE #Temp

(TNID INT, TN BIGINT);

INSERT INTO #Temp

SELECT 3011170, 4402787100

UNION ALL SELECT 3011170, 4402787101

UNION...

GSquared (8/28/2012)

---

Lynn Pettis (8/28/2012)

---

Here is my shot at the solution.

CREATE TABLE #Temp

(TNID INT, TN BIGINT);

INSERT INTO #Temp

SELECT 3011170, 4402787100

UNION ALL SELECT 3011170, 4402787101

UNION ALL SELECT 3011170,...

And here I am trying not to use my PTO time this year to earn some extra cash, what isn't used by the end of the year is cashed out....

Since you are sharing spindles with other servers, looks like you need to have the SAN guys monitor what is happening during the backups. Looks like contention between serveral...

Here is my shot at the solution.

CREATE TABLE #Temp

(TNID INT, TN BIGINT);

INSERT INTO #Temp

SELECT 3011170, 4402787100

UNION ALL SELECT 3011170, 4402787101

UNION ALL SELECT 3011170, 4402787102

UNION ALL SELECT...