What is the basic difference between clustered and a
non-clustered index?
Answer Posted / anil sharma
clustered index one in table nad non-clustered index may be
more than one in one table.
| Is This Answer Correct ? | 27 Yes | 10 No |
Post New Answer View All Answers
How to create indexed view?
Explain throw statement in sql server 2008?
How to set database to be single_user in ms sql server?
What is table value parameters (tvp)?
What is set nocount on and what is set nocount off?
How sql server executes a statement with nested subqueries?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Explain what are page splits? : SQL Server Architecture
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Can we perform backup restore operation on tempdb? : sql server database administration
How adventureworkslt tables are related?
Explain an incremental backup?
What is the current pricing model of SQL Azure?
What is the optimization being performed in oracle and SQL Server?
Is it possible to call a stored procedure within a stored procedure?