MSSQL

As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article “How To Create …

You can receive this error when you want to get a total result by using the SUM function. In order to avoid this error, you …

You may receive this error when you want to chage an instance level parameter by using sp_configure in SQL Server. I would recommend reading the …

                  Security is the biggest concern nowadays particularly for those who manage critical applications.Every database must have …

In this article, I will describe a few of the most known types and solutions of this error. Possible Errors Transaction Log is Full Due …

We create Indexed Views by adding indexes to views. For detailed information about the View concept, I would recommend you read my article “What is …

We can briefly define View as a virtual table that does not physically store records, and is determined by a query. So, There is no …

  Transaction count shows that how heavily the database is used. Some third-party applications can show the transaction count graphs of the databases. But each …

We can use try-catch blocks in TSQL since SQL Server 2005. In the try block; We write the TSQL code that we want to catch …

  Before reading this article, I suggest you read my article “Fixed Server Level Role in SQL Server“. Apart from the default roles on Instance, …