Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE PROCEDURE FINAL_BATCH_INS AS DECLARE @BatchSize INT = 5000 WHILE 1 = 1 BEGIN INSERT INTO customer_final WITH (TABLOCK) (ID,Name,Area,CheckSum) SELECT TOP(@BatchSize) ID,Name,Area,CheckSum FROM customer WHERE NOT EXISTS (select 1 from customer_final where customer_final.CheckSum = customer.CheckSum) IF @@ROWCOUNT < @BatchSize BREAK END GO
Join the community of 500,000 technology professionals and ask your questions.