How to check the writeable copy of the database in the availability group SQL server
This scripts is useful to check before write any automation process. Writable copy of all availability group
This scripts is useful to check before write any automation process. Writable copy of all availability group
SQL Server offers an undocumented system stored procedure sp_readerrorlog.This SP allows you to read the contents of the SQL Server error log files directly from a query window and also allows you to search for certain keywords. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = …
Pagination is a process that is used to divide a large volue data into smaller data to display on the screen this process is also known as paging.This is commonly used by applications and can be seen on Google Search. Method 1 Method 2 Method 3
How to find and replace using regex in SSMS
SQL Server Management Studio is a powerful software that can help to design and development of database as well help in maintenance and administrative works too. Change Selected Database Ctrl + U: Once you are in the Sql Editor, pressing Ctrl + U selects the database dropdown in the Sql Editor toolbar. You can then …
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 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) …
Version Year Release name Code name Internal database version 1.0 (OS/2) 1989 SQL Server 1.0 (16-bit) Filipi – 1.1 (OS/2) 1990 SQL Server 1.1 (16-bit) Pietro – 4.2A (OS/2) 1992 SQL Server 4.2A (16-bit) – – 4.2B (OS/2) 1993 SQL Server 4.2B (16-bit) – – 4.21a (WinNT) 1993 SQL Server 4.21a SQLNT – 6 1995 …
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 …