I think you may have misunderstood...(or maybe I did) but you asked:

I have a 100 + Jobs running on our production SQL server and these jobs are running/owned under service...

Have your System/Domain admin create a security group in Active Directory and add in all the developers who should have this ability. Once that's created, add that group as...

Is there a better cost/ratio by adding a column(s) to the index versus including them?

I've sometimes noticed the index will grow considerably larger by adding columns, but less when the...

Try setting up a system DSN driver first through ODBC on the server itself at the OS level, then create the linked server using the DSN from what you just...

Gail, in your test yes this is true, however in the...

They they ran (on 8 different tries) from 10-15 seconds

FYI, the memory and CPU don't really move much during these reporting execution times...the CPU hovers around 30%, and the memory stays even. The disk reads spike up to...

I tried the test but they still didn't execute at the same time:

Window 1:

WAITFOR TIME '13:42:00:000'

SELECT GETDATE()

-- exec reporting procedure here

Returns: 2011-08-11 13:42:00.003

Window 2:

WAITFOR TIME '13:42:00:000'

SELECT...

I use SQL Diagnostic Manager (Idera) and it works quite well. I like the historical views and the fact that it basically has every PerfMon you could ever...

Thanks so much for these tips!

I've already made sure the index was there but about putting a WAITFOR in there or placing them on separate spindles (makes perfect sense now...

Thanks, I will look at replacing ours with this nifty code!

How about something like this?

Create a function to handle the parsing you need, then just call it when doing the INSERTS

Create scalar function

USE [F1Settings]

GO

/****** Object: UserDefinedFunction [dbo].[fx_FormatArrayText] ...

In that case,IMO you're going to be limited to using a custom solution than anything you'll find out of the box...

I'd try pitching the centralized database idea...If that's not possible...

Are you looking to sync all three databases back to each other or simply back to a centralized DB (sorry if I'm not reading your original post correctly)?

If you're only...

How are your drives set up? Are they single drives? Raided? How are your SQL DB files placed on the drives?

It's difficult to say what's going on here without...