A developer must investigate volumes of data (capacity planning), what types of information will be stored, and how that data will be accessed. If you are dealing with an upgrade to an existing system, analyzing the present data and where existing data volumes occur, how that data is accessed and where the current response bottlenecks are occurring, can help you search for problem areas in the design.
A new system would require a thorough investigation of what data will be captured, and looking at volumes of data held in other formats also will aid design. Knowing your data is just as important as knowing the constituents of your data. Also, constantly revisit your design. As your system is built, check relationships, volumes of data, and indexes to ensure that the physical design is still at its optimum. Always be ready to check your system by using tools like the SQL Server Profiler.
Posted Date:- 2021-09-18 05:25:02
What are associative entities?
What is "scheduled jobs" or "scheduled tasks"?
What is business intelligence?
What are the steps you will take to improve the performance of a poor-performing query?
If you have no choice but to use a SQL Server-based cursor, what tips do you have to optimize them?
What are the authentication modes in SQL Server? How can it be changed?
What is the use of the SCOPE_IDENTITY() function?
What is the purpose of UPDATE STATISTICS?
What is Referential Integrity?
Define the one-to-one relationship while designing tables.
What is a virtual table in SQL?
Explain cross join or cartesian product in sql?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is the system function to get the current user’s user id?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is difference between foreign key and unique key?
How Global temporary tables are represented and its scope?
What is a Join? Explain Different Types of Joins
Write down the general syntax for a SELECT statement covering all the options.
What are the main steps in Data Modeling?
What part does database design have to play in the performance of a SQL Server-based application?
What is a transaction and what are ACID properties?
What is the purpose of FLOOR function?
How exceptions can be handled in SQL Server Programming?
What are user-defined data types and when you should go for them?
What are defaults? Is there a column to which a default can’t be bound?
State the difference between UNION and UNION ALL?
Explain Magic tables in SQL Server?
How exceptions can be handled in SQL Server Programming?
What are scheduled tasks in SQL Server?
What methods do you follow to protect from SQL injection attack?
What is denormalization and when would you go for it?
Explain Trigger and its types?
What is normalization? Explain different levels of normalization?
Explain Subquery and state its properties?
What is COALESCE and CHECK constraint in SQL server?
What is SQL server agent and what are the two modes of authentication in SQL Server?