Viewing 15 posts - 3,481 through 3,495 (of 22,224 total)
"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
December 1, 2017 at 8:56 am
"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
December 1, 2017 at 8:49 am
I have seen the execution plan, that query is in serious need of...
"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
December 1, 2017 at 8:01 am
"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
December 1, 2017 at 7:11 am
I am surprised, shocked, horrified, dismayed, thunderstruck, flabbergasted and down right gobsmacked to find out that adding one clustered index on one table did NOTHING to improve a 25 page...
"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
December 1, 2017 at 6:29 am
"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
December 1, 2017 at 6:18 am
No. According to the documentation, that won't work with Azure SQL Data Warehouse. It also doesn't work with APS.
"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
December 1, 2017 at 4:29 am
"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
November 30, 2017 at 2:03 pm
You definitely sound like a good candidate for the in-memory tables. To get started, go here. Pay the most attention to the restrictions. It's a huge performance boost...
"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
November 30, 2017 at 2:01 pm
Without seeing the setup and size and nature, my answers are going to be pretty generic.
Yes, more files on more disks can generally mean better I/O. Just 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
November 30, 2017 at 5:30 am
"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
November 29, 2017 at 12:25 pm
Right here. Instant table/clustered index scans. No seeks. No performance tuning possible other than buying faster disks and more memory:
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:[CoverageLengthMonthNumber]
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2017 at 11:56 am
Oops. I was so focused on finding the ARM template that I missed that part.
There is a very good document out there on it. I'll have to look...
"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
November 29, 2017 at 11:25 am
"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
November 29, 2017 at 6:44 am
"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
November 29, 2017 at 6:42 am
Viewing 15 posts - 3,481 through 3,495 (of 22,224 total)