I'll try to attend the Summit regardless of where it's held. That said, I'd still like to see it move around a bit. Seattle is a pretty major travel commitment...

GilaMonster (3/23/2010)

---

Changing the subject (if there is one), any art critics here?

Been fiddling with this on and off for a couple years now. Initial idea was just the light from...

Good to have you back Barry!

Nice high level of paranoia. Good job.

Lynn Pettis (3/22/2010)

---

GSquared (3/22/2010)

---

My main subjects of conversation so far today have been politics (Obamacare passed...

As far as the process goes, I think you have it right. The only suggestion I can make is to script the process. I'd open up PowerShell and put it...

You can do the same with SQL Server 2005.

You also have the option of provide plan guides. Here's an introduction on the topic from Microsoft.

That's a pretty big topic for a web post. You might want to try tracking down a few books. Here's some information to get you started from MSDN.

Maybe I misunderstood, but this sure looks to me like someone asking how to hack SQL Server. Am I way off?

amandix (3/22/2010)

---

Does anyone known a method of object tampering within SQL Server 2008?

The goal is to use an attached copy of mssqlsystemresource db and alter some system stored procedures, and...

It's good that you can use the DMV to satisfy your need, but you should be able to see it in Performance Monitor too. It can be a common problem...

Please don't cross-post. This just leads to confusion and bad information.

Do not reply.

Discussion already started here: http://www.sqlservercentral.com/Forums/Topic887267-373-1.aspx

Without knowing more about the structure and what exactly is performing badly, it's going to be very hard to suggest solutions. Is the performance bad on inserts or on reads?...

Steve Jones - Editor (3/22/2010)

---

I can't believe I left a perfectly good country behind 🙁

I made it, a definitely journey from hell. Last year (2009), I had an only slightly...

You betcha! I've got the sweatshirt at home. I used...