Viewing 15 posts - 16 through 30 (of 70 total)
I just want practice exam before appearing in actual exam.
April 14, 2012 at 4:33 am
We are using functions for code reuseability in some sps.
So What Should be the exact alternative of functions to make query fast. I have very long queries so dynamic...
February 29, 2012 at 9:37 pm
Follow these links to improve query performance
Hope this will help.
February 29, 2012 at 4:14 am
Thanks to reply.
We just need latest copy of our Database at target Server. We want to do this process at mid night. our DB size is 11GB and we can...
January 31, 2012 at 9:54 pm
so we need to recreate extra indexes on the reporting DB on every restore. What would happen in case if restore fail and index script run succesfully. I want to...
January 30, 2012 at 11:43 pm
Thanks Dev.
Please tell me that all this need to be done manually?. I would appreciate you if you suggest me some automated way.
Thanks.
January 30, 2012 at 11:34 pm
Thanks
One more Question in my mind. When new Database backup would be restored then, would this create problem for Indexed view or not? Because Indexed views would be recalculated...
January 30, 2012 at 3:47 am
We have Backup of 11GB and it takes alsmost 20min to restore. Please share me how to clone back up using SSIS package.
Thanks
January 29, 2012 at 10:08 pm
I have more than 272 tables in Databse and with some huge tables. Is your solution would be a better choice.
Please share me some code if poasible or Explain me...
January 25, 2012 at 11:37 pm
Thanks for your time.
Actually we have replicated DB with Transactional Replication But sometime When User print reports with current date then our data did not synchronized. At the same...
January 24, 2012 at 11:22 pm
Current User from which I logged in.
January 19, 2012 at 4:13 am
Thanks.
I just want to save my database from any user at live, In case if He would be able to reach the database then He must not be able to...
December 1, 2011 at 10:08 pm
I have created TDE from sa user and I logged in with another user with same rights. But all DB objects were looking unencrypted.
My Question is that When this...
December 1, 2011 at 12:54 am
Viewing 15 posts - 16 through 30 (of 70 total)