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...

Clustering and load balancing.

Have 1000 servers. Take 1 of them down for maintenance and noone will ever know.

The same can be done with only 2 servers assuming 1 server...

That's exactly why DBCC CLEANTABLE was created.

Look it up in BOL before using it.

Yes you can skip the checkdb it if you don't care about that database and its data.

For reindex see this script : http://sqlfool.com/2010/04/index-defrag-script-v4-0/%5B/url%5D

I'd never run checkdb unattended with auto repair....