Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
Answer / anand vanam
•In clustered Index leaf node contains the actual data pages
where as in Non clustered index leaf node contains index
•You can have only one clustered index per table but you can
have 249 Non clustered indexes per table as per SQL 2005
(999 in SQL 2008)
•The row locator in clustered index is the Clustered Index
Key where as in Non clustered index row locator is a pointer
to the row.
|Is This Answer Correct ?||10 Yes||1 No|
how do we find every fifth record in a table
What is WITH CHECK OPTION
plz send every query in sql server2000
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are the steps you will take, if you are tasked with securing an SQL Server?
what are the new features of sql server 2005?
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What is the use of DBCC commands?
what is a stored procedure and trigger?
I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access
what are the critical issues you have resloved in your company