Viewing 15 posts - 901 through 915 (of 22,224 total)
It's right in the Microsoft documentation. You can do that. I'm not sure you should (data movement out of Azure has some cost overhead), but you can.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2022 at 12:48 pm
Yes. Azure Managed Instance works in a very similar way. You can simply restore a database there. Although, you should know, that you can't take a backup from there and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2022 at 12:45 pm
Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"
And when I hit submit again, it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2022 at 1:17 pm
I've always been concerned but, as I get older, I seriously worry about the medical world and hospitals and the people in them when I see things like the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2022 at 1:15 pm
And, on top of what Steve says, 2012 is on the way out in terms of support from Microsoft. You're going to be much better served learning from much more...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2022 at 12:51 pm
The key here is to take advantage of the fact that you can store your data in the way that is most advantageous to the majority of queries. If the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2022 at 12:49 pm
The keys should be unique. There's not a single product key for everyone. Sounds like maybe that vendor is less than completely above board.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2022 at 12:45 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2022 at 12:15 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2022 at 3:01 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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2022 at 2:35 pm
Viewing 15 posts - 901 through 915 (of 22,224 total)