Viewing 15 posts - 20,416 through 20,430 (of 22,219 total)
Best of luck on speaking Gail. I've submitted two abstracts this year as well.
"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
May 14, 2008 at 6:40 am
Outstanding.
Not only does it remind me of WAY too many of the projects I've worked on, it also reminds me of WAY too many trips with the kids.
"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
May 14, 2008 at 6:26 am
Speaking as a PASS volunteer who will (hopefully) get comped on admission, I'd be willing to both pay a fee AND forego prizes in favor of those who registered through...
"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
May 14, 2008 at 6:15 am
Are the columns individually overridden? If so and you're planning on storing a sparsely populated table, I sure hope you don't have do searches on the data. Without the filtered...
"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
May 14, 2008 at 5:40 am
It sounds like you may be on the right track. Just remember that Profiler is only going to show you what happened, not what could happen.
"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
May 14, 2008 at 5:34 am
You could use Profiler to capture the actual execution time.
"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
May 13, 2008 at 6:39 am
There's no way to know in advance how long a query will take. You can look at an execution plan for the estimated cost, but because of I/O contention, CPU,...
"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
May 13, 2008 at 6:12 am
Welcome to the forums. Keep your hands and feet inside the vehicle at all times.
Performance wise, you have to reference two tables right now. Plus the fact that you can...
"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
May 13, 2008 at 5:50 am
Yeah, OSQL will work fine. It's still back to what I said. Open a new connection, either by spawning a thread or using another executable, one you built or 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
May 13, 2008 at 5:40 am
I'm not adverse to using it, but I've only seen string parsing or complex math solutions that were clearly more viable with the CLR than with TSQL code. Get me...
"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
May 13, 2008 at 5:38 am
I still think it all comes down to a business verification. I can't tell you how many times I've gotten the word to restore the backup for a certain date....
"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
May 12, 2008 at 7:57 am
You should have Profiler. You can capture that.
You can also run Perfmon to capture the counters over time. Output them to a file and then you can use those with...
"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
May 12, 2008 at 7:54 am
There's always the documentation:
http://msdn2.microsoft.com/en-us/library/ms130214.aspx
"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
May 12, 2008 at 6:44 am
It's called SQL Server Agent and it runs as a seperate service on all server installs (it's not in Express or Compact).
"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
May 12, 2008 at 6:42 am
Do these transactions include lots of data changes? You might be getting recompiles on your procedures. You'll need to follow Gail's advice and get the wait stats.
"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
May 12, 2008 at 6:41 am
Viewing 15 posts - 20,416 through 20,430 (of 22,219 total)