Might look at Glenn Berry's diag queries as well: http://www.sqlservercentral.com/blogs/glennberry/archive/2011/09/27/september-2011-sql-server-2008-instance-level-diagnostic-queries.aspx

With Profiler/trace you'll see all the activity, but that doesn't show you what changed. Without a trace from before, it's hard to know.

What I'd do is grab the statement...

I do see some MVPs posting about their work with Azure and asking questions about how things function and when changes are coming. Not sure what I can disclose about...

WayneS (9/27/2011)

---

Hey Threadizens... I received an email for what looks like an interesting permanent/full-time DBA position in the Phoenix area (I know some of you'll are from that area). PM...

On a completely unrelated, and sideways note, anyone seen Khan Academy? http://www.khanacademy.org/

Pretty cool. Watched a few basic algebra videos. Might be nice for kids, or even parents trying to help...

Evil Kraig F (9/27/2011)

---

Took a bit to read through the discussion and decide if I wanted to go near it with a ten foot pole.

I don't.

On a side note, looks...

Maybe everyone's reading The Thread and not posting. :w00t::-P

Might take awhile for the rest of the site to catch up to this page

I think if Gail could have, she might have dupped the dupes a few more times 😉

The article shows the sp_dropserver/sp_addserver, which is what you do on the SQL Server.

I took my son to game 3 when the Rockies went. Exciting game, exciting time, worth it for the memories, even though they lost

Stefan Krzywicki (9/27/2011)

---

No, I mean it is dangerous to assume anything and frequent checks are needed. When people are under pressure to improve performance by a certain set of metrics,...

I see it, I'll think about it. Bryant, if healthy, is my best receiver.

I need to do something. Frickin' Big Ben can't seem to get out of his way with...

It's not my decision. I've argued for years it should be moved to...

Rays, rays, rays, rays

Nothing I know of. Most companies I've worked on have had 2 or 3 schemes they used (often for dbs in full and simple), but there are times you have...