NoSQL

Technical Article

RE: Cross-server query in a stored procedure

  • Reply

cross-server queries are considered heterogenous queries so you have to set ansi_nulls/warnings "on" with the "GO"s then you have to create the procedure in QA (because you cant put three seperate statements in a "create sp window" in Enterprise Mangler. Once it is created you can alter it in Enterprise Mangler.

You rated this post out of 5. Change rating

2005-05-20

Technical Article

RE: New SQL Instance to boost performance?

  • Reply

Regarding a new instance, i think it does give you some flexibility in managing your resources but at the cost of overheads. I would concur with Allen that with the nature of the issue which you are having, multiple instances won't be a good place. Also, before going that far, i understand that you have […]

You rated this post out of 5. Change rating

2005-05-10

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers