how many non clustered index in sql server 2008,2010,2012
Answer Posted / dilipkumar
there are 1 clustered index and...
in 2008 sql server total 249 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What are the differences between triggers and stored procedures?
Can the query output be sorted by multiple columns in ms sql server?
What are the authentication modes in sql server? How can it be changed?
What is exclusive locks?
What is a cursor, index in sql?
Do you know the cursor types?
How except clause is differs from not in clause?
what are the different types of SSRS reports?
Explain time data type in sal server 2008?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Describe the functionalities that views support.
explain extended properties
Explain rdbms?
Explain the commands in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?