Viewing 15 posts - 7,306 through 7,320 (of 22,226 total)
Luis Cazares (10/28/2014)
Grant Fritchey (10/28/2014)
jeffgonzalez007 (10/28/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
October 28, 2014 at 11:11 am
jeffgonzalez007 (10/28/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
October 28, 2014 at 10:49 am
Koen Verbeeck (10/28/2014)
Grant Fritchey (10/28/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
October 28, 2014 at 8:57 am
It's the last ID generated for any session in any scope. So another session may have experienced a rollback or something else that caused it to generate an identity value...
"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 28, 2014 at 8:41 am
The fundamentals are the same from 2005 through 2014, so on lots of levels, it doesn't matter which you study. However, your knowledge will have a longer shelf-life if you...
"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 28, 2014 at 8:38 am
While it certainly could be AG, and that's really the only evidence we have, I'd suggest capturing a bunch of metrics in order to understand where the problem lies rather...
"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 28, 2014 at 7:41 am
I'd suggest looking at the system to see what it's waiting on. You can query the dynamic management views to pull information out. This book (free download) shows a number...
"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 28, 2014 at 7:38 am
You need to identify the blocking chain, which process is causing it to stop. Or, you need to identify the resource that it's waiting on in order to understand which...
"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 28, 2014 at 7:37 am
On most databases, most of the time, if you have automatic statistics maintenance enabled and you have auto-create statistics enabled, you're getting the statistics you need and probably don't have...
"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 28, 2014 at 7:31 am
That's really best done on the client, but the LEFT string function will 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 27, 2014 at 11:30 am
Agree with Gail.
Look to the default ANSI settings on both servers, max degree of parallelism and the cost threshold for parallelism. Deviations in these settings can lead to differences 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
October 27, 2014 at 7:07 am
vincyf1 (10/23/2014)
jamessdba (10/22/2014)
Hi please clarify .Please explain
what is the difference between database refresh (when we go for refresh)& Restore
Please clarify
Database Restore - When a DB Backup is...
"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 23, 2014 at 7:00 am
yeah, it doesn't do regular expressions. Wild cards, AND/OR and NOT are supported though.
"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 23, 2014 at 5:41 am
You could try SQL Search[/url] from Red Gate. It's a free tool that should find those references pretty easily.
Mandatory disclaimer (although I'm not sure why for a free tool): I...
"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 23, 2014 at 4:12 am
Glad you solved it and thanks or posting the follow up. It's always good to know what the problem really was and the solution.
"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 23, 2014 at 1:18 am
Viewing 15 posts - 7,306 through 7,320 (of 22,226 total)