TAMMYAUDETTE (4/12/2010)

---

Thanks for all the replies!

I am genuinely grateful for the help I've received so far, and I look forward to the point where I can take what I've learned...

I hope that person didn't read the whole article and still come away with the impression that it was serious... but it looks like they came away with that impression,...

It's possible that you have some skewed data that when used to generate the execution plan, it results in a bad plan, but when different data is used, you get...

Then you need to resort to traditional methods. Make a much bigger log file. Break up the transaction into smaller parts, either commit seperate sections of the process instead of...

Yeah, you can gather a lot of performance metrics from DMV's. You can't get into what's occurring within an execution plan with anything except execution plans, but you can get...

Try putting tblHolding into a database and then setting the Recovery to simple. That way the log will only hold open transactions and those transactions completed between checkpoints. You won't...

I'd need more details to be sure, but it sounds like you're seeing execution plans change during the day. Updating the stats causes the plan to recompile. I'd suggest getting...

If it was working two days ago and it's not working now, something changed somewhere.

It doesn't state explicitly that you're using SQL Agent to run this, but I'll assume so....

sp_updatestats uses a sampling methodology to build the statistics for the table. This means that it's not looking at all the data available to build the statistics. Most of the...

Idera's PowerShell Plus

Red Gate's SQL Search

Ascendo Datavault

GTD Outlook plugin

And since I'm here...

Access? You just got voted off the island and we're considering reinstating tar, feathers and getting a ride on...

I know you already figured it out, but just in case, I saw this:

http://www.mssqltips.com/tip.asp?tip=1902

I've never done this stuff, so I have no idea how useful it might be.

I'm with Michael, define the "True DBA" and I'll tell you if I meet that requirement.

I know that a lot of my tasks fall into traditional DBA areas. I also...

Why not just go right to the source?

What's New in SQL Server 2008

Ha! I did office clean-up for a while too. I agree, it teaches lots of lessons. And, it provides excellent perspective. I'll always remember just how sweet I've got it...

Gianluca Sartori (4/8/2010)

---

WayneS (4/7/2010)

---

As a parent, you always need to be ready to follow through on any threat that you make. And the sooner you do it, the sooner the...