Oops - humble apologies, JB. Glen's written the same suite for different versions, have you looked for 2k?

SQL Server 2005 Diagnostic Information Queries

...

aaron.reese (5/1/2012)

---

Guys,

I have a table with 48M rows in it which I had to copy from one database to another (same instance). to improve performance of the copy I...

LOL! You got me 😛

I had an interview last friday morning....

Jeff Moden (4/30/2012)

---

ChrisM@Work (4/30/2012)

---

dwain.c (4/30/2012)

---

ChrisM@Work (4/30/2012)

---

dwain.c (4/29/2012)

---

...Actually I like writing them because I figure the more I do the better I'll understand them. I did say it wouldn't perform...

dwain.c (4/30/2012)

---

ChrisM@Work (4/30/2012)

---

dwain.c (4/29/2012)

---

...Actually I like writing them because I figure the more I do the better I'll understand them. I did say it wouldn't perform as well (I...

dwain.c (4/29/2012)

---

...Actually I like writing them because I figure the more I do the better I'll understand them. I did say it wouldn't perform as well (I tested) but...

Careful with that axe, Eugene

Stop that! It's two hours to Beer O'Clock!

Sample data:

CREATE TABLE #Sample (Doc_Nbr int,Ticket_Nbr int)

INSERT INTO #Sample

SELECT 12,907 UNION ALL

SELECT 12,908 UNION ALL

SELECT 12,909 UNION ALL

SELECT 12,913 UNION ALL

SELECT 12,915 UNION ALL

SELECT 12,919 UNION ALL

SELECT 14,1481 UNION...

pwalter83 (4/27/2012)

---

This is a sample data from a stored procedure not a table....

Oh come on, Paul - none of us is going to retype from a bitmap! Be nice!

Cadavre (4/26/2012)

---

ChrisM@Work (4/26/2012)

---

Cadavre (4/26/2012)

---

...

The issue is that you're using formatted data in the database. Instead, you should store this as TIME or DATETIME then convert it to the correct format...

Cadavre (4/26/2012)

---

...

The issue is that you're using formatted data in the database. Instead, you should store this as TIME or DATETIME then convert it to the correct format at the...