Viewing 15 posts - 46 through 60 (of 85 total)
Thanks for your Reply.
I understood that, I don't need to disable clustered index. Can I ask you Why?
Thanks
Bhavesh
April 9, 2014 at 7:22 am
Now My Question is ,
Do I need to disable Index while loading data from Staging to Development ?
Which index, Clustered or Nor clustered ?
April 9, 2014 at 7:21 am
Thanks For your Reply 🙂
This is production database.but I am deleting previous month records and inserting recent month record and use a copy of recent month record and move to...
August 30, 2011 at 8:11 am
Thanks for replying me,,
Rightnow I am using my database only for reporting purpose..
and Rightnow nobody using these database...
How can i shrink the Database?
Is there any effect to my Database?
Thanks
L
August 29, 2011 at 1:45 pm
Thanks for replying me.:-)
Please can you explain me detail , How can i do with SSIS?
Thanks
L
August 4, 2011 at 11:09 am
Thanks Steve,
IT's work.
Thank you so much,,:-):-)
August 2, 2011 at 9:28 am
Ok ..NInja..
Thanks..If I will not get it then I will post again .
Thanks
L:-)
July 20, 2011 at 12:33 pm
i am sorry ...
Please ignore previous no.3
this is the right one.
3. select * from acct
where as_of_date= '2011-06-30' and acct_id = 100
Output : clustered index seek
Thanks
L
July 20, 2011 at 12:31 pm
Viewing 15 posts - 46 through 60 (of 85 total)