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 »
MSSQL
How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG
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 »
Remove Memory Limit with AWE (Address Windowing Extensions) in SQL Server
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 »
What is CLR and How to import dll in sql server
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 »
How To Create Unique Index On Partitioned Tables in SQL Server
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 »
Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit
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 »
Create Index On the GROUP BY Column
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 »
Create Index on the Order By Column(ASC,DESC)
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 »
Create Index On Join Columns
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 »
How To Find a Column or a Word in Whole Database in SQL Server
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 »