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...

Rebuilding and Compiling All Views in SQL Server

Hello to everyone, In this article, I will try to give information about rebuilding and compiling all Views in SQL Server. In SQL Server you may want to rebuild and compile all Views in some cases. You can easily do this using the code below. DECLARE @SQL VARCHAR(MAX) = ”;...

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...

Listing Tables Created in the Last Month in SQL Server

Hello everyone, In this article, I will try to give information about listing the tables created in SQL Server in the last month. In SQL Server, in some cases, you may want to list the tables created within the last month. You can easily do this using the code below....

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....

Don`t copy text!