WHAT IS DBCC CHECKDB?The command DBCC stands for Database Console Command which is used to check the logical and physical integrity of all the objects in the specified database. It also chec… Read More

zack raiyan: I am using this code to check my database for errors : Dim cmd As New SqlCommand("DBCC CHECKDB (offpoDb) WITH TABLERESULTS", con) cmd.ExecuteNonQuery()But,u see, this command… Read More

SQL Server database contains different commands for different operations but half knowledge about these commands can make a huge trouble for a DBA. So always take the complete knowledge of c… Read More

Steps to Repair Suspect SQL Database in an Easy WaySQL database server is a creation and manipulation program that is developed by Microsoft. It is a relational database management system, w… Read More

Today who doesn’t know about Microsoft SQL Server. According to a report, the popularity of SQL Server grew faster than any other database product during 2016. Where SQL Serv… Read More

Microsoft SQL Server Error 3183Suppose you have a full backup (.bak file) of a SQL Server database with partitions and you want to restore the database from backup file. But while performing… Read More

SQL Server, DBA interview questionsQuestions are categorized under the following sections, for your convenience:Database design (8 questions)SQL Server architecture (12 questions)Database ad… Read More

What is RDBMS?Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained ac… Read More