Query to get list of Schema and table name in Azure SQL database
The query below lists all tables in an Azure SQL Database. Columns Rows Sample results Mohammad Gufran Jahangir
How to Get SQL Server database transaction log usage?
What is transaction log in SQL Server? In SQL Server, the transaction log is a crucial component of the database that records all changes made to the…
What is SQL Server Statistics and how to Collect/Update Statistics in SQL Server Database.
In Azure SQL Server, statistics are database objects that contain information about the distribution of data in one or more columns of a table or indexed view….
Query session status runnable, sleeping, suspended, running and background meanings in SQL server Database
In SQL Server, when you query the session status, you can encounter various states that provide information about what a session is currently doing. Here are some…
Troubleshooting Connectivity issues & Timeout error [258]. Unable to complete login process due to delay in prelogin response/ Pre-Login Handshake Failed
If trying to connect Azure SQL Server database and getting below Error: Error Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Timeout error [258]….
How to Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS)
To Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS) Step 1 : Create user logon from master database where ‘abc’ is…
What is fragmentation in Azure SQL Server? How to check fragmentation for table? How to rebuilt table to reduce fragmentation?
What is fragmentation in Azure SQL server? Fragmentation in Azure SQL Server, or any SQL Server, refers to the condition where the data pages of a database…