Thank you so much.
I found lines below in the link that you shared:

what was the initial size when you create the data file?

if I am not mistaken, you are not able to shrink a data file below its initial size.

(if I am...

restart the active node using xp_cmdshell 😀

there are many free scripts that monitor job status, performance counter, update statistics, re-indexing etc

I write my own scripts to capture data from dynamic views.

Questions:

1st How can i see what event is the one in the first raw as the procedure name appears NULL

-- You can capture EventClass column (27) in your...

do you use dynamic IP or fixed IP?

you can try to disable both named pipe and TCP/IP protocol (keep only shared memory enabled).

also, what is the default database for your...

normally, I will pull the smaller dataset (in your example, ServerB) into a temp table (please remember to create the structure of the temp table first) in ServerA.

then only I...

have you checked these 2 tables?

select * from sys.database_principals

select * from sys.server_principals

for your FOREIGN KEY relationship, add ON UPDATE CASCADE

if your column is IDNETITY, you got to change it to non-identity.

after that, run an UPDATE function on your main table. your...

in your UPDATE, if you specify proper table hint (e.g. WITH(ROWLOCK)) AND SQL Server has enough resource to lock the affected rows, then another transaction will not get blocked.

if SQL...

different ports.

for example,

port for server\instance1 = 1434

port for server\instance2 = 1435

port for server\instance3 = 1436

in your firewall,

map IP1:1433 to your server's local IP:1434

map IP2:1433 to your server's...

u can try this. it should be something like this.

update Child set

DateInactivated = a.DATE_TERM,

UserChanged = 'Auto Close Out',

...

just a suggestion.

in your server, each instance should have 1 port.

after that, do a mapping on your firewall.

map external port to local port for each instance.

create table #tmp (id int, wbs varchar(16), dropped varchar(16), parentid int)

insert into #tmp

select '1','1','1', null

union

select '2','1.1','1', null

union

select '3','1.1.1','1.1', null

union

select '4','1.1.2','1.1', null

union

select '5','1.1.3','1.1', null

union

select '6','1.1.4','1.1', null

union

select '7','1.2','1', null

union

select '8','1.2.1','1.2', null

select...

u mean, with > 13 indexes, it locks too many resources. in the end, it has to escalate key/page lock to tab lock to improve system performance?

hm ...... my test...