Viewing 15 posts - 21,016 through 21,030 (of 22,224 total)
Dave (2/27/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2008 at 9:46 am
The company I work for puts us through a variety of tests, either administered by HR or through classes with the managers. Unfortunately, I don't know them all. One...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2008 at 6:34 am
I truly love the concept of Connect. When I first got introduced to it, early on working with Data Dude, I was all over it, constantly searching for bugs, voting,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2008 at 5:19 am
OK. Well, have you tried using a JOIN to put the data from the three tables together?
I could simply write the query for you, but this looks a bit like...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2008 at 6:47 am
What have you tried so far?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2008 at 6:25 am
I've never done this with perfmon, so I'll leave that to the experts.
Profiler is silly simple. You can create a stored proc that does everything you need. You can even...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 9:30 am
Yeah, I've heard all those complaints. Then, we get a query that's running for 48 hours that somone finally brings over to us. We spend 3-4 hours on it and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 9:19 am
Steve nailed it. I said backup, but what I meant was escalation. That's how we handle it.
I also agree on getting a realistic time frame. It takes five minutes for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 8:50 am
Why is that we're always going to decide, on the flip of a coin, to swap out the database server so we need to not use any of the functionality...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 8:39 am
I suspect he's suggesting that the "we don't need no stinking procedures" school is going to drive your database to extinction, not the other way around.
We use generated code in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 8:10 am
It can't possibly be caused simply by the number of rows. Inserting one row or one million, neither one changes the schema of the table. That procedure you're calling has...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 6:54 am
You're trying to generate an estimated execution plan. You can't with the temp tables. Generate an actual execution plan instead, which means running the query, so make sure you're not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 6:52 am
The one thing I would absolutely demand is a backup. Make darn sure that you have a secondary oncall person. Otherwise, in theory, you can't go out & get groceries,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 6:50 am
Indianrock (2/21/2008)
If you want to ensure your performance (let alone your access), you need to specifiy the owner of objects within the database.
I'll have to dig for solid evidence...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 6:41 am
Indianrock (2/20/2008)
"no tables qualified by dbo. you're inviting a system-overhead in order to resolve the schema."Is this still the case in sql 2005?
Yep. It's actually worse because the introduction of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2008 at 6:04 am
Viewing 15 posts - 21,016 through 21,030 (of 22,224 total)