Hi Skippy

Welcome to the conundrum of central management. It's a nice problem to have and there are many ways around it.

Some prerequisites.

Any data etc that you are going to pull...

Grasshopper

Any DBA will at some stage need to work under pressure

I just happen to have some code to move tons of files from filegroup A to B based on the...

while we on this 🙂

Personally I won't cluster the identity column.

If one person have a single sign on I'd rather create a clustered index on this column. If 1...

I you are a package type of company instead of development, I'd suggest solarwinds.

Otherwise reporting services / excel.

I still think excel is the easiest way to report on anything. All...

You need to specify the types that output for BCP.

You can get native database types etc.

I would not use SSIS, bcp is much quicker to design and you can run...

Hi

I suggest you look at the errorlogs, check the error.

Get the address and details of the database and the associated LUN on SAN.

Check for path failovers, find out how...

My guess is expired password for NT account 🙂

Hi

Just looking at your code there, I know the time in sysjobhistory is poked. It requires a lot of calcs to be done.

If you are in fact working out...

Hi

Mirroring I think would be the easy bit, networking now that's a different story.

This is what I would do.

First I'd verify that my IP is bound correctly to both instances,...

Hi

Maybe a process is using the table. Generally if you boot the server your tables are not going to pop into buffer unless it's being used.

For instance there might also...

Write the code yourself.

backup database test to disk = 'c:\test.bak'

restore database test from disk = 'c:\test.bak'

<with move> etc. check bol.

Which is faster, the above or a GUI.

Please you also know...

Hi

Personally I found MERGE to be less efficient than writing the relevant single queries.

In all honestly your data is going to be cached when search for existing rows etc.

If you...

Hi

Well , by default SQL will use all your memory. SQL don't do things out of the ordinary it does what we tell it to do.

Be default memory setting will...

Hi

You can also checkout bcp, it's as old as the mountains and blazingly fast.

It's also fairly simple to use

Cheers

Jannie

Ai

sorry guys, typo there. 'maxdop ', 1

Default is 0 which is not always the best.