Viewing 15 posts - 17,116 through 17,130 (of 22,209 total)
Alexander Kuznetsov (6/24/2009)
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...
June 24, 2009 at 12:39 pm
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
June 24, 2009 at 6:59 am
Florian Reischl (6/24/2009)
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...
June 24, 2009 at 6:57 am
ALZDBA (6/24/2009)
( 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...
June 24, 2009 at 6:56 am
Paul White (6/24/2009)
Maybe we read the original post differently, but:
DBA (6/9/2009)
Hi, i have many complains of having lock escalations in my DB
Notice the word 'complains' not 'complaints' - I...
June 24, 2009 at 5:40 am
RBarryYoung (6/23/2009)
David Burrows (6/23/2009)
Doc (6/23/2009)
RBarryYoung (6/23/2009)
Impressive Bio Mr. Young
Nice pic too! 😉
They wouldn't let me use that one I wanted too, though. I have attached it here...
June 23, 2009 at 1:23 pm
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...
June 23, 2009 at 12:14 pm
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...
June 23, 2009 at 12:01 pm
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...
June 23, 2009 at 11:51 am
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...
June 23, 2009 at 6:52 am
Oh, lordy. That's too much like work. After about the third SELECT DISTINCT, I lost interest. Sorry.
June 22, 2009 at 10:06 am
There are always exceptions, but in general, you're better off using the LEFT JOIN. When in doubt, write the query both ways and look at the execution plans.
June 22, 2009 at 7:37 am
You can. I don't have a link for you. It's just:
EXEC @param1=42
June 22, 2009 at 7:35 am
I just want to echo what everyone else has said. Without at least an execution plan, it's just not possible to say what's going on.
I can suggest that you try...
June 22, 2009 at 7:16 am
I was really nervous opening this up, expecting to get 34,000 lines. There are only 14. Had me going for a minute there.
Anyway, 34,000 is more than a little extreme....
June 19, 2009 at 11:36 am
Viewing 15 posts - 17,116 through 17,130 (of 22,209 total)