Latest Q

1. If there is one Publisher and 4 Subscribers..in case of Pull subscription how many distributor agent/s and log reader agent will be created and on what side. And what would be in case of Push subscription?

2.In a log shipping if I want users to be created on a secondary server(database is read_only), how will you achieve that.?

3.In a log shipping if in a primary database , 3 datafiles are added, would there be any impact on the setup? if yes, how to fix it?

4. In Replicaion. I have 100 transaction 50 transactions are replicated from publisher to subscriber.Remaining 50 transactions are not replicated.What is The Reason.How to replicate Them.?

6. Is it possible configure mirroring b/w 2008 and 2008R2?

Yes, it is possible to establish a mirroring session between 2008 and R2, as long as the R2 acts as a mirror. however if that ever fails over then the new principal is 2008 R2 and the mirroring will go suspended and you won't be able to resume without upgrading.... 

11.  After executing the Select and update statement how it will execute ??

Execution plan for Select * query.................
Syntax Check>>Authentication(validation, user authentication)>>ASCI2nd (# code check if no has code ) >>hash code generate >>Binary (compilation code genrated)>>Query tree( Query execution plan genrated)>>user process>> buffer pool> > # bucket > >Disk >>Data file (data pages)>>Data kept in buffer pool>> Result to user ......................................................this is how sql server works internaly for select query 

12.  Can we have multiple editions of a sql server on a same server....???

Production server will utilize more ram and resources if u install more than 1 sql server lack of resources may cause stop working of instances.
not recommendable but it is possible.

13. 1. When i tried to start from sql server configuration manager its giving error as -

The request failed or the services did not respond in timely fashion. Consult the event log or the other application error logs for details.

2. When i tried to start from services.msc its given error as -

The SQL server Agent service on Local computer started and the stoped. Some services stoped automatically if they are not in use by other services or program.

Note : On process on starting from above both way , my Sql agent is online (green colour) in ssms ,once process will complete and failed with above, agent will again off.

-disabled client protocol VIA service. and restarted - its work now

14. Inserting ten thousand rows faster or updating ten thousand rows faster? And why?

Inserting is Faster , Bcos Insert does add a extra rows to the Data Page where as Update will remove the existing value and Insert the Updated Value.

16.