Menu

SQL Server
T-SQL
DBA
Azure
Tutorials
Scripts
T-SQLpowered
Metamodel

Get instance TCP port

9. 3. 2018

USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc' 
GO

74

Share:

Switch database to single user mode

Rebuilding all indexes in database and statistics update

Most popular
- SQL Server
  
  Scalar Functions and Parallel Execution Plans
  27. 1. 2021
- BI
  
  Extracting Metadata from the Power BI Report File
  19. 12. 2020
- T-SQL
  
  Using Binary Hash as an Alternate Record Key
  17. 12. 2020
- Azure
  
  Run your first U-SQL script in Azure Data Lake (step-by-step tutorial)
  21. 10. 2019
Tags

administation C# constraints databases data types date & time DDL development DML errors Excel functions hierarchy indexes internals JSON MDS MERGE performance Power BI procedures replications security SELECT sequences sessions SSRS tables tools triggers TRY&CATCH U-SQL views XE XML

SQL Server
T-SQL
DBA
Azure
Tutorials
Scripts
T-SQLpowered
Metamodel

@ SQLpowered.com 2020