Experience in DB testing does not necessarily imply developer-level skills. Quantifying what your team's skillset will help you make decisions. Since this is an established team it might be good...

I just learned about MAX_ODSOLE_OBJECTS. I traced your code and it looks like you're destroying all your created objects, i.e. no leaks, but it is quite odd that you;re dying...

Chances are the transaction is rolling back. You'll just have to wait for it. 90 GB is a fair bit of data. Sometimes it can take significantly longer to roll...

Unlike the file-based DTS packages which were binary file formats SSIS package files are text-based XML documents and therefore can be versioned in your favorite source control repository and compared....

In that case consider switching to SIMPLE recovery before your maintenance then back to FULL after. Take a FULL backup immediately after switching back to FULL recovery to re-establish a...

Same Windows and SQL Server Build # on all servers?

Wow, tough assignment. Are your team members skilled as developers? i.e. will they be writing unit tests to exercise code other developers have written? What kind of tools will be...

For me, testing in production is only considered an option in extreme cases and never would be part of a normal development lifecycle plan. I like to restore production backups...

Does the file referenced by the Excel Connection Manager exist?

If your talking about small DBs where it only takes 20 minutes for CHECKDB and you want as close to turnkey as possible, then go for it.

I still would not...

lawson2305 (9/6/2012)

---

ok here is where I'm settling.

1. run db integrity check system db

2. run db integrity check users db

3. backup db full

4. backup db log file (overwrite)

5. set db bulk...

lawson2305 (9/6/2012)

---

the reason I was doing the integrity check twice is because I taught to run it first. Then ran it again because of this comment:

http://ola.hallengren.com/frequently-asked-questions.html

Scheduling:

"I recommend that you...

lawson2305 (9/6/2012)

---

So let me throw my weekly maintenance plan order to you and please provide any feedback.

1. run db integrity check system db

2. set db bulk mode < why?

3. run...

There are plenty of examples online. Just Googling for the phrase you posted "Find the longest running queries/processes in SQL" yielded lots of relevant results.

You're looking at the right views. The web has tons of examples of 'most expensive by cpu'...