Viewing 15 posts - 17,161 through 17,175 (of 22,219 total)
akash.suryan (6/18/2009)
Thanks Grant.....I will love to see those questions please let me know.....
Already there, follow the link in the message.
"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
June 18, 2009 at 8:09 am
You sure can run it 24x7. You do need to be judicious in the number of counters you collect and the frequency of the collection becuase it is possible to...
"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
June 18, 2009 at 7:58 am
I haven't used either in a production environment yet. I've used both in tests.
"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
June 18, 2009 at 7:54 am
It can happen. The query engine and the query optimizer are different in 2008 than they were in 2000.
First, the obvious stuff, you have up to date statistics on...
"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
June 18, 2009 at 7:15 am
Simply studying questions is no way to prepare. We use a set of screening questions which are meant to weed people out. They're not the interview. The interview will involve...
"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
June 18, 2009 at 7:11 am
SQL Agent can be used to create the schedule. As posted above, you just need to run a script to start a trace. I recommend output to a file.
"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
June 18, 2009 at 7:07 am
You can join anything on anything through a TSQL statement. No requirements at all. You might get some... interesting... results, but there are no strict requirements.
However, if you're talking about...
"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
June 18, 2009 at 7:00 am
I wouldn't even call it apples & grapefruit. I'd say it's apples & chairs that you're comparing. Good luck sitting on the former or eating the latter. MVP can 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
June 18, 2009 at 6:58 am
Scotch... and beer. Or beer... and scotch.
Single malt (Highland or Orkney) followed by a good ESB... ah, makes life worth living.
"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
June 18, 2009 at 6:43 am
I just tried QA against 2008. It works. Nominally. I haven't run a full-on regression test or anything.
I'm sorry too. I thought you, the OP, were trying to find ways...
"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
June 18, 2009 at 6:34 am
OK? What's the problem and/or question?
You've got a cursor. It looks like it's doing updates.
It's hard to comment in any other way without knowing what you're trying to do...
"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
June 18, 2009 at 6:06 am
"free admission to the contest"
I'm pretty sure the contest is free.
No, I don't need to see the "best minds" speak. I sat through a session with someone that I really...
"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
June 18, 2009 at 6:02 am
First, don't run the profiler gui on your production systems. Instead use profiler to create a server-side trace (do a search on that phrase, it'll tell you everything you need...
"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
June 18, 2009 at 5:47 am
jason (6/17/2009)
thanks , i will give it a try...By the way,
How to optimize tempdb if i want to use Snapshot Isolation
There are several white papers on optimizing tempdb available...
"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
June 18, 2009 at 5:38 am
I don't understand what ISQLW does that SQLCMD does not?
From the sounds of it, you really might benefit from Powershell.
"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
June 18, 2009 at 5:31 am
Viewing 15 posts - 17,161 through 17,175 (of 22,219 total)