MSSQL

With OPENROWSET, you can access remote data using OLE DB. OPENROWSET is a system function as you will see below. With this method, we provide …

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 …