Not sure I fully understand what you are asking, but what I suspect is that you are looking at the linked server from the GUI. If so, try scripting it...

If I had to guess, I'd say you are running into a limitation of Azure Query Editor. Likely either the 5 minute timeout or the "multiple statements only give results...

I can't see the article, but with the premise I think it, like all things with a DBA, depends. If I am building a life support system and it is...

I personally prefer the dynamic SQL IF you are working with changing table structure as then if you add or remove a column you don't need to add or remove...

another approach, although will become messy if there are a lot of columns, would be to have 1 "master" stored procedure that takes the parameter (such as fpartno in your...

Well, MSSQL has several mechanics that can do something similar.

If you want to run a huge SELECT but don't care about the results open the Query Options  go to...

• This reply was modified 2 weeks, 1 days ago by Mr. Brian Gale.

I am a fan of having things like "current" or "latest" with the expectation that I will rename it when a newer version comes out. Where possible, I like having...

I like CDATA as a concept, but it is an expensive tool for sure AND it still requires other tools to do the heavy lifting. If you want the ODBC...

Is the different domain in the same AD forest? If so, then you should be able to authenticate across and see the other servers and everything should just work. If...

One more thing - make sure the ODBC DSN that you are using is the correct bitness (32-bit vs 64-bit). If the app is 32-bit, then it MUST be the...

Speed of the SSD and network latency will determine the maximum performance of the SQL instance. My understanding, if the network latency is 1 second and the SSD speed is...

My opinion - if E2 is running on a SQL Server backend, why reinvent the wheel? Use SSIS for your ETL.

If that isn't an option for one reason or another,...

Maybe this is over-simplifying the problem, but is there any reason why you can't connect directly to the data source?

In my experience, the more hoops your application has to jump...

Just my opinion, but systems with "variable mass systems" such as rockets, comets, fluid ejection, or systems with dynamic mass exchange, I am not sure what this model helps with....

I'd be hesitant to use floats personally. Main reason is that floats and reals are approximate values. See this link

PLUS if you are REALLY needing a NUMERIC(30,10), the CAST...