Priyanka Archive
Introduction In the database, we may encounter numerous errors. Some of the reasons are, syntax is not correct for definition of the ‘%ls’ problem, a ‘SELECT’ statement that assigns a value to a variable is combined with data-retrieval operations, “ORDER-BY” …
Introduction: In SQL Server, users can perform multiple tasks with their databases like CRUD Operations, backup, update installation and etc. Sometimes there are also unknown errors that occur in the database. One of those errors is called error number 5120. …
Introduction (DBCC CHECKDB Command): In this article, I am going to tell you how you can check the database issues or value issues in your database using the DBCC CHECKDB WITH DATA_PURITY and then I will show you how to …
Another day of THE DBA chronicles is upon us. This time we are faced with the error 5170 that caused a database integrity maintenance plan to fail. Luckily, we set up logging for the plan and a look at the …
Introduction In this new article, we are going to learn different ways to solve the error 8921 in SQL Server. When you receive an error 8921, the message box pops-up: Msg 8921, level 16, state 1, line 1 “CHECKTABLE terminated. …
In SQL Server, indexes are created automatically by defining the ‘Primary Key’ and ‘Unique Constraints’ on the table columns. When a primary key is configured, the database engine sets a clustered index, and when a table is created with unique …
Introduction It was a sunny day and relaxing DBA day. I was sitting at my desk listening Nirvana music. Everything around was fine when suddenly I saw my colleague Pamela crying. Pamela was a DBA in charge of the marketing …
SQL databases typically contain two types of data files, i.e. primary and secondary data file. The primary data (or .mdf) file is the beginning of your database and has links to other files in the database. All data files in …
Generally, any hidden corruption in the SQL database drags down your performance significantly and makes the database more sluggish and unresponsive. In the worst scenarios, you may not be able to perform any operation on the database. This situation usually …
During the startup of SQL Server, a process called database recovery occurs for every database residing on the instance which includes system databases as well. In a scenario where for multiple reasons the recovery process fails, the SQL Server would …
