Below is a T-SQL statement that lets you get information about the IP-address and TCP-port number for a Microsoft SQL-server.
SELECT CONNECTIONPROPERTY('local_net_address') AS IPAddress, CONNECTIONPROPERTY('local_tcp_port') AS PortNumber;
Tag: Microsoft SQL-server
Clean cache
These commands will clear the cache from Microsoft SQL-server. It can be used during test to emulate runing a query against a “cold” server. A server where the cache hasn’t been filled with data.
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE