Viewing 15 posts - 4,846 through 4,860 (of 22,219 total)
I get in to London Thursday morning. I think the train is only 3 hours or so, so I should be to Liverpool by Thursday afternoon.
I'm presenting on Friday, early...
"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
April 12, 2016 at 12:13 pm
Ray K (3/30/2016)
Groupthink is a phenomenon that is highly destructive -- and all too common in group...
"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
April 12, 2016 at 10:42 am
Doug.F (4/12/2016)
"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
April 12, 2016 at 8:04 am
Ron007 (4/11/2016)
and use the query hint for index.... that using in prod.
the same index will use in dev if you put as shown...
"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
April 12, 2016 at 6:42 am
Both plans are timing out. That means that, depending on the CPU cycles and estimates from the statistics, you could see different plans on different days on either environment. 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
April 12, 2016 at 6:40 am
Doug.F (4/11/2016)
UPDATE STATISTICS dbo.TableName WITH FULLSCAN
On all tables that are being joined with the SQL query, unfortunately this...
"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
April 12, 2016 at 6:19 am
The real problem is, you can't really prevent corruption. You could just have a bit of solar radiation hit the disk at just the right angle flipping a 1 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
April 12, 2016 at 6:14 am
SQL Server will use every bit of memory you assign to it. It'll store data in cache and keep it there as long as it can in order to avoid...
"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
April 12, 2016 at 6:10 am
Least cost to do this is extended events. However, since you're in 2008, there is no GUI for consuming the results (or setting things up). You'll need to query XML...
"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
April 12, 2016 at 6:08 am
gdrummer83 (4/11/2016)
"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
April 11, 2016 at 5:45 pm
Sean Lange (4/11/2016)
skb 44459 (4/11/2016)
Can you post execution plans?
- Execution plan says. Query Cost 'Relative to batch) : 50%
Stating the relative cost of the batch when compared to the...
"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
April 11, 2016 at 11:16 am
Modify the database. Anything else you do is going to be bandaid that creates technical debt. Technical debt, like any kind of debt, adds up and will disable you eventually....
"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
April 11, 2016 at 11:14 am
Also no experience with Asigra backup.
However, I can tell you one thing about ANY third party backup, make them do a restore. Make them do a point in time restore....
"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
April 11, 2016 at 6:50 am
It depends on what we're talking about. If we're talking features that are now on the deprecation list, they just haven't been removed yet. If we're talking features that 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
April 11, 2016 at 6:46 am
BL0B_EATER (4/8/2016)
"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
April 8, 2016 at 11:24 am
Viewing 15 posts - 4,846 through 4,860 (of 22,219 total)