MSSQL

First of all, this is an old technology. Many of people use 64 bit operating systems. So there is no need to configure awe. But some of people may use …

CLR is a feature introduced with SQL Server 2005. Using the CLR (Common Language Runtime), you can perform a number of complex processes that you cannot do with TSQL using …

In the article named “Can Not Switch The Partition On SQL Server“, we mentioned that all indexes in the partitioned table should be aligned according to partition schema in order …

Sometimes the transaction log file may grow more than normal for some reasons. For example when the transaction logs are not backed up. In the following articles you can find …

Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about indexes. I explained in the …

Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about indexes. If there is no …

Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about indexes. If you have queries …

Find a Column Name in Whole Database Sometimes you may want to search for a column name in whole database. Instead of looking all the columns of all the tables …

In particular, if you are using Always On Availability Group and you haven’t included some of your databases to an always on availability groups, in some cases you may need …

One of the first steps a good database administrator should take when looking at a database system is to find and remove unused indexes and tables in databases. Before you …