What is the difference between migration and upgradation in sql server?
How optimize sql query with multiple joins in sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is the maximum size per database for sql server express?
What is the difference between ddl,dml and dcl commands?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
When a primary key constraint is included in a table, what other constraints does this imply?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
what is denormalization? : Sql server database administration
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
Can we create clustered index on composite key?
What is the purpose of the tempdb database?
What are the common performance issues in sql server?