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 you find the error, how can you know the number of rows effected by last SQL statement?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table
on line cluster can we make if yes tell me the procedure
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
which database is best to use in oracle and sql server? explain reasons?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How can you see what type of locks used?
What's the difference between a primary key and a unique key?
What command do we use to rename a db?