Viewing 15 posts - 7,561 through 7,575 (of 22,219 total)
I'm pretty sure most of the projects are backwards compatible within Visual Studio, but only across two-three versions. Database projects where that way within SSDT. Not sure about SSIS, etc.
"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 21, 2014 at 3:19 am
Paresh Motiwala (8/20/2014)
I have been reading too much good stuff about CSI. hence I have been pushing our datawarehouse be upgraded to sql 2014.
Citing this as one 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 21, 2014 at 3:17 am
MJ-1115929 (8/20/2014)
Thanks for shedding some light and highly appreciate the help provided, and nice to meet you , I have read your book on performance tuning and I...
"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 20, 2014 at 3:36 pm
I'm with Jack, I'd suggest getting in direct touch with Microsoft. A crash of the instance is not something simply changing a setting or tuning a query is going 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 20, 2014 at 9:17 am
er.mayankshukla (8/20/2014)
The page compression on Table reduces the size of table as well as size of Clustered Index without any change in size to NonClustered Index.
Now My...
"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 20, 2014 at 6:24 am
MJ-1115929 (8/20/2014)
We have a new project that requires some modeling ,design changes and performance tuning , as of now I am Administration side which I have only basic idea...
"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 20, 2014 at 4:31 am
It really depends on what you're looking for. For example, Red Gate SQL Backup goes above and beyond the CMS when dealing with backups across multiple servers, especially in how...
"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 20, 2014 at 4:21 am
Welsh Corgi (8/19/2014)
Thanks for the recommendations.When I attempt to install Ignite I get an error that the Wizard was interrupted before Ignite could be installed.
I've installed it three times without...
"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 19, 2014 at 3:42 pm
This is such a subjective question. And there are tons and tons of recommendations out there if you search for them. My favorites:
[/url]
and SQL Sentry
For specialized performance...
"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 19, 2014 at 12:29 pm
garry.lovesey (8/19/2014)
Do I need the MERGE...
"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 19, 2014 at 11:35 am
I'm not sure why they have COLLATE statements in the WHERE clause, but it's unlikely to help the code.
Keep an eye on all those variables and parameters too for bad...
"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 19, 2014 at 8:45 am
Not without error messages or something that indicates what's going wrong on your end, no.
"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 19, 2014 at 6:18 am
dstoltz 35443 (8/18/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 18, 2014 at 7:01 am
dstoltz 35443 (8/18/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 18, 2014 at 6:31 am
After a couple of searches, the only database system that I can find that has a "sequential backup" is MyBB. Here's a forum for that [/url]if that's what you're looking...
"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 18, 2014 at 6:05 am
Viewing 15 posts - 7,561 through 7,575 (of 22,219 total)