If you really can't answer that, you probably need to hire an IT person who knows how to use server tools.

Start by opening up the task manager on the server...

Throttle the devs, then see if you can set up synonyms in the dev environment that will give you what you need.

A database in Dev named "ipZone00" that has nothing...

Is the server running out of memory? If yes, then you need more. If no, then you don't.

There's no way to tell if a certain number of databases...

Do an outer join based on the primary criteria, then another based on the fallback criteria, and use Coalesce (or IsNull) to bridge the gap in the Select clause.

select MO.SiteID,...

Oracle fires triggers on a per-result basis. MS SQL fires the trigger once, and you have full access to all modified rows by using the "inserted" and/or "deleted" virtual...

It means you are trying to pass Windows authentication data through more than 1 layer.

Does the proc connect to another server? That's the most likely scenario. If you...

"Case" doesn't work that way in SQL. It does in VB, but not in SQL. "Case" is a select option in SQL, not a flow-control statement.

E.g.:

select case when...

I seem to remember not being able to query UDFs through a linked server, and I think I had to solve it by using OpenRecordset. Was a few years...

Do you have a table of the months? If not, you'll need to generate that (real, temp, variable, derived, CTE) in order to get these. Do a cross...

I guess I don't understand your question. It seems like, "select * from table where sk = 1" would be the answer.

How are you moving the data to the "more secure database"? Are you doing parallel inserts? Or are you inserting, then moving? Or some sort of "instead"...

If you specify a data qualifier in your export, all of the fields will be enclosed in quotes (or whatever character you choose for it).

Break up the insert into smaller numbers of rows, and run them sequentially.

How you go about doing that depends on your import method.

If what you're doing is a single bulk...

Try something like this:

SELECT *

FROM [table1]

inner join [table2]

on [table1].[Amount] between [table2].Amount -1 and [table2].Amount +1;

You can refine the query from there, but that should get you started.

Join...

There are several ways to accomplish what you need.

One is a table variable input.

Another is to parse a string into a table.

Another is to use the string to build "dynamic...