how many non clustered index in sql server 2008,2010,2012
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vikram
there are 1 clustered index and...
in 2005 sql server total 249 non clustered index
in 2008 sql server total 999 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 ? | 0 Yes | 0 No |
What is normalization 1nf 2nf 3nf?
How do I completely remove sql server instance?
What value could be assigned to Varchar Type?
What is store procedure? How do they work? When do you use?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
How check triggers in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the difference between upgrade and migration in sql server?
What is the most common type of join?
Can sql servers link to other servers?
What is partition, how will you implement it? : sql server analysis services, ssas
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?