nadersam (5/26/2010)

---

Grant Fritchey (5/26/2010)

---

I would suggest using connection pooling. As much as possible, reusing connections is the way to go because it reduces the amount of memory that connections take...

Jeff Moden (5/25/2010)

---

Steve Jones - Editor (5/25/2010)

---

Hyperbac, owned by Red Gate now, does something similar. You can work with a backup file as though it were a real database. The...

Since you're working in 2005, I'd suggest, especially for targeted information like this, to use the dynamic management views to pull the execution plans and execution information directly from the...

I would suggest using connection pooling. As much as possible, reusing connections is the way to go because it reduces the amount of memory that connections take up (new memory...

If you use the "fake" key in your...

karthikeyan-444867 (5/26/2010)

---

GilaMonster (5/25/2010)

---

There's a big, massive, huge difference between not using an int identity for a primary...

Identity gaps are only an issue if, for whatever reason, you're assuming a perfect chain of numbers. Don't make that assumption and the gap problem goes away. The idea is...

Jeff Moden (5/25/2010)

---

Grant Fritchey (5/25/2010)

---

Jeff Moden (5/25/2010)

---

Grant Fritchey (5/25/2010)

---

Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on...

Sandy2704 (5/25/2010)

---

Trasactions in our application generally range between 7 to 40 /sec......The application is not huge.....I am using a third party tool called precise i3(It gives me alert messages whenever...

Gianluca Sartori (5/25/2010)

---

Grant Fritchey (5/25/2010)

---

I haven't been posting here at the water cooler because, frankly, I was appalled at how many posts I had here. But I have to share...

Grant Fritchey (5/25/2010)

---

I haven't been posting here at the water cooler because, frankly, I was appalled at how many posts I had here. But I have to share this one...

Just to give one example, our developers wrote a piece of code that made every call to the database, three times. So...

Jeff Moden (5/25/2010)

---

Grant Fritchey (5/25/2010)

---

Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on the system. You should...

I haven't been posting here at the water cooler because, frankly, I was appalled at how many posts I had here. But I have to share this one because it...

Come on Karthik. You've got the name, Joe Celko, and you have...