what is DW?
DBMS vs RDBMS
OLTP vs OLAP
SP vs Function
Temp table vs table variable
table vs view
Delete vs truncate
if i am deleting records from table having identity column using both commands, after deleting all data when we insert new record what will be value of identity column?
--->in trucate it will reset the identity column value, whereas in delete it will insert value the last identity value + seed value
where vs having
star schema vs snowflake schema
Record versioning
Fact Table
what is Dimension and Fact?
Materialised View
Isolation Levels
ACID Properties
SCD
Indexes
Normalization
CODD rule
Parent child pacckage
Can we create table in function
joins
select @@identity

how to delete duplicate records?