MSSQL

What is Query Hint? You can change the execution plan of the query by adding the query hints to the end of the query. For …

In this article, we will examine what happens when we enable Optimize for ad hoc workloads and when we use parameterization. We will see what …

sp_create_plan_guide introduced with sql server 2005. With this sp, you can increase the performance of your queries that you can’t intervene or change, by adding …

Indexes can be disabled in SQL Server 2005 and later versions. If the index is disabled, it is necessary to rebuild the index to enable …

It is possible to attach the database without a log file using ATTACH_REBUILD_LOG. With the help of the following script, we attach the ASPNETDB database …

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 …

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 …

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 …

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 …

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 …