Wow, I just found this extended sproc tonight. I’m pretty estatic about it! xp_servicecontrol allows you to query the status of a windows service. In the past, I’ve used the ’sc query ‘ via a cmdline. Now I can do it without having to open up a cmd prompt.
xp_serviceControl querystate, MSSQLSERVER
Other [...]

I performed a snapshot of my publication today with compression turned on, you know, to save some disk space. But I ended up getting an error about:

The uncompressed size of the file ‘item_detail_9.bcp’ has exceeded the size limit of ‘2147418111′ bytes imposed by SQL Replication’s compression support.
To resolved this error, turn off the compression [...]

In my current environment, I have a push transactional replication and I wanted to find a way to help minimize performance. So came about the -maxDeliveredTransactions. I read the technet article which states:
-MaxDeliveredTransactions number_of_transactions
Is the maximum number of push or pull transactions applied to Subscribers in one synchronization. A value of 0 indicates [...]