Ultimate Guide to Explore SQL Server

Attach MDF Without LDF File Icon
Stephen West | July 25th, 2017 | SQL Master Database
SQL Server uses two files to save its database – MDF files and LDF files. MDF File: MDF file is also known as a primary data file Learn More →
Reasons for Suspect Database
Daniel Jones | July 20th, 2017 | SQL, SQL Server Error
SQL Server is a database creation and manipulation tool that is built by Microsoft. It is a relational database management system that stores and retrieves data as Learn More →
fix index corruption
Daniel Jones | June 16th, 2017 | SQL, SQL Server 2016
Overview The issue started two days back, when one of my SQL Server was reported the corrupt indexes in SQL Server. We had been lurched records from Learn More →
Fix SQL Server Error 5220
Fixing SQL Error 5220 is like a biggest challenge in front of SQL Server database users. Without any doubt, there are various Relational Database Management Systems (RDBMS) Learn More →
update statistics
Stephen West | June 7th, 2017 | SQL
Nowadays, SQL server is used to maintain the database activities for professional purpose. In general, two operations like rebuilding indexes and updating statistics should be executed within Learn More →
SQL Database Error 9003
Stephen West | May 22nd, 2017 | SQL, SQL Server Error
What is SQL Server Model Database Error 9003? Model database error or the Microsoft SQL Server error 9003 is a special type of error message that appears Learn More →
sql server error 3201
As everybody knows the data recovery is an expensive and time-consuming process, therefore, taking regular backup can save lots of time. Backup helps users in restoring data Learn More →
database index optimization
Stacy Brown | February 28th, 2017 | SQL
Index in SQL Server is used to retrieve requested data speedily from database tables. There are two types of index are used in SQL server i.e. clustered Learn More →
SQL Server Transaction Isolation Level
Daniel Jones | January 19th, 2017 | SQL, SQL Transaction Log
Overview Transaction isolation level on SQL server, decides or determines that how transaction integrity is apparent to other systems and users. The locks (acquired to protect data Learn More →
hardware performance
Stephen West | January 16th, 2017 | SQL Transaction Log
Overview Microsoft SQL server is a platform where one can get their database program up and in fast running mode. The interface or layout of the server Learn More →
Useful Links

Become a Writer
Do you have flair of writing for SQL Server & other Database related Technology
We welcome the technical post from bloggers & technical writers who can contribute interesting stories about SQL Server on regular basis. If you think you are a good fit, then this SQL Server Explorer is a Platform for you. Stay in Touch with us.

Transaction Log Restore