Viewing 15 posts - 5,731 through 5,745 (of 22,219 total)
GilaMonster (8/11/2015)
Grant Fritchey (8/11/2015)
Just saw the news. Congrats Gail.
It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted...
"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
August 11, 2015 at 6:57 am
Just saw the news. Congrats Gail.
"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
August 11, 2015 at 6:49 am
Eirikur Eiriksson (8/11/2015)
0xC34F0xC350 Missed it:pinch::-D😎
... by that much.
"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
August 11, 2015 at 6:48 am
GilaMonster (8/11/2015)
Grant would love this query. Views within views within views with a CTE and a temp table for good measure. Parse time is around 45 seconds.
Oooh, 45 seconds 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
August 11, 2015 at 6:47 am
We've reached page 5000 on the standard layout, so only a couple of more to cross the 50,000 post line. Is anyone going to just post them all to make...
"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
August 11, 2015 at 6:34 am
Instead of MAX here, you might try TOP(1)
SELECT
@DateEnd = MAX(MeasureDate)
FROM...
"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
August 11, 2015 at 5:37 am
Oops. Editing this because it was the answer to a different question.
"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
August 11, 2015 at 5:36 am
mohan_padekal (8/11/2015)
First i updated Statistics of DataMaster table then try to execute the script that time getting error
Updating statistics won't change the names of columns. 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
August 11, 2015 at 3:34 am
I'm with @chrism-2. Let's see the execution plans so we can understand what each server is doing to resolve these queries.
How are your statistics being maintained on each server?
"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
August 11, 2015 at 3:18 am
To read the entire table... probably not. Getting rid of the FOR XML will be faster. Other than that, faster and more disks, faster and more controllers. Since you're reading...
"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
August 10, 2015 at 3:41 pm
Yeah, don't spend your money getting certified when you don't have any experience to back it up. Certification is highly unlikely to get you a job. You'd be better off...
"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
August 10, 2015 at 11:25 am
sgmunson (8/10/2015)
Grant Fritchey (8/10/2015)
"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
August 10, 2015 at 9:01 am
A lot of the functionality that was introduced in 2012, Availability Groups, ColumnStore indexes, others, are much improved in 2014. Also, the 2014 cardinality estimator is completely new and improved,...
"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
August 10, 2015 at 8:58 am
SQL Server 2016 is not actually released yet, so I wouldn't recommend it for a production environment (legally, unless you're part of Microsoft's TAP, you can't). However, SQL Server 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
August 10, 2015 at 8:46 am
Might be a good idea to put an index on your temporary table and ensure that the statistics are up to date. This query is the most costly:
SELECT TOP 1
...
"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
August 10, 2015 at 8:44 am
Viewing 15 posts - 5,731 through 5,745 (of 22,219 total)