If you have a half-GB of tlog file on a 1.3TB drive, please don't shrink it. It will just grow back out again, leading to OS file fragmentation and...

Perry Whittle (2/20/2012)

---

Agreed, that and removing wacko maintenance plans...

As Perry says for just 70 databases you can certainly use the...

We cannot help you without LOTS more information. I also think this may go way beyond a forum-level assistance need. Consider getting a professional on board to help...

I built a system to handle log shipping/restore for a reporting/DR need for a client that had 7400+ databases on a single server, so your number of databases will be...

You can try the brute-force-hammer of OPTION (MAXDOP 1) or you can dig into it more and try to find a fix from bad programming, suboptimal indexing or bad schema...

runaldo (2/15/2012)

---

check out ola.hallengren.com

Problem with this maintenance solution is that it doesn't take backup of new databases. You manually need to add it to the job. Hallengren's solution fixes...

Don't worry - Joe wouldn't accept your advice or worry with anything negative you say about him in any case! :hehe:

He has gotten a bit better over...

Get a professional to come in and give your system a performance review. Find problems, fix them, and...

>>Joe, there's no question you know the trade

But that "trade" is GENERIC, STANDARDs-based SQL. He does NOT know "SQL Server" and over the years has routinely given BAD and...

Oksana March (2/10/2012)

---

TheSQLGuru (2/10/2012)

---

Note that you should not concern yourself with objects with less than N pages, where N is probably 500 or even 1000 or more depending on your...

I agree with Lowell - CLR RegEx is the way to go here.

Kiran, as someone else mentioned these forums are "staffed" by volunteers. Thus the forums are appropriate for small, short, simple-to-moderately complex topics. That query really does not look like...

Consider getting a professional to remote in to a) help you figure out what the heck is really going on here and stop it and b) get your system functional...

Note that you should not concern yourself with objects with less than N pages, where N is probably 500 or even 1000 or more depending on your system.

Question: what...