Gone are the days of traditional file-based systems. With the advent of new technologies, particularly, in the database and database-related avenues, the demand for professionals adept with… Read More
Question: How can I find tables in a SQL Server database that have a Primary Key ?
Answer: To identify if a table has a Primary Key - you can use the OBJECTPROPERTY method with the pro… Read More
This article focus on suspect SQL database, a problem encountered sometimes by Database Administrators - DBAs. It is uncommon, but high chance of appearing suddenly. Database administrators… Read More
According to expert Koen Verbeeck, comprehending whatever you need from SQL Server is perhaps the most important step in successful usage in commercial applications.
Successful deploymen… Read More
We have a database here that stores information about Azure SQLDB health issues; it was chugging along fine for months, then earlier this week it started to struggle. You can see the large i… Read More
I was working with a customer to troubleshoot memory optimized table issues. In this scenario, our customer uses a memory optimized table variable. He put 1 million rows of data… Read More
SQL - Structured Query language is used to communicate with DataBase , it is the standard language for relational database management systems.As part of this course you will learn below topi… Read More
Indexes are the primary source of the databases. Terribly designed indexes is one of the major problem faced by the user. Designing it properly is the major task as it is used to achieve bes… Read More
When you need to check the health or status of all INDEXs and need to REBUILD the required INDEXs depends on the Fragmentation level (%), you can get help from below SQL queries.In my exampl… Read More
It should be commonly understood that any ERP system is built to appeal generally to a wide variety of companies. Epicor is no exception to the rule. This is a fundamental principle of… 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
1. What’s the difference between a primary key and a unique key?Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creat… Read More