Forum Replies Created
Viewing 15 posts - 17,131 through 17,145 (of 22,226 total)
-
RE: scripts for monitoring longrunningjobs in sqlserver2000.
Can I ask what types of scripts you're looking for? Do you mean scripts to monitor blocking?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Memory Bottleneck
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Deploying Databases From Visual Studio Team System Database Edition
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Deploying Databases From Visual Studio Team System Database Edition
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
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Deploying Databases From Visual Studio Team System Database Edition
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Deploying Databases From Visual Studio Team System Database Edition
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Lock Escalation
Paul White (6/24/2009)
Hey Ed,Maybe we read the original post differently, but:
DBA (6/9/2009)
Hi, i have many complains of having lock escalations in my DBNotice the word 'complains' not 'complaints' - I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL training
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: HIGH I/O issue
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: sys.dm_exec_requests vs sys.dm_tran_active_transactions
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Oh, lordy. That's too much like work. After about the third SELECT DISTINCT, I lost interest. Sorry.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Sub-Query or Left-Outer Join (Performance Wise)
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Jobs in SQL Management Studio
You can. I don't have a link for you. It's just:
EXEC @param1=42"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 17,131 through 17,145 (of 22,226 total)