MSSQL Query Blog
-
-
Viewing Table Based Index Information in SQL Server
Hello everybody, In this article, I will try to give information about displaying table-based Index information in SQL Server. In SQL Server, in some cases, you may want to display table-based Index information. You can easily do this using the code below. SELECT sys.objects.object_id, sys.objects.name AS tablename, sys.indexes.name AS indexname,...
-
-
-
Checking Index Fragmentation by Name in SQL Server
Hello to everyone, In this article, I will try to give information about Index fragmentation control by name in SQL Server. In SQL Server, in some cases, you may want to check Index fragmentation by name. You can easily do this using the code below. SELECT dbschemas.[name] as ‘Schema’, dbtables.[name]...
-
-
-
-
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....
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....