Steve Jones - SSC Editor (2/8/2011)

---

Patching is a big concern, especially if you use things like SSIS differently between them.

The load, as mentioned, is something I'd be careful of, and...

Craig Farrell (2/8/2011)

---

:laugh: The fact that it's usually silly or the fact that it doesn't ever seem to be the same one 3...

I've seen it work both ways.

Both have advantages that are no negligible. 1 garantees the data is good. 2 Improves db speed.

What would you do ?

SQL Agent and SSMS are highly overrated... but it ranks right up there with Oxygen.

The sad truth is that you need to prove you're wasting time and gaining nothing by...

Craig Farrell (2/8/2011)

---

Jack Corbett (2/8/2011)

---

Ferguson (2/8/2011)

---

I am not saying I would not consider you, but I will try to answer your perhaps rhetorical question.

Someone who as a young adult decides...

Very interesting solution here (make sure to read all the comments, the best stuff is in there)

http://sqlblog.com/blogs/andy_leonard/archive/2009/03/11/xp-delete-file.aspx

Yes, tho I remember reading that some systems tables are not checked and that it can cause bugs later when you upgrade to 2k5+.

I preffer to script everything manually. ...

GSquared (2/8/2011)

---

Ferguson (2/8/2011)

---

Jack Corbett (2/8/2011)

---

I agree that this is a much better posting, albeit one I am not qualified for.

I think that you should almost always include "or equivalent experience"...

Why do you think it's slowing down the users?

The log file is at this size because someone made it that big or because it grew there.

So it's not something you...

Ferguson (2/8/2011)

---

Jack Corbett (2/8/2011)

---

I agree that this is a much better posting, albeit one I am not qualified for.

I think that you should almost always include "or equivalent experience" when...

Jack Corbett (2/8/2011)

---

I agree that this is a much better posting, albeit one I am not qualified for.

I think that you should almost always include "or equivalent experience" when listing...

Ian Scarlett (2/8/2011)

---

This sounds very much like the issue SQL Server 2000 had with not reclaiming space for tables with text/image columns.

The only solution I found to that problem was...

Ya I had problems to shrinking my logs in live environement. Maybe this can work for you too.

I'd change shrink log file to data file. Tho I'm not...

PaulB-TheOneAndOnly (2/8/2011)

---

winston Smith (2/8/2011)

---

Lets say you have a large db that has to be online24/7. It has tables with many indexes that need to be maintained.

Most systems will have a...

The indexing job I sent out can be run in prod if most of the indexes are really small. But it's better to run in downtime of course.

Here's the...