And on that note, I'm calling troll and dropping this thread. It's been enlightening. Ya'll have fun.

Are you sure you're in SQL Server 2005? I just connected up to one of our 2005 instances, ran it and got back information. It's right there in the DB....

Auditing is a way of tracking the changes in data over time. If all you're interested in is seeing activity and performance, I'd stick with using Profiler and server-side trace.

Also,...

Also, it's worth noting, there are pretty vast differences between 2000 and 2008. You need to be sure that your 2000 database is compatible with 2008. If you have not...

In addition to what Ron notes, spend the time to learn T-SQL. Access querying and T-SQL querying are just not the same.

No, that's normal. What you'll see is that when updates are occurring, a version of the row is stored off in tempdb and that will be used instead of the...

CirquedeSQLeil (7/13/2010)

---

Jim McLeod (7/13/2010)

---

I love...

Yep, what he said. Just because the column is part of the primary key does not mean you can only use that. I used to have a sign up on...

CirquedeSQLeil (7/13/2010)

---

Grant Fritchey (7/13/2010)

---

It's not 1000 rows, it's a 1000 pages and, it's...

It's not 1000 rows, it's a 1000 pages and, it's a made up...

Novicejatt (7/13/2010)

---

Hi,

I can Arhive the files in a datewise format. But Can you explain this a little more how to use this with BULK INSERT.

I also found a solution by...

Jeff Moden (7/13/2010)

---

Stefan Krzywicki (7/13/2010)

---

Jeff Moden (7/13/2010)

---

CirquedeSQLeil (7/13/2010)

---

Here's another one in the same doc.

As a rule of thumb, once a table has more than five indexes, updates to that table...

Couldn't connect to a 2005 server real quick, but I got this off of MSDN. It should be there in 2005.

itsmeman (7/13/2010)

---

I discovered that the queries in question were victims because of SQL jobs running causing them to die. Just seems odd that the duration would go so long. I...

brandon_ledbetter (7/13/2010)

---

Thanks - good to have a name to identify the problem with. Suprising that the DBA's at the MS tech conferences (PDC, local TechFest, etc) I have been...