Viewing 15 posts - 11,701 through 11,715 (of 22,224 total)
Ian Massi (10/20/2011)
"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
October 20, 2011 at 7:37 am
Phil Parkin (10/20/2011)
Grant Fritchey (10/20/2011)
"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
October 20, 2011 at 5:57 am
derek.colley (10/20/2011)
I think he means 'login' rather than 'log in'
Entirely possible.
Here's the appropriate entry from the BOL
"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
October 20, 2011 at 5:57 am
Ninja's_RGR'us (10/20/2011)
HTH, all I did use use the script and like it. Michelle actually wrote it! 😉
ditto
"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
October 20, 2011 at 5:55 am
Do they all have the same query_plan_hash value?
Sounds like you might be a candidate for Optimize for Ad Hoc workloads, but it's hard to be sure.
"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
October 20, 2011 at 5:42 am
Do you mean every single action taken by the users for a week? You'll need to capture all events. I'd suggest looking up how to use extended events for that,...
"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
October 20, 2011 at 5:40 am
Just search Michelle's site a bit. You'll find this[/url].
"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
October 20, 2011 at 5:34 am
I've only seen one execution plan posted. It had a table scan, which means no cluster, and was predicated as follows:
[SFDReports].[Sales].[HOWLI_LOAD].[SQL_POST_DATE]>=N'2011-10-15 00:00:00.000' AND [SFDReports].[Sales].[HOWLI_LOAD].[SQL_POST_DATE]<=N'2011-10-19 00:00:00.000'
Based on what I'm seeing here,...
"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
October 20, 2011 at 5:32 am
You also have to take into account what happens with the transaction log. When you delete 1000 rows, they're recorded in the log that way, increasing the amount of information...
"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
October 20, 2011 at 5:24 am
Hyperbac is a file filter. It doesn't interfere in any way with the operation of SQL Server. Instead it gets between SQL Server and the file system and runs interference...
"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
October 20, 2011 at 5:21 am
What about building a drug name mapping table. You run through the data once, nightly, after a load, something, and map the names supplied to the drugs available into a...
"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
October 20, 2011 at 5:17 am
When you create a database you are required to create a transaction log as part of creating the database, so I don't think you're talking about that. The SQL Server...
"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
October 20, 2011 at 5:08 am
Sorry, I was slow getting back here. Gail's answering everything. Just out of curiosity, what is the cost threshold for parallelism on your server?
"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
October 19, 2011 at 12:11 pm
bkubicek (10/19/2011)
Grant Fritchey (10/19/2011)
If you’re a finalist we will need to confirm...
"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
October 19, 2011 at 7:07 am
By the way, DBA is just a term, we're talking data professionals concerned with databases. From the rules:
If you’re a finalist we will need to confirm that you work...
"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
October 19, 2011 at 6:37 am
Viewing 15 posts - 11,701 through 11,715 (of 22,224 total)