MSSQL
Get Client and Server IP running MSSQL
SELECT client_net_address ClientIP,local_net_address ServerIP FROM sys.dm_exec_connections WHERE ...
Script Reindex All Table in Database
DECLARE @MyTable VARCHAR(255) DECLARE myCursor CURSOR FOR SELECT table_name FROM information_schema.tables ...
