Gianluca Sartori (6/25/2009)

---

Maybe I could, but the main problem is that it's always raining... The grass grew almost to my knees...

I don't' remember such a rainy and (relatively) cold summer...

Paul White (6/24/2009)

---

The SQL Server Algebrizer (which replaces the 'Normalizer' in 2000) does a fair amount of this work, including helping to decide on parallelism, how to approach sub-queries and...

Alexander Kuznetsov (6/24/2009)

---

I guess I know how and why configuration works, but IMO it is completely irrelevant so it shouldn't be there at all. Why do I need to waste...

Can I ask what types of scripts you're looking for? Do you mean scripts to monitor blocking?

You need to look at the queues and wait states counters. That will tell you what is slowing down. From there you can determine what's causing it.

Alexander Kuznetsov (6/24/2009)

---

Grant,

What do I need Active solution configuration and Active solution platform for?

This is a database project, not a C# one, so why am I exposed to and maybe...

In addition to Gert's blog, Barclay Hill is posting on best practices with VSTS:DBE. It's worth a read. http://blogs.msdn.com/bahill/default.aspx

Florian Reischl (6/24/2009)

---

Nice article Grant.

I'm still not the best friend of SQL integration in Visual Studio but I think the new database projects become better and better and it seems...

ALZDBA (6/24/2009)

---

- Be sure to add GDR R2 to your vstedba (datadude) because it adds some nice db-features.

( http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed )

FYI: The Datadude's lair: http://blogs.msdn.com/gertd/default.aspx 😉

I'm not yet a user, but...

Paul White (6/24/2009)

---

Hey Ed,

Maybe we read the original post differently, but:

Notice the word 'complains' not 'complaints' - I...

RBarryYoung (6/23/2009)

---

They wouldn't let me use that one I wanted too, though. I have attached it here...

Training trends... Not sure. I'd be interested to see what others say about this. As to where to get training, I can make a couple of very good suggestions. In...

Thoses correlated sub-queries inside the case statements are probably leading to Loop Join operations across the three million rows worth of data. Generally, but not always, you're better off dealing...

Requests & Transactions are different.

A request has a SessionId. This can be used to get to the sys.dm_tran_session_transactions dmv. This then links to sys.dm_tran_active_transactions through the transactionid.

So, yeah, a request...

Hey, Buck Woody just posted a "Help Me, Help You" post that some of our more infamous posters, and quite a few others, could use. Thought you all might be...