Viewing 15 posts - 16 through 30 (of 130 total)
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...
September 25, 2012 at 4:03 am
September 25, 2012 at 3:24 am
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...
September 17, 2012 at 6:46 am
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...
September 17, 2012 at 6:21 am
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...
September 17, 2012 at 6:19 am
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...
September 17, 2012 at 5:18 am
So the first query is doing an implicit data conversion to INT ("CONVERT_IMPLICIT(int,[@1],0)") on the value, as 1 could be...
August 9, 2012 at 5:09 am
Thank you all (GilaMonster), for your answers.
August 2, 2012 at 6:35 am
Limitation probably to keep the size of the index tree down. Wouldn't make any sense to have 8kb index key, the index tree...
August 1, 2012 at 5:14 am
That means only we have to use in Oralce not in SQL Server?
if yes, why we have this option in sql server?
July 30, 2012 at 3:55 am
i have posted one more topic on indexes on that same day.
I believe you know very well,
can you explain the things please.
July 30, 2012 at 3:19 am
I am not able to understand your point. can you explain little more?
Do you have any references on this?
July 30, 2012 at 3:17 am
please find attached execution plan files.
Please let me know the reason.
July 29, 2012 at 11:38 pm
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...
July 27, 2012 at 6:42 am
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...
July 27, 2012 at 5:36 am