This particular database is about 80GB and the log is around 2 GB. I need to get them around 10...

Crud. Alright, I'll ask it. Why wouldn't a table stored in memory be faster as long as it was small? I can see that a large table...

CirquedeSQLeil (4/1/2010)

---

I enjoyed the blog post. I felt silly that I hadn't thought of a great idea like that (or blogging for April Fools Day). I had nothing...

SSD? Oh wow. I'm drooling now.

I do set the DB to simple before I start and shrink the TLog after all the other scripts have run. The first...

Looks like there are no good ideas. If it gets real bad, I may try to script something, but I feel more comfortable deleting data then programatically recreating the...

Lynn Pettis (3/27/2010)

---

Now, you are back on the spot. Based on what you know of me, what would be one question you'd ask me in an interview. I'll...

Trey Staker (3/24/2010)

---

Funny how things happen. I was just working on a nightly process to do something like this. Do you mind if I borrow your code and modify...

Wahoo! I have a new favorite browser 🙂

Chad

I use this on 2K5. I have a job that runs every night and stores it in a table so I can see historical trends - also allows me...

GSquared (3/23/2010)

---

When my dad was in high school, they had a class that had the specific purpose of preparing the students for their standard tests (I think it was the...

Jack Corbett (3/18/2010)

---

Were you at the 2009 Summit? I hope not because I think I missed you there then. Either...

How did this work? I just registered for PASS (wahoo!), used the SSC code and got $200 off the registration? I had heard that you couldn't use the...

That was EXACTLY my thought too. Update AuthorPostCount SET Posts = Jeff+3000 WHERE Username =...

Thanks Jason, I pulled some nice stuff from your article and now have a quick reference for log growth issues!

I liked the question! I've found that in our environment the primary key is very often a bad choice for the clustered index, so I have become more aware...