Viewing 15 posts - 1 through 15 (of 277 total)
Thanks Eddie. I read somewhere that it takes Schema-Modification lock.Is this true?
November 5, 2023 at 6:16 am
So, UPDATE STATISTICS command gets replicated in ALwaysOn, Mirroring and Log shipping?
December 4, 2022 at 1:56 pm
SQL 2012 is 10 years old but I graduated this year and joined as entry level.
October 28, 2022 at 8:27 am
There is no space for taking log backup
October 7, 2021 at 12:57 pm
Hi Jeff,
Does the "modify_date" column gets modified when DML changes also occur, or only DDL changes?
September 15, 2021 at 2:56 pm
Actually, the group is a member of some user defined role. I want to know what all permissions this role has. How to do it?
September 14, 2021 at 3:22 pm
Can you please help me with the script. The script should take database name as an input parameter and should output all its related jobs, steps and schedules.
September 17, 2020 at 1:49 pm
Row compression is a good choice for OLTP data, high updates. Page compression is good choice for data having low updates.
April 7, 2020 at 2:26 pm
November 6, 2018 at 12:08 am
ramyours2003 - Friday, October 26, 2018 3:43 AMHow the server knows when the other server down in mirroring .
Mirror server pings principap...
October 27, 2018 at 7:17 pm
ramyours2003 - Tuesday, October 23, 2018 11:09 AMIam having 3 ag groups .can I use same listner in this case
No
October 24, 2018 at 1:21 am
October 22, 2018 at 9:24 am
October 10, 2018 at 7:43 am
September 25, 2018 at 8:35 am
September 20, 2018 at 12:50 pm
Viewing 15 posts - 1 through 15 (of 277 total)