If a database is normalized by 3 NF then how many number of tables it should contain in minimum? How many minimum if 2NF and 1 NF?
• What is denormalization and when would you go for it? As the name indicates, denormalization is the reverse process of normalization. It’s the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced. • How can I randomly sort query results? To randomly order rows, or to return x number of randomly chosen rows, you can use the RAND function inside the SELECT statement. But the RAND function is resolved only once for the entire query, so every row will get same value. You can use an ORDER BY clause to sort the rows by the result from the NEWID function, as the following code shows: SELECT * FROM Northwind..Orders ORDER BY NEWID() • sp_who Provides information about current Microsoft SQL Server users and processes. The information returned can be filtered to return only those processes that are not idle.
Related Questions
- If a database is normalized by 3 NF then how many number of tables it should contain in minimum? How many minimum if 2NF and 1 NF?
- Is it possible to exclude from the delete policy some special custom tables not present in the original database schema?
- What are the minimum covers that my car insurance policy should contain in the Commonwealth of Virginia?
