Viewing 15 posts - 4,501 through 4,515 (of 22,224 total)
Generally, prepared statements are roughly the same as stored procedures, so they're handled very well indeed. The optimizer can create an execution plan that is reusable across multiple iterations 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
August 25, 2016 at 3:36 am
Yeah, it should. Just use the published trace that's in the documentation.
"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 25, 2016 at 3:33 am
TheSQLGuru (8/24/2016)
I don't think it is still "required" but it used to be that upgrading versions mandated full-scan statistics updates on all statistics in every database migrated.
Not at all required,...
"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 24, 2016 at 11:54 am
Most of the time, the queries that are suffering because of the new cardinality estimator have other issues that can be addressed (or the architecture is off). Frequently the best...
"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 24, 2016 at 10:51 am
Most of SSIS and SSRS management is through Visual Studio, not SSMS. And yeah, you'll probably have to upgrade to the latest database tools for those. SSMS can connect 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
August 24, 2016 at 10:45 am
When I've automated restore processes, I've usually had access to msdb to retrieve the data directly. It sure makes things easier. Plus, we usually had standard drive configurations & folders,...
"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 24, 2016 at 7:57 am
navtec (8/24/2016)
I'm using sql 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 24, 2016 at 7:37 am
It will do the business validations, absolutely. You just have to write the tests. There's not a tool out there that knows your business well enough to automatically generate tests...
"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 24, 2016 at 7:36 am
Jeff Moden (8/23/2016)
Grant Fritchey (8/16/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
August 24, 2016 at 6:43 am
durga.palepu (8/24/2016)
Hi all,Can somebody explain if there are any tools available to unit test the functional test cases in database?
Thanks,
Durga Prasad.
Yes. See my post above. T-SQLT and SQL Test [/url]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 24, 2016 at 6:34 am
Benki Chendu (8/24/2016)
Will I be able to download evaluation editions of sql 2008/2014 on the VM for free of cost?
For things like this, it's a VM. That means the same...
"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 24, 2016 at 6:21 am
The biggest driving factor for seeing any kind of performance benefit (and more frequently, for avoiding a performance degradation), is the ability to absolutely ensure that the overwhelming majority 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
August 24, 2016 at 6:19 am
navtec (8/24/2016)
Ok thanks.Still very strange why SQL Server would pick up on nvarchar data type as a LOB data type though.
Go and read the documentation on the (MAX) setting 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
August 24, 2016 at 6:16 am
You have a timeout as it says in the error message: Timeout expired
Your server could be offline. You could simply have a very low client-side timeout setting. You could 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 24, 2016 at 6:12 am
For unit testing within SQL Server, I'd suggest looking at T-SQLT[/url]. It's unit testing for SQL Server and open source. If you want to automate the process and have reports,...
"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 23, 2016 at 4:19 pm
Viewing 15 posts - 4,501 through 4,515 (of 22,224 total)