what is normalization?
what is denormalization?
Answer Posted / chethan sy
Normalization is a process of removing redundancy from the
tables.
De-normalization is introducing redundancy.
| Is This Answer Correct ? | 41 Yes | 6 No |
Post New Answer View All Answers
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Define indexes?
What is user-defined multi-statement table-valued function?
How to list all triggers in the database with sys.triggers in ms sql server?
What are the aggregate and scalar functions?
What are different types of join?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
what protocol both networks use? : Sql server database administration
What is isnull() operator?
What is the Control Flow in SSIS
What is unpivot?
Where are full-text indexes stored?
What is indexing and its types?
Explain how you can deploy an SSRS report?
query processing