What is the difference between migration and upgradation in sql server?

1140

How optimize sql query with multiple joins in sql server?

958

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1057

What is the maximum size per database for sql server express?

1106

What is the difference between ddl,dml and dcl commands?

1162

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?

2169

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1037

When a primary key constraint is included in a table, what other constraints does this imply?

1029

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?

1149

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1154

what is denormalization? : Sql server database administration

975

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1255

Can we create clustered index on composite key?

1176

What is the purpose of the tempdb database?

1050

What are the common performance issues in sql server?

976