Mohammad Nazmul Huda
Search this site
About Me
Certifications
Employment History
Publications
Study Resources
Training
Technical Docs
Oracle
Managing Database
Backup and Recovery
Performance Tuning
ASM
Security
Replication
Database Change
Data Guard
Cloud Control
LISTENER
Parameters
SQL
SQL Functions
PL/SQL
ORA ERROR
12c Issues
Bugs
Scripts
Tools
OCM
Teradata
MySQL
SQL SERVER
Linux
AWS
Data Science
Other
Contact
SQL SERVER
SQL Server Authentication Mode
How to check SQL Server Authentication Mode
Implementing Buffer Pool Extension in SQL Server
Searching in query plan cache in SQL Server
Populate Large Tables with Random Data in SQL Server
How to Create database in SQL Server
How to Detach and Attach Database in SQL Server
How to Shrink Database, Data File and Log File in SQL Server
How to Take Database Offline and Bring it to online in SQL Server Database
How to Create Snapshot and Restore From Snapshot in SQL Server Database
How to Script Out Entire Database in SQL Server
How to Change a Database To Single User Mode or Multi User Mode
How to Change Compatibility Level in SQL Server
How to Rename a Database in SQL Server
How to Change Database Collation to SQL Server
How to Troubleshoot and Fix Recovery Pending Database in SQL Server
How to Find out Owner of any database in SQL Server
How to Change Ownership of a Database in SQL Server
How to Change Default Location of Datafile, Logfile and Backup in SQL Server
How to Release Unused Space of Tempdb in SQL Server
How to Update Statistics on All the database or Specific Database in SQL Server
How to Check Login Status in SQL Server
How to Enable and Disable Login in SQL Server
Error:
Error 1807 Could not obtain Exclusive lock on database ‘model’. Retry the operation later(During Create database)
Installation of Microsoft SQL Server Management Studio failed with Error 0x80070020
Comments