How many partitions a clustered index has by default in sql server 2012?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  


What do you understand by triggers?

0 Answers  


Explain optimistic and pessimistic concurrency?

0 Answers  


What is catalog views?

0 Answers  


Which index created when Create Index on table(col), Why

2 Answers   CGI,






What is 2nf normalization?

0 Answers  


how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,


How to create logins using windows Authentication mode?

2 Answers  


Which sql server is best?

0 Answers  


What is use of dbcc commands?

0 Answers  


Simple example for difference between select and cursor in sql

1 Answers  


How to use old values to define new values in update statements in ms sql server?

0 Answers  


Categories