Viewing 15 posts - 871 through 885 (of 22,189 total)
Since you're posting in a SQL Server 2017 forum, I'm going to give an answer that applies to 2012 or greater. Less than 2012, it's a different answer.
Don't enable the...
April 26, 2022 at 12:42 pm
Although SQL Server lacks the necessary capabilities, third-party software exists that does. RedGate used to get something like this, but I believe it was discontinued... although I might be...
April 26, 2022 at 12:15 pm
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...
April 13, 2022 at 2:53 pm
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...
April 13, 2022 at 2:50 pm
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...
April 13, 2022 at 2:44 pm
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...
April 13, 2022 at 2:40 pm
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...
April 13, 2022 at 2:35 pm
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...
April 12, 2022 at 12:49 pm
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...
April 12, 2022 at 12:40 pm
Straight up: Extended Events or Query Store. Which set of queries are using the most resources? Answer the question.
April 6, 2022 at 4:18 am
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...
April 4, 2022 at 12:45 pm
Total agreement with all of you. Thanks for the comments.
April 3, 2022 at 3:51 pm
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...
April 2, 2022 at 12:34 pm
Tried with temp table and maxdop option in query and it didn't resolve the issue. Wonder changing the CTP would help?
With utterly incomplete information, not seeing the query, structures...
April 1, 2022 at 7:41 pm
Viewing 15 posts - 871 through 885 (of 22,189 total)