Viewing 15 posts - 3,496 through 3,510 (of 22,224 total)
I was wrestling with RStudio just yesterday. I made the mistake of installing both the Stand Alone server and the internals on the same machine. Don't do that. (for those...
"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 5:50 am
This article shows how to use an ARM template. That should help.
"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 5:12 am
When you post the execution plans, if you post the execution plans, please post the XML of the plans themselves, preferably the actual plans instead of estimated. Posting a picture...
"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 5:08 am
If you have an MSDN account that also comes with free Azure time that gets renewed monthly.
As far as getting started, my recommendation is to simply dive in....
"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 28, 2017 at 4:55 pm
RStudio is a standalone server for R that you use to manage queries against your database rather than let them go through the built in R servicing architecture that's built...
"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 28, 2017 at 4:32 pm
Doggone it. The formatting is messing up. I've fixed it twice now. I get it right and posting it messes it up.
"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 28, 2017 at 12:02 pm
SELECT COUNT(1),
vb.Value
FROM Listings AS el
INNER JOIN Bindings AS vb
ON vb.fieldid = 7100
AND el.EntityID = vb.EntityID
WHERE...
"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 28, 2017 at 12:00 pm
Sounds like the backup may have been corrupted. Try restoring it to a different server. If it fails there too, that's the problem. You'll need a new backup. If it...
"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 28, 2017 at 11:56 am
It's possible that the optimizer will just change it to a join anyway. If you can, post the execution plans, preferably the actual plans.
"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 28, 2017 at 8:48 am
Could be several things. You have transactions that you're waiting on to complete before the database goes into single user. Alternatively, someone else connected ahead of you and you're waiting...
"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 28, 2017 at 8:46 am
roger.plowman - Tuesday, November 28, 2017 6:22 AMAnything from Red Gate
Well, you get no argument from me on this point.
"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 28, 2017 at 7:02 am
Plan affecting settings are stored inside the execution plans. However, everything else is through standard events like existing_connection. It lists a lot of stuff, but not the subnet failover setting.
"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 28, 2017 at 4:59 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 28, 2017 at 4:30 am
I don't know because I don't use the tool but, if you need...
"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 27, 2017 at 8:12 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 27, 2017 at 6:14 am
Viewing 15 posts - 3,496 through 3,510 (of 22,224 total)