Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You may receive an error as follows when you want to start SQL Server Service. You need to look at the event viewer. Write …
Read More »MSSQL
Server TCP provider failed to listen on [ ‘any’
IDENT_SEED Function in SQL Server(TSQL)
IDENT_SEED function returns the value of the seed you specified when creating the identitiy column. The value returned by this function does not change …
Read More »Common Table Expression(CTE)
TSQL Developers sometimes want to use the same code block in more than one place when writing a query. Sometimes this case can complicate …
Read More »DBCC CHECKIDENT in SQL Server(TSQL)
The following operations can be performed with the DBCC CHECKIDENT command. The current identitiy value of an identity column can be found. The maximum …
Read More »Using Extended Events To Determine Whether The Database Is Being Used
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 »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 »