Do you know what is fill factor and pad index?

947

Do you know what is openxml in sql server?

1024

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

970

Are semicolons required at the end of sql statements in sql server 2005?

939

What is an expensive query?

891

What is save transaction and save point?

1135

What are the main differences between #temp tables and @table variables and which one is preferred?

1022

What is the difference between a function and a stored procedure?

1021

What is the default value of an integer data type in sql server 2005?

917

How can we improve performance by using SQL Server profiler?

994

What is the usage of sign function?

1046

What are the advantages of partitioning?

1056

What are the differences between left join and inner join in sql server?

1050

How to execute stored procedure and set temp table in sql server?

1002

Explain logical operators in sql server?

1044