August 2019

How to work with Registered Servers in SQL Server Management Studio

In SQL Server management studio their is powerful option to easily connect your server or execute query on that server To open register server window Menu -> view -> register servers Or Ctl + Alt + G We can run same query on all server using this feature Ref Link https://docs.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-2017

Still some developer use improper data type when designing database.

Storage in very important part in RDBMS that’s why Microsoft provide various data type to solve this problem. OLTP and OLAP database behave same when they processing a query. It will effect overall performance and storage. Finally it will require more infrastructure cost. Varchar vs Nvarchar: Choice for Unicode / multilingual  data If you want …

Still some developer use improper data type when designing database. Read More »

SQL Server services

SQL Server 7 Common Name Service Display Name Service Name Executable Name Distributed Transaction Coordinator (DTC) Distributed Transaction Coordinator MSDTC msdtc.exe SQL Server MSSQLServer MSSQLServer sqlservr.exe SQL Server Agent SQLServerAgent SQLServerAgent sqlagent.exe SQL Server Analysis Services MSSQLServerOLAPService MSSQLServerOLAPService msmdsrv.exe SQL Server 2000 Common Name Service Display Name Service Name Executable Name Distributed Transaction Coordinator (DTC) …

SQL Server services Read More »

Know about SQL Server edition

Enterprise Enterprise edition manage databases as large as 524 petabytes and address 12 terabytes of memory and supports 640 logical processors (CPU cores) Standard It differs from Enterprise edition in that it supports fewer active instances (number of nodes in a cluster) and does not include some high-availability functions such as hot-add memory. Its lower …

Know about SQL Server edition Read More »