I also have old "orphaned" active jobs. I ran across it a few weeks ago when creating a report to alert me about long running jobs and failed job steps....

Yes, you could quite possibly have improvements by directing queries to a replicated database. Less chance of blocking and generally less demand on the primary database.

Many people set up reporting...

Select statements can absolutely affect performance.

Can you expect improvements ? That's hard to say without know the cause of the problems. If the problems are built into the application,...

Bigger picture: Propose to management that a reporting database be created and updated (preferably on a different server) and let users query against that database instead. Still not ideal to...

Run something like this to see your backup history and see if there are full backups running at other times. You can add DIFF and LOG to get more results:

SELECT...

Almost 2 years ago at a different company. I don't remember. But since I only displayed sample code, not sure how it would help you.

If you have a trace running, maybe you can match up big t-log backup files with events in the trace file for the same time period.

" ... Thanks for any input ..."

I hate "Order by 1" type code. Why not put the column name so it's clear ?

And no comments and meaningless temp table names...

The next Full backup is tomorrow morning, so that is good. Puzzled by the huge Diff though. I have trace files from that time period. Not sure the best columns...

Chris, although your code is better, I can understand why it's confusing to newer SQL coders. I think it's less intuitive, and not everyone is familiar with some of the...

Ed Wagner (3/18/2013)

---

Have you tried importing into an "inbox" or "incoming data" table that the Import Wizard creates itself? I just did this recently to get data into a...

Would SQL 2012 work any better ? I could install it on my laptop just for this.

I think SQL doesn't take a big enough sample of data, so it makes the output columns too small. I found a registry setting for how many rows to sample...

I use backup history too. Quite a few threads , posts & scripts here and elsewhere.

Make sure everything is working. If not, figure out why & fix it. And if you have time, improve things that are working, but take too long.

That's pretty much my...