MSSQL

  AlwaysOn Basic Availability Groups provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a …

  In this article I will explain some information about SQL Server System databases. System databases are created automatically when you install SQL Server. The …

  In some cases, there may not be enough space on the disks where the database files are located. For this reason, you may need …

General Concepts: First of all, the database has two files by default. These are data file with mdf extension (called Primary Data File) and transaction …

When designing a database, it is necessary to analyze the disk requirement correctly and determine the size of the disks from the beginning. Sometimes things …

  In this article, we will first talk about how to configure the file group structure when the database is first created or comes from …

  I have already mentioned how to create a linked server that will connect to Oracle in the article named “How To Create a Linked …

  When you create a linked server to connect to Oracle, you need to put an oracle user into the linked server. Before reading this …

  With the help of the following query, you can access the answers to the questions listed below. You can filter the query as you …

  Parameter Sniffing is the result of using the query plan in the cache. When a stored procedure is compiled the last time a query …