Answer is "it depends"... on server spec, server load, usage of each functionality.

Only you can know what are the requirements for each individual item - based on that...

The answer to the question asked is NO - Sql Server Management Studio is just a tool - not a database and has no way to be connected to or...

In my company we use it extensively and it is the default when creating any new database.

2 Core databases
- CRM - 3TB in size -...

what version of

SSDT
Visual Studio
Excel

and bitness.
Not all combinations are allowed

script still on site - was just referenced as Featured Script on the daily email

its not being a sharepoint that matters - its is the fact it is a odata request and web request - it applies regardless of the site you are trying...

have a look at https://support.microsoft.com/en-au/help/4043104/operation-has-timed-out-connecting-to-odata-using-ssis-in-project-onli

Not native - but have a look at third party products - one of which is http://nitrosphere.com/nitroaccelerator/
Never used but have heard of it.
Other options are setting up VPN/Tunnels...

In order for us to even try and help you further and to see what other problems you have (as I do not believe that the sample data and table...

syntax is "delete from table where key = (desired key to delete)"

So what have you tried so far and why has it failed e.g. expected results and the...

And why you think it wont work? or is it that the locations is more than those you mentioned? 

And in any case why do you need it on...

SQL then 

declare @Table table
  ( id   int
  , location varchar(50)
  )
insert into @Table select 1 , 'west'
insert into @Table select...

sorry - misread and though you after some SQL - on SSRS I don't know

Eric, did you run SSMS as administrator ON the server itself? or on your workstation?

Can you also tell us how many rows each table has.

From what you said before I would think GL_Transline is the big table, but GL_Source  I would be inclined...