Select count(*)

Today I was reading(I always read Paul Randal).
http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx
I learned that whenever you query select count(*) it will select the the...

Impact of uninstall instance on replication.

Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...

Transaction Replication Backup/Restore or DR

Hi,Want to discuss on DR plan or Backup restore plan for transactional replication (here I will discuss on PUSH T...

A history lesson

Replication troubleshooting.

Hi All,Continue on Transaction replication discussion: Today I would like to share some of the  important ways of handling/troubleshooting replication...

Transaction replication info

Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...

Replication

How Log reader works- replication

Just saw the the answer by michael Hotek for how log reader works on replication: looks very great:http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d2d2e1c6-01ee-439b-93e8-e31c77c0cd28/Thanks Michael Hotek...

Replication

Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...

Data Type Synonyms

Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...