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

Honestly, Azure or AWS is what I would suggest.

Are there third party things? Sure. Are they applicable to a broad enough swathe of the landscape that it's going to help...

You would need some different filtering on the waits. You can't simply correlate them through causality tracking and then only capture the related waits. Instead, you also need to filter...

Jeff. Your ears should be burning. I've had a few conversations about you & fragmentation over here in Belgium with a bunch of people. Happy to hear you've...