Viewing 15 posts - 4,036 through 4,050 (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
February 24, 2017 at 9:04 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
February 24, 2017 at 6:43 am
Archiving means moving from one location to another for long term storage (possibly aggregation, possibly other stuff, that really depends on your business needs, I can't define this for you)....
"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
February 24, 2017 at 6:04 am
If you need to do this regularly, building out scripts, a Powershell app, or even SQL Server Integration Services (SSIS), would be the best way to get it done. Using...
"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
February 24, 2017 at 6:01 am
Azure SQL Database has a DMV sys.dm_db_wait_stats, which is absolutely wonderful. It will show you wait stats per database. However, the boxed product doesn't have that DMV. The one way...
"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
February 24, 2017 at 5:59 am
A couple of things you can do to enhance performance on the data load. You can break up the files into 60 chunks to coincide with the 60 processes 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
February 24, 2017 at 5:57 am
That said, is there ever any case or reason why one...
"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
February 24, 2017 at 5:47 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
February 23, 2017 at 12:04 pm
John has it nailed. If you put in a RECOMPILE hint, nothing gets cached because there's no need since each execution gets a new compilation.
Why would Optimize for...
"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
February 23, 2017 at 11:34 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
February 23, 2017 at 8:34 am
You're going to want the RECOMPILE hint to be after the WHERE clause as defined in the documentation.
sp_executesql will attempt to reuse execution plans. Most 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
February 23, 2017 at 8:02 am
Nice to hear that people like the product.
DISCLOSURE: I work for Redgate.
My favorite stuff is the compression. It's way better than native. Also our automation around...
"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
February 23, 2017 at 7:31 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
February 23, 2017 at 7:07 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
February 23, 2017 at 6:57 am
I've seen a lot of tickets with MS opened for Sharepoint. I think nearly...
"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
February 23, 2017 at 6:55 am
Viewing 15 posts - 4,036 through 4,050 (of 22,224 total)