Viewing 15 posts - 1,636 through 1,650 (of 22,202 total)
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...
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...
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...
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...
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.
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...
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...
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 &...
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...
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...
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.
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...
August 18, 2020 at 11:45 am
Happy you found the answer to the issue.
August 13, 2020 at 10:33 am
Well, your network persons assurances aside, that looks like a network error.
However, capture the query metrics and the wait statistics. Don't guess. Don't hover at the edges, looking at system...
August 13, 2020 at 10:12 am
First, set up Extended Events to capture the overall performance of the queries on the system. You can use rpc_completed and sql_batch_completed events to capture that information. Personally, in your...
August 12, 2020 at 12:35 pm
Viewing 15 posts - 1,636 through 1,650 (of 22,202 total)