MSSQL Query Blog
Monitoring Blocking in SQL Server
Hello to everyone, In this article, I will try to give information about monitoring blocking in SQL Server. You may want to watch blocking and waits in SQL Server in some cases. You can easily do this using the code below. SET NOCOUNT ON; GO SELECT spid, blocked, REPLACE(REPLACE(T.text, CHAR(10),...
Differences Between Stored Procedures and Functions in SQL Server
Hello to everyone, In this article, I will talk about the difference between stored procedures and functions in SQL Server. Stored procedures are sql statements that are stored by the database and do not need to be recompiled after the first compilation. Functions are sql codes that can return any...
Differences Between Cross Apply and Outer Apply in SQL Server
Hello to everyone, In this article, I will talk about the differences between Cross Apply and Outer Apply in SQL Server. In SQL Server, such questions may come up as an interview question in recruitment as a database specialist. Similar to using CROSS APPLY -> INNER JOIN. Considers the intersection...
Differences Between Temporary Table and Global Temporary Table in SQL Server
Hello to everyone, In this article, I will talk about the difference between temporary tables and global temporary tables in SQL Server. Temporary tables use the odd # sign, while global temporary tables use the double ## sign. In SQL Server, temporary tables can only be accessed from their environment....
