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 …
Read More »
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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »