So here's the deal, the Azure Query Editor window doesn't allow you to highlight a query and run it in parts. It runs the whole query as a single statement....

So I understand, your first table has a unique constraint consisting of two columns, but you're trying to set up a FK relationship to only one of the columns? You...

So mirroring won't work from 20 different databases into 1 database. If you want to do something like that you're looking at either building your own tool, or using

What were the schema changes? Did it add new indexes on top of the ones already there? That would explain the size increase. Or is it just the log that...

Yes. Nothing has changed in Profiler since 2008.

You might want to take a look at Extended Events for your more modern systems.

Hello Threadizens,

Look, I could care less, but Hugo is quite chuffed about this, so I figured I'd share this with you. The 3rd Edition of Execution Plans is...

Education.

Help them out by teaching them the right things to do. It's the only way unless you lock them out, which may or may not be possible depending...

Jeff is dead on accurate. That is the fastest and safest way I know to get the job done.

However, I do know a way that is just as...

It really depends on how you're capturing the elapsed time. There is a way in extended events to only capture the execution time of a procedure, skipping the compile time...