One thing to know, SQL comes in various flavors. While there's quite a lot of commonality, querying T-SQL in SQL Server is different than querying PL/SQL in Oracle, which is...

So, you're best bet is start with a CSV file. Instead of trying to take MySQL/PostgreSQL/Oracle backups/dumps, export the data into a common format; CSV, JSON, whatever. Then, import from...

On this web site, if you look at the top of the screen, are a series of lessons, utterly free, called Stairways. They cover things from T-SQL querying to backups...

Sounds like you're trying to build a universal query, or a catch-all query. These things are notoriously difficult, and as the linked article explains in detail, extremely inefficient (I...

Without either the destination location or at least it's orientation, all you're looking at initially is a query within a radius. You can use STWithin to identify any other...

If you have MDF & NDF files, you can try using ATTACH to recover them. But, as others have already said, if your database is corrupt, it's in those...

Hi everyone! This is my first post on this subreddit. I'm absolutely new to the Sql world and I just signed up for a Udemy course to start learning...

Honestly, it sounds like you just need a spreadsheet to rope a few bits & bobs together. I'm with Jeff, focus more on what we're attempting to solve, less on...

Straight up: Extended Events or Query Store. Which set of queries are using the most resources? Answer the question.

It all sounds like pretty traditional query tuning stuff.

You're gathering some metrics, but it doesn't sound like necessarily the right ones. I'd suggest using Query Store or Extended Events to...

Total agreement with all of you. Thanks for the comments.

Not even going to try to sugar coat it.

I'm not a fan of presenting in a 100% virtual environment.

The lack of interaction, feedback, and just the repetitive nature of talking...

With utterly incomplete information, not seeing the query, structures...

Actually we have a database which is not part of availability group and it's reading the data from secondary replica and inserting into the database which is not a...

Take a look at the execution plan. It's going to be all one allocation.

UNION ALL isn't a bad performer in general. In fact, usually, you get better performance with UNION...