Viewing 15 posts - 4,756 through 4,770 (of 22,227 total)
Mark Cowne (5/9/2016)
Really enjoyable few days, lots of excellent presentations, Itzik Ben-Gans was simply brilliant. Also got a chance to briefly meet Grant and Steve.
And it was a pleasure.
Loved Bits....
"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
May 10, 2016 at 12:07 pm
It was great to see Threadizens last week at SQL Bits. Awesome event.
And I had something I was supposed to say about Gianluca... just can't remember what it was... (keep...
"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
May 10, 2016 at 4:17 am
Brandie Tarvin (5/9/2016)
Ed Wagner (5/9/2016)
Phil Parkin (5/9/2016)
Eirikur Eiriksson (5/9/2016)
Who needs a desk when one can bang ones head against this?😎
Occam's razor clearly does not apply in this case. Instead, perhaps,...
"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
May 10, 2016 at 4:14 am
Chad Crawford (5/2/2016)
TomThomson (4/30/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
May 3, 2016 at 4:18 am
Jeff Moden (4/30/2016)
Grant Fritchey (4/28/2016)
I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able...
"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
May 1, 2016 at 12:28 pm
ajdba33 (4/30/2016)
Also, has anybody used SQ Sentry PowerSuite tool ? I would like to compare few...
"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
May 1, 2016 at 12:20 pm
harikumar.mindi (4/30/2016)
EXEC sp_MSForEachTable 'UPDATE STATISTICS ? WITH FULLSCAN;'However i will rebuild / reorganize indexes and test it again and will update here.
Just so you know, rebuilding/reorganizing indexes will not...
"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
May 1, 2016 at 12:18 pm
You're kind of all over the map here, but I'll be happy to make some suggestions.
First off, get the SQL Toolbelt from Redgate[/url]. It has a number of tools that...
"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 30, 2016 at 7:29 am
There are a few clues around this. If you look at the properties of the SELECT operator, there are differences in the apparent setup of the servers. One has 12...
"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 30, 2016 at 7:22 am
Luis Cazares (4/29/2016)
Brandie Tarvin (4/29/2016)
Grant Fritchey (4/29/2016)
Brandie Tarvin (4/29/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 29, 2016 at 3:43 pm
Brandie Tarvin (4/29/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 29, 2016 at 11:50 am
fred.newcomer (4/29/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 29, 2016 at 11:48 am
jasona.work (4/29/2016)
Grant Fritchey (4/29/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 29, 2016 at 11:19 am
Sioban Krzywicki (4/29/2016)
John Mitchell-245523 (4/29/2016)
Sergiy (4/28/2016)
The names don't affect performance or quality of the code anyway.
It's not 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
April 29, 2016 at 10:46 am
N_Muller (4/29/2016)
Grant Fritchey (4/29/2016)
N_Muller (4/28/2016)
Or is it a hit and miss in terms of queries that perform poorly.
I'll just pile on and agree.
The main issues I've seen are with multi-statement,...
"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 29, 2016 at 10:44 am
Viewing 15 posts - 4,756 through 4,770 (of 22,227 total)