Viewing 15 posts - 1,651 through 1,665 (of 22,219 total)
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
The number of tools that will let you move things is huge. SSIS will work. So will using the import/export in SSMS. Can you just start with a backup &...
"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 12:13 pm
The other key word you need is DENY. In addition to GRANT permissions, you can also DENY permissions.
Sounds like the user might belong to a group that has more access...
"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 12:10 pm
I'd probably lean heavily towards using tasks defined through whatever tools we're tracking bugs and other work in. Especially since those tools usually can be correlated to source control. Since...
"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 11:40 am
It's for the Task List. The short cuts act as markers there. Got the answer from Twitter.
"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 18, 2020 at 12:14 pm
Great question. Not a clue. I just tried it out. It puts a weird looking arrow in there. Several clicks in and around it yielded nothing. Hmm...
"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 18, 2020 at 11:45 am
Viewing 15 posts - 1,651 through 1,665 (of 22,219 total)