Viewing 15 posts - 4,846 through 4,860 (of 22,221 total)
Hugo Kornelis (4/12/2016)
... - which would be rude when done by anoyone other than me. 😉
There go my plans.
"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 13, 2016 at 5:52 am
Eirikur Eiriksson (4/12/2016)
Will miss the breakfast but will be in time for your talk, Query Store at 11:00?😎
Is that when it is? Cool. I can sleep in a little. HA!
"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 13, 2016 at 5:51 am
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
Viewing 15 posts - 4,846 through 4,860 (of 22,221 total)