chumphrey 12211 (7/10/2012)

---

Thanks for the responses! So from what I am gathering, its better to consider adding more disk space to allow for the incresed size of the log...

Nope. SQL Server doesn't store versioned information about the objects inside of it. There's no way to get that directly. My recommendation, put all your database T-SQL code into source...

Based on the names of the objects in your query, I'm assuming you're doing JOINS against views, not tables. That means any one view could actually be hitting multiple other...

Golfer22 (7/9/2012)

---

1. Is the Database Tuning Advisor a great tool? Or is it not all that useful in practice? I have read about it extensively. I'm...

Yeah, don't use profiler.

Instead, use trace events which are all done in T-SQL code. It's pretty easy. Here's an article on how to do it[/url].

However, since you're working on...

if the transaction logs grew because the databases were in full recovery without a log backup, I'd say, yes, go ahead and do a shrink on them. Otherewise, they've grown...

It's basically using 'a' as it's starting point and bringing back anything that is greater than 'a'. That includes anything starting with 'a' but adding extra letters, so 'aa', 'aaa',...

From all the tests and production work I've done with compressed backups, the only down-side is a very minor increase in CPU usage during the backup or restore process. The...

The reason for this is that IN is effectively a series of OR statements checking for equality. Nothing equals NULL, so that data will never be returned. The 2nd post's...

Thanks for the feedback. It's always good to know what worked.

By the way guys, I never meant for the MCM to imply that the bearers knew everything. I just mean, I really trust the test. Anyone passing the entire thing...

forefj (7/8/2012)

---

What I was looking for was what Grant Fritchey finally posted.

As I mentioned I don't want to post everything for privacy reasons and I would now have to go...

Validate that the server is configured to make connections through IP. You can do this in the Configuration Manager (a separate app installed on the server or your desktop). But...

And don't sweat the transaction log. Any uncompleted transactions have already been dealt with by the restore process. Just make sure you set up the next set of log backups...

That's all different stuff. Nothing at all wrong with Oracle or SAP, but I can't suggest...