Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »
MSSQL
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 »
How To List Databases Not Included in the Availability Group(Standalone Databases)
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 …
Read More »
How To Find Unused Tables in SQL Server
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 …
Read More »