Viewing 15 posts - 5,806 through 5,820 (of 22,226 total)
BSharbo (8/3/2015)
However in this instance there is only the one table.
I still probably wouldn't make...
"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
August 3, 2015 at 11:02 am
Jeff Moden (8/3/2015)
ben.brugman (8/3/2015)
Grant Fritchey (8/3/2015)
Don't get hung too much on PLE.
Thanks for you reply.
I do tend to get hung up to much by 'numbers' in general, and like 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
August 3, 2015 at 8:13 am
I've run into the same type of thing over and over (especially, for some reason NOLOCK, it becomes a magical talisman somehow). There are no easy solutions once people get...
"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
August 3, 2015 at 7:19 am
A single one-off shrink of the database just is not a big deal. What happens is that people hit issues with disk, transactions, etc., and they set up automated shrinks...
"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
August 3, 2015 at 5:24 am
It's just based on how long the pages have stayed in memory. So from one minute to the next, a page has stayed in memory, at least 60 seconds, so...
"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
August 3, 2015 at 5:22 am
Whether or not the primary key for the table should be clustered really is down to experimentation and testing. I'm with Tom that, at least from the description provided, you're...
"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
August 3, 2015 at 5:15 am
MJ-1115929 (8/1/2015)
Thanks Grant and hope you are doing well, we had chats several times some time back.
I have one query if we want to force the sql server 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
August 2, 2015 at 5:02 am
The differences between the servers could be the amount of memory on the servers, the number and speed of the CPU, or just the load because resource contention on any...
"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
July 31, 2015 at 5:01 am
Partitioning very rarely helps performance within an OLTP situation. However, if you are looking at a situation where you're rolling off old data, partitioning becomes a pretty viable approach, 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
July 31, 2015 at 4:58 am
Ah, it wasn't clear in the first post this is all dynamic SQL.
Try wrapping this in a transaction
exec sp_executesql @s
"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
July 31, 2015 at 4:11 am
Brandie Tarvin (7/30/2015)
SQLRNNR (7/30/2015)
Brandie Tarvin (7/30/2015)
And on another subject...I HAVE GUMMY BEARS! (fear me)
That can be taken multiple ways.
Let's guess that means this instead of the surgical process.
https://www.youtube.com/watch?v=mLpNGp-IFIk
edit: better link
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
July 30, 2015 at 12:28 pm
TheSQLGuru (7/30/2015)
4) A minor correction to what Grant said: the leading percent won't prevent index use. It will just prevent index SEEKs.
Very true and worth noting.
A pretty hefty percentage 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
July 30, 2015 at 12:27 pm
Pretty much the same stuff you'd capture if you were monitoring production servers. You want all the wait statistics. You want to see the queues, if any. You definitely should...
"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
July 30, 2015 at 10:01 am
The DISTINCT operation is going perform aggregation. You really shouldn't need it if your data structures are correct. That's a pretty big performance hit right there.
"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
July 30, 2015 at 9:58 am
SQLRNNR (7/30/2015)
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/2015)
"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
July 30, 2015 at 8:51 am
Viewing 15 posts - 5,806 through 5,820 (of 22,226 total)