Viewing 15 posts - 3,976 through 3,990 (of 22,224 total)
I'm horrified to know the answer, but it's not the book by Jason Strate and me is it?
If so, I'd love to know, what makes the chapter 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
March 28, 2017 at 3:10 am
"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
March 28, 2017 at 3:00 am
"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
March 24, 2017 at 3:22 pm
Sorry, I don't know Sybase.
This forum is for Microsoft SQL Server. You might be better off tracking down a forum for Sybase.
"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
March 23, 2017 at 11:39 am
"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
March 23, 2017 at 11:35 am
Nuts. Sorry Chris. I didn't realize that wasn't the OP reporting a different problem. My apologies.
"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
March 23, 2017 at 11:26 am
You need to do what Chris is suggesting, get the execution plan. We can speculate all day why one query runs faster than another (although DISTINCT is an aggregation function...
"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
March 23, 2017 at 9:07 am
I'm prejudiced because I work for Redgate, but I think SQL Doc is exactly what you're looking for.
However, Jeff nailed it as usual. To have 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
March 23, 2017 at 9:01 am
Deadlocks are best investigated in a 2012 or greater server through the system_health extended event session which is actively running on all your servers by default. Here's an "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 23, 2017 at 8:46 am
No, there are no nobs or ways to adjust the behavior of the native intellisense. You can basically turn it on & off and that's about it. However, double check....
"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
March 23, 2017 at 5:46 am
If you want to monitor your queries for performance metrics and you really care about individual calls to those queries, not simply an aggregate average of calls, then the best...
"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
March 22, 2017 at 3:59 pm
dangelo211 - Wednesday, March 22, 2017 1:01 PMWe have no SQL monitoring tools. This is a small shop
Redgate SQL Monitor is absolutely...
"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
March 22, 2017 at 3:52 pm
If the data is changing though, statistics that are a year old is concerning. I agree with the approach the Chris has to see what has been modified. However, assuming...
"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
March 22, 2017 at 3:51 pm
In general, I'd say this is a serious problem with the data or the structure, but, you could treat it like versioned data and simply follow one of the approaches...
"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
March 22, 2017 at 3:48 pm
I could be very wrong, but are you thinking of SQL Prompt from Redgate?
"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
March 22, 2017 at 5:55 am
Viewing 15 posts - 3,976 through 3,990 (of 22,224 total)