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

Instead of connecting using the server name, which won't be resolving on other domains, you need to use the server IP address and port. Also, you need to be sure...

There's always the T-SQL Prettifier over at Simple-Talk.

If you're willing to spend some money though, I strongly recommend Red Gate SQL Prompt[/url]. I can't live without it. It not only...

Gail is an MCM. Amazing, wonderful, and hardly surprising. Well done!

What else did I miss?

Brendan Wong (7/3/2012)

---

Thanks - The business wants to know what the risks and benefits associated with going from SQL2005 to SQL2012 - A relatively new version.

would you think it better...

I'm not sure. I'm not seeing the issue, so I don't have any advice.

The one thing I can tell you is that you have the sql handle, so you can...

Thanks guys.

Just understand that the Profiler GUI actually pulls data using a different mechanism than trace events. So, yes, pointing the Profiler GUI at your server will put additional load on...

Cool! Have fun.

Where are you getting this...

If you're in a situation where you start a backup process and during that backup process you start a transaction. Then, the backup process completes, before the transaction. The transaction...

I'd need to see the actual execution plan.

And I'm with Gail (as usual) nolock = no fun.[/url]