Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
If you have consolidated your databases, you may want to identify and remove unused databases after some time. In such a case, we need …
Read More »MSSQL
How To Identify Tables that has identity columns in a database? and what are incremental values of these identitity columns?(IDENT_INCR Function)
With the IDENT_INCR function we can find the incremental value of the identity column in a table. If there is no Identity column in …
Read More »How To Check Online Index Rebuild Progress Using Extended Events
The online rebuild feature came with SQL Server 2005 to prevent the application from being affected while rebuilding the indexes. However, according to my personal …
Read More »TRY_CAST and TRY_CONVERT Functions in SQL Server(TSQL)
We will examine TRY_CAST and TRY_CONVERT functions in this article. You can find more informartion about CAST and CONVERT functions in the article below. …
Read More »How To Identify Long Running Queries Using Extended Events
When we have a performance problem in the database, the first thing we do is to list current queries using dmws. You can find …
Read More »SET DATEFORMAT in SQL Server(TSQL)
You can specify the date format that the corresponding session accepts with “SET DATEFORMAT”. You may need this command if you want to assign …
Read More »How To Identify Long Running Queries Using SQL Server Profiler
Your queries are running slow and you want to determine which queries are running slowly. You can perform this operation by using SQL Server …
Read More »CAST and CONVERT Functions in SQL Server(TSQL)
The CAST and CONVERT functions are conversion functions. We use these functions to convert a data type to another data type. Of course, every …
Read More »Cannot drop the database because it is being used for replication
You may need to uninstall a replication that you previously installed and drop the database. You may receive an error if you want to …
Read More »How To Get the Last Generated Identity Value For a Table or View(IDENT_CURRENT Function)
The use of “Auto Increment Identitiy Column” in tables is common. In some cases, we may want to find the last Identitiy value generated. …
Read More »