MSSQL Query Blog
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....
Seeing Object Based Authorizations in SQL Server
Hello to everyone, In this article, I will try to give information about seeing object-based privileges in SQL Server. In SQL Server, in some cases, you may want to see object-based privileges. You can easily do this using the code below. SELECT permission_name, s.name, o.name, dpr.name, o.type_desc FROM sys.database_permissions AS...
Recovery Pending Error in SQL Server
Hello everyone, In this article, I will provide information about Recovery Pending error in SQL Server. The reason for Recovery Pending error in SQL Server may be due to power outages, insufficient resources of the database server, or overloading because you did not disconnect the database connections on your software....