Definately an issue. None of the data was cache'd in memory yet, the server was busy using the disks, and your CPU was probably spiked to 100%.

I wouldn't worry...

I saw it once in a blue moon on an equivalent system. Vendor built, horrendous structure, etc.

What we eventually puzzled out (without proof, might I add, this...

e3h4 (10/12/2010)

---

People often assume you need to use GUIDs for unique values across databases and for replication. However, there is an easy way to get around that using an...

Mod this a little and it should get you where you're going. The trick is using the date manipulation functions and the datediff thresholds.

CREATE TABLE #tmp

( LockEndDate DATETIME)

INSERT INTO...

This is going to sound mean, but we can't help you with this one without having a copy of the database.

The error says exactly what it means, one of the...

I've found that 90% of the time a spid 'blocks itself'... it's waiting on Disk IO, which is what PAGEIOLOCK means.

Tell them the disks are slow, and take a look...

Well, for starters, it's going to want a year.

I don't have 2k8 handy to run a direct test for datetime2, but stripping off the 'day of week' at the beginning...

I'll second the request for this. The once in a blue moon I actually want this I'll turn it back off.

Eric, I believe you're on the right track regarding memory.

FOR XML by itself is not going to the problem, any more then any heavily used, large result set query would...

KJ:

I see what you're trying to do here. You've got a starting sum (or a continuously added to sum) and then negatives in another structure you want both a...

Well,...

For the prepended PPCI parts, change the select into for #Contiguous to this:

SELECT

--Pattern,

--Series,

--MIN( StartNum) AS BeginSeries,

--Max( EndNum) AS EndSeries

Pattern + CAST( MIN( StartNum) AS VARCHAR(100)) AS BeginSeries,

Pattern + CAST(...

That is seriously wierd. You are running the code end to end, right? Only change the...

This should do it:

DROP TABLE #gaps

DROP TABLE #Contiguous

DROP TABLE #MidPoint

CREATE TABLE #MidPoint

(RowID INT,

PrevRowID INT,

Pattern VARCHAR(100),

Startnum BIGINT,

EndNum BIGINT,

Series INT

)

INSERT INTO #Midpoint

( RowID, Pattern, StartNum, EndNum)

select

ROW_NUMBER() OVER (ORDER BY

left(controlnumber, PatIndex('%[0-9]%', controlnumber)-1),

convert(int,...

craig-404139 (10/8/2010)

---

Craig if you were local i'd buy you a beer. We killed 2 birds with one stone. I needed to identify the ranges of sequential numbers (my code) and...