Viewing 15 posts - 13,246 through 13,260 (of 22,219 total)
Hash match operators build a hash table, that can result in writes to tempdb. I also see a sort operation, again, writes to the tempdb. That's probably where that stuff...
"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 15, 2011 at 6:52 am
This is a question best asked to Microsoft, not here. No one I know of who posts here regularly is an MS employee, let alone someone in their sales division...
"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 15, 2011 at 6:49 am
You're absolutely on the road to being a dba. Don't worry. It doesn't hurt and you frequently make a little more money than developers. You just won't have as many...
"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 15, 2011 at 6:47 am
For a single table, export it is the answer. I work for a company that makes three different tools, all focused around backup and restore, and we don't backup single...
"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 15, 2011 at 6:29 am
I wrote this article on log backups just so I could use it in situations like this. Go here and read this[/url]. Hopefully it will help.
"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 15, 2011 at 5:44 am
Kiara (2/15/2011)
# If the database supports a transaction processing system, then avoid using indexes because the
# performance of the insertion of new transactions will be degraded.
I disagree with this statement....
"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 15, 2011 at 5:42 am
Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT
statements.
But not in JOIN criteria? No, no way. The basic rule 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 15, 2011 at 5:39 am
sqldba_icon (2/14/2011)
Grant Fritchey (2/14/2011)
As far as b)...
"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 14, 2011 at 3:25 pm
I'm not that familiar with it. Sorry. It really isn't used much.
"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 14, 2011 at 3:23 pm
From a performance standpoint, if you're moving more data, it's slower by that amount, but we're talking trivia most of the time. I just try to find out what the...
"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 14, 2011 at 1:47 pm
Anna_SQL (2/14/2011)
I downloaded an enterprise version of sql 2008 and I will install it on a testing machine.
This machine will be...
"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 14, 2011 at 1:42 pm
For a) you want to take a look at the default trace. That's how you can tell who made structural changes to the system.
As far as b) goes, if the...
"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 14, 2011 at 1:40 pm
Brandie Tarvin (2/14/2011)
Grant Fritchey (2/14/2011)
Roy Ernest (2/14/2011)
GilaMonster (2/14/2011)
Craig Farrell (2/14/2011)
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away 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 14, 2011 at 12:48 pm
mw112009 (2/14/2011)
After about 2 hours the result was the same. When I logged in I did not see SSMS running.Why did it shut down on it's own ?
That, I don't...
"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 14, 2011 at 12:27 pm
Crud. I mean restore. Sorry.
"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 14, 2011 at 12:06 pm
Viewing 15 posts - 13,246 through 13,260 (of 22,219 total)