Viewing 15 posts - 1,651 through 1,665 (of 22,224 total)
If that's all you want, set up an Agent job that polls the servers to see if they're online or not. It won't be much work. You can store 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
August 25, 2020 at 11:30 am
I answered this over on stackexchange too. I'd use AZCopy to move the backups up to Azure Blob Storage, specifically where your VM has defined it's storage. Then, it's just...
"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
August 25, 2020 at 11:20 am
Oh great point. Check for triggers. Secret little turkeys will get you every time.
"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
August 24, 2020 at 2:56 pm
Agreed. Please post the execution plan. It's just not possible to say what's going on without 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
August 24, 2020 at 12:45 pm
Out of the box, by default, Redgate SQL Data Compare will find tables with the same name to compare, as you noted. However, you can map tables with completely different...
"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
August 24, 2020 at 12:43 pm
Without seeing the full structures, it's hard to say for certain. As was already stated, a normal view would not in any way affect this. Only the materialized/indexed views will....
"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
August 24, 2020 at 12:35 pm
In theory, it really is as simple as getting the production server back online, wait for the logs to get moved over, and then fail over back to production. 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
August 21, 2020 at 5:02 pm
Imagine the lady in Poltergeist: ALL ARE WELCOME!
Come on in. The water is fine. This is just the local water cooler (bubbler/fountain/whatever your local vernacular is for a...
"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
August 21, 2020 at 1:11 pm
Generally, the way to recover this would be to bring the AG back online and let it sort itself out. In fact, you should be seeing ever growing log sizes...
"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
August 21, 2020 at 12:40 pm
The dots are part of the three part naming. They're supplying the database name, TEZ_BDW_TUT, skipping the schema name, '..', and supplying the table name, sor_ar_x_cl. The assumption is, 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
August 21, 2020 at 12:37 pm
As a (mostly) lurker on this esteemed forum for around five years, I've only recently come across this thread.
I've not managed to consume all 4000+ pages to find 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
August 21, 2020 at 11:46 am
Thanks, I also heard complex logic should handle in business layer not on database layer. Is that just some people's preference?
Don't get caught in absolutes. Put the logic where...
"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
August 20, 2020 at 4:54 pm
Not that I'm aware of. There are example queries around here on SSC if you look for them.
"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
August 20, 2020 at 10:03 am
If you do a backup & restore, it's a page-by-page copy. If the restore is successful, there's nothing to check. Everything moved.
However, yes, if you use any of the 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
August 20, 2020 at 9:29 am
Random frozen pork chop?
Do launchers require registration and a permit?
Does Anyone offer a safety class?
It seems injuries are rather rare. Or is this something the news ignores?
Cannon's are legal...
"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
August 19, 2020 at 6:56 pm
Viewing 15 posts - 1,651 through 1,665 (of 22,224 total)