Viewing 15 posts - 7,051 through 7,065 (of 22,221 total)
Check the error log. You can see when backups were fired off there. I think, but would have to look it up to be sure, it's also in the system_health...
"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
December 17, 2014 at 8:29 am
Jason-299789 (12/17/2014)
PiMané (12/17/2014)
Cause the pk when it's created will already point to the cidx and wont need rebuild/recalculate. Less work on the io system and cpu.
I thought all the NC...
"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
December 17, 2014 at 8:27 am
You can get the estimated execution plan without ever running the query at all. That's the place to start.
"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
December 17, 2014 at 7:21 am
WayneS (12/17/2014)
Jeff Moden (12/17/2014)
Koen Verbeeck (12/17/2014)
Brandie Tarvin (12/17/2014)
Brandie Tarvin (12/16/2014)
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time 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
December 17, 2014 at 7:19 am
Not seeing the execution plan it's hard to make suggestions as to where exactly it's running slow. Are you sure you have indexes in place that support the query 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
December 17, 2014 at 7:00 am
Instead of MIN why not try a TOP 1 with an ORDER BY to get the dates in the correct order. You should even be able to have an index...
"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
December 17, 2014 at 4:19 am
PiMané (12/17/2014)
Jason-299789 (12/17/2014)
having done something similar, it was 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
December 17, 2014 at 4:14 am
Brandie Tarvin (12/16/2014)
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.
Current execution...
"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
December 16, 2014 at 3:31 pm
don't forget, it's not just monitoring. There are backup products, deployment, source control, compare, all sorts of tools. Be sure you explore the full offering and, again, understand what it...
"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
December 16, 2014 at 3:25 pm
There is some crossover between products across those companies, but also you should note that each company also offers some unique tools not offered by the others. Be sure what...
"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
December 16, 2014 at 12:02 pm
Excellent point. Not something I tend to think of since I try so hard to avoid hints.
"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
December 16, 2014 at 11:44 am
jvila (12/16/2014)
[font="Courier New"]
Name |Writes | Reads | Columns | IncludedColumns
-------------------------------------------------------------------------------
INDEX A| 15.112|2.117| BB,AA with included columns CC,EE
INDEX 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
December 16, 2014 at 9:12 am
New Born DBA (12/16/2014)
Grant Fritchey (12/10/2014)
"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
December 16, 2014 at 9:02 am
Jeff Moden (12/16/2014)
"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
December 16, 2014 at 8:24 am
Yeah, a big part of why it's so important to pick the correct location for the clustered index is because it's so difficult later to rebuild them, especially if they'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
December 16, 2014 at 8:23 am
Viewing 15 posts - 7,051 through 7,065 (of 22,221 total)