1 min read
0
Rename a Database in SQL Server
Introduction We can rename a user-defined database in SQL Server by using SQL Server Management Studio or Transact-SQL. System databases…
Category: MSSQL
5 min read
0
Shrinking the Large Log File in SQL Server
Scenario We recently came across a situation where one of the drives in the production server is almost full. There…
2 min read
0
Find the database file growth for all the databases in SQL Server
Introduction Find the database file growth for all the databases. It is not a good practice to keep your database…
2 min read
2
Database-Level Roles in SQL Server
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
How to get all statistics information for a database in SQL Server
Introduction: Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics…
2 min read
0
Table backup in SQL Server
Introduction Here we will discuss different backup strategies and methodologies used to take the table backup in SQL Server with…
3 min read
1
Step By Step Installation Of Microsoft SQL Server 2016
Introduction In this post, we will try to show step by step Microsoft SQL Server 2016 installation on Windows Server…
6 min read
0
Database Backup & Restore in SQL server
Introduction Backing up a database is one of the most important things you need to do when having a database…
3 min read
0
List of jobs associated with database in SQL Server
Introduction As a Database Administrator (DBA), my recent task involved listing all the jobs running in a production SQL Server…
3 min read
1
Find Database size in SQL Server
Introduction In this article, we will try to pull all sizes from SQL server. How to find Database Size in…