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...

Hi Paul

Can you post a little sample data please? I'm sure this can be done more efficiently.