Viewing 15 posts - 3,871 through 3,885 (of 22,224 total)
That's no good. You're basically talking merge replication here. It's a nightmare. You'll need to move to VMs and you'll have to completely redesign and rebuild your databases. Or, you...
"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, 2017 at 8:52 am
Sorry I couldn't help. I just can't replicate the issue. Going to Microsoft is probably the best guess right now.
"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, 2017 at 8:49 am
Read this overview article. The primary purpose is absolutely for failover and continuity. However:
Another key benefit is that the secondary databases are readable and can 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, 2017 at 6:59 am
If CONVERT doesn't work, then the data may not be of the type you think it is, or, it could be encrypted. Just guessing since we can't see what's going...
"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 25, 2017 at 3:40 pm
It's not data pools. That's a way of managing and paying for Azure SQL Database, not something like the Data Lake (completely, utterly different technology), which is distributed storage. Within...
"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 25, 2017 at 3:39 pm
"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 25, 2017 at 11:17 am
to put a secondary in the same data center, you have to create a second server. That server is the connection string you would use. Putting a secondary in 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 25, 2017 at 8:36 am
Tried editing again. There are no duplicate lines in the original text it's something in the formatter.
"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 25, 2017 at 6:58 am
"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 25, 2017 at 6:56 am
I wouldn't say it's better. It's different. Easier for one thing. The first question is, can you work within the Platform as a Service offering of Azure SQL Database? If...
"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 25, 2017 at 6:49 am
I've sent a message to someone who works for them. Hopefully you can get some help.
"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 25, 2017 at 6:37 am
If it's Azure SQL Database, no, setting up VMs is a bad choice. You want to take advantage of Geo-Replication. That's designed for exactly what you're looking for. If you...
"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 24, 2017 at 5:04 pm
Lynn Pettis - Monday, April 24, 2017 4:12 PMSorry I brought it up.
But wait. What happens when my stool only has two...
"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 24, 2017 at 4:15 pm
If you do a web search for Extended Events, the first or second link is usually the "Getting Started" documentation from Microsoft. That's the best way to get started.
"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 24, 2017 at 3:06 pm
To get the use of a single database, you need to target data collection to only capture information about the database. The built-in, automatic collections that you see are server...
"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 24, 2017 at 1:35 pm
Viewing 15 posts - 3,871 through 3,885 (of 22,224 total)