I'm not sure what you mean. You're saying you want to drop the table if it exists AND some additional criteria? DROP only uses IF EXISTS. There's not a way,...

Serial is an integer. So you would use that data type in any foreign keys.

No official term that I'm aware of. Old, outdated, orphaned, junk, garbage, <insert inappropriate words here>. You can call 'em just about anything I guess. I'd probably just refer to...

If you're using psql for running your commands, then the yes, \timing turns on query time. After you connect with psql you can just type "\timing" and it will turn...

This is the PostgreSQL forum here on SSC...

The right indexes will help in some cases. But honestly, you'll have to evaluate each. It's going to be the same as dealing with the query tuning. It's all of...

The only reasons I would use XML are because I've got a metaphorical and/or technical gun held to my head. It's honestly crappy and the XPath queries within SQL Server...

Personally, either would be fine. However, AWS has a much larger market share, so it's more likely to be transferable.

It's mostly a question of training and setting up the right levels of access. While you want to empower people, I'd be cautious about giving too many, especially untrained and...

In all fairness if the commands are  coming from SSMS it's not...

If the backup takes longer than an hour, we're killing it? I mean, so much of this seems arbitrary and heavy-handed. What's the real problem?

Oof.

Well, part of it is easy & straight forward. Set up a SQL Agent job to run once an hour. You can script out the capture of long running code...

I don't think we can do that. You can absolutely filter out tables that have no differences. However, once a table has a difference, in order to show that table,...

You can also do a query against the DMVs to see what's currently in cache in terms of queries against the databases. It won't show the kind of detailed activity...

Hi.

Full disclosure, I work for Redgate. So, you can weigh everything I'm about to say.

Microsoft has a tool built into Visual Studio, so you have to have a license for...