Viewing 15 posts - 1 through 15 (of 6,609 total)
have a look at Scope: The drastic caveat with Logon Triggers
February 26, 2020 at 1:21 pm
We have automated weekly restores ( including checkdb ) .
This target server has a C-drive and one big raid-0 volume as that is its only purpose.
It holds max 2 user...
February 25, 2020 at 10:35 am
That's wonderful news, Kendra and Jeremiah.
Keep in mind, your dogs immigration will need some time too, maybe even a quarantine time.
All the best in the UK
February 25, 2020 at 10:24 am
and, depending on your view definition, the result must also meet the view specifications !
( With check option )
February 24, 2020 at 3:43 pm
Please upgrade to the latest CU ! You are missing essentials and RTM already had a mandatory hotfix at launch time !
Please let me know if that helped !
February 24, 2020 at 2:59 pm
Good points !
February 20, 2020 at 9:53 am
what edition are you using ? Std edtn vs Ent edtn ?
( No backups on secondary replica with basic AGs ( = std edtn ))
February 19, 2020 at 2:49 pm
What did you test ?
logically step-1 determine the max CreatedDate per orderid
logically step-2 update all rows for the given orders that do not have CreatedDate equal to the max_CreatedDate for...
February 19, 2020 at 2:46 pm
Before you do that. What is your goal ?
February 6, 2020 at 1:30 pm
I would suspect the AD SPN.
I recall our cluster losing full control over that object during our tests.
Broke it down and rebuilt it. Never happened again. We built 10+ 2node...
February 3, 2020 at 8:02 pm
Did you enable the AlwaysOn XEvents session on all involved instances?
Did you install a monitoring solution to get an overview of failover events,..
I have a sqlagent job that is launched...
February 3, 2020 at 4:01 pm
did you check with all prerequisites ?
Prerequisites, Restrictions, and Recommendations for Always On availability groups
February 3, 2020 at 3:55 pm
BTW What's the advantage of an AG if you really need it to be hosted on a given server ?
It should be consumable in either situation.
February 3, 2020 at 3:47 pm
Check the SQLServer errorlog file !
Try the failover to A manually in SSMS and see what error comes up.
Implement failover monitoring so you can see which fases it passes or...
February 3, 2020 at 3:39 pm
What's wrong with a simple ALTER INDEX cl_ix ON schema.table REBUILD ... ? ( as that does not impact the non-clustered indexes )
Keep in mind this will also interfere with...
September 19, 2019 at 9:38 am