That is correct but how it will do?

Say in our case TestTable if we update DeptID of any user then the actual data page of clustered index will be...

GilaMonster (9/25/2012)

---

The transaction log records aren't committed to data pages. The data modification is made to the data pages (in memory) and then logged into the transaction log. The only...

However, a log backup might be unnecessary, if the database has just been created and no log backup has been taken yet, or if the recovery model has just been...

What is the base line for that? If my table is having few millions of records (ex: 20 millions) then what is best approach.

Obviously we have to create index...

That means, with out Transaction log (Only with the Full Backup) the log shipping and Mirroring will not work.

I could have try but i need to get the confirmation form...

Thank you,

I have read in blogs/books that, when we are setting up mirroring/Log shipping we have to take the both Full backup&Transactional backup and restore them to the secondary server...

Jason-299789 (8/9/2012)

---

I'm guessing that ProductID column is an INT data type?

So the first query is doing an implicit data conversion to INT ("CONVERT_IMPLICIT(int,[@1],0)") on the value, as 1 could be...

Thank you all (GilaMonster), for your answers.

GilaMonster (8/1/2012)

---

Yes, all pages are 8kb in size.

Limitation probably to keep the size of the index tree down. Wouldn't make any sense to have 8kb index key, the index tree...

That means only we have to use in Oralce not in SQL Server?

if yes, why we have this option in sql server?

Hi Gail,

i have posted one more topic on indexes on that same day.

I believe you know very well,

http://www.sqlservercentral.com/Forums/Topic1336331-391-1.aspx%5B/url%5D

can you explain the things please.

Thank you,

I am not able to understand your point. can you explain little more?

Do you have any references on this?

Thanks,

please find attached execution plan files.

Please let me know the reason.

I followed the same steps, but that is also giving the same result,

what i have attached is, i have taken print screen of the ssms window after executing the...

Thank you,

But, for your information i have only created NON Clustered index not clustered index.

If you observe the attached images, i have mentioned the index definition/query/execution plans.

1.Unique Index only...