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

Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites