According to Buck Woody a DBA is a Default Blame...

Your welcome. I'm always happy to help out where and when I can.

While not a corruption ninja, I will say that I'd agree with Paul on this one. I do notice that the query you posted does NOT match the one...

I've never had the pleasure of working at a company that had a lounge or game room, but we would occasionally have a staff lunch (one co-worker loved to cook),...

Lynn Pettis (3/11/2010)

---

Jack Corbett (3/11/2010)

---

Do you have your network and sever admins involved as well? It doesn't seem to me to be a SQL Server issue.

I'm not sure that...

Do you have your network and sever admins involved as well? It doesn't seem to me to be a SQL Server issue.

I'm not sure that you'd get anything from...

When I have a table that has a Foreign Key column, essentially a child table, that I am loading using SSIS, I use a lookup transform to "weed out" rows...

Try this search: http://www.bing.com/search?setmkt=en-US&q=SQL+Server+fixed+server+role

Geoff Hiten has a great presentation he does on clustering where he recommends using mount points. He has a series of blog posts started on it as well which...

If you have correctly sized your log and have the correct recovery model and backup strategy you shouldn't have much, if any, log growth.

In order to find out how much...

I can relate. I wonder how people know so much, but it really is just plugging away. Need to learn how to tune a query, find a book/blog/article...

Yes you can install them side by side.

This seems like a good opportunity to use Service Broker.

I can't find it now, but I have read an article/blog post where the author used Service Broker and a .NET...

SCOM also can do SQL Monitoring if you already have it for other reasons. I don't think you'll find a purchased solution that isn't close to or more than...

A shared lock will have to be taken on Table2 resources in any situation. Think about it this way, you are updating table1 based the relationship with table2. ...