is it important for a database administrator to understand the operating system and file access? : Sql server administration

1073

What is clustered index

1058

What do we need queues in sql service broker?

1119

What should be the fill factor for indexes created on tables? : sql server database administration

1177

What are the difference between “where” and “having” clause in sql server?

1129

Does partitioning ssd reduce performance?

928

How to delete existing triggers using "drop trigger"?

1097

How self join is different from outer join?

1174

What are the rendering extensions of ssrs?

160

What is the difference between an index and a unique index?

1044

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1154

What are indexers?

1131

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1107

Why would you call update statistics?

1072

How to generate create table script on an existing table in ms sql server?

1191