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

If you right-click on the tables within the Object Explorer in SQL Server Management Studio, you can select an option that lets you create a script. That's what we're looking...

Profiler won't show the code from a stored proc if you're capturing execution calls. It will only show the code if you're capturing statement calls, which you don't want to...

Nesting views, calling a view from within a view, is generally a bad practice. It leads to poor performance since, in most cases, not all the columns or tables referenced...

The differential backup is only good since your last full backup. When did you last take a full backup? And yes, you can restart the server and the differential backup...