5 min read 0 MSSQL Shrinking the Large Log File in SQL Server OTI 10 October 2019 Scenario We recently came across a situation where one of the drives in the production server is almost full. There…
2 min read 0 MSSQL Find the database file growth for all the databases in SQL Server OTI 7 October 2019 Introduction Find the database file growth for all the databases. It is not a good practice to keep your database…
2 min read 2 MSSQL Database-Level Roles in SQL Server OTI 7 October 2019 Introduction There are two types of database-level roles: Fixed-database roles db_accessadmin Granted: ALTER ANY USER, CREATE SCHEMA,Granted with Grant option…
2 min read 1 MSSQL How to get all statistics information for a database in SQL Server OTI 4 October 2019 Introduction: Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics…
2 min read 0 MSSQL Table backup in SQL Server OTI 4 October 2019 Introduction Here we will discuss different backup strategies and methodologies used to take the table backup in SQL Server with…
3 min read 1 MSSQL Step By Step Installation Of Microsoft SQL Server 2016 OTI 3 October 2019 Introduction In this post, we will try to show step by step Microsoft SQL Server 2016 installation on Windows Server…
6 min read 0 MSSQL Database Backup & Restore in SQL server OTI 2 October 2019 Introduction Backing up a database is one of the most important things you need to do when having a database…
3 min read 0 MSSQL List of jobs associated with database in SQL Server OTI 30 September 2019 Introduction As a Database Administrator (DBA), my recent task involved listing all the jobs running in a production SQL Server…
3 min read 1 MSSQL Find Database size in SQL Server OTI 30 September 2019 Introduction In this article, we will try to pull all sizes from SQL server. How to find Database Size in…
1 min read 0 MSSQL SQL Instance Last restart date and time in SQL Server Soyeluddin Biswas 29 September 2019 Introduction: When your SQL instance was last restarted? I understand it is very simple script but we often forget simple…