Paresh, One of my earlier article has same kind of information :) [http://blog.extreme-advice.com/2012/10/03/calculate-table-schema-size-in-sql-server/][1] [1]: http://blog.extreme-advice.com/2012/10/03/calculate-table-schema-size-in-sql-se...

Congratulations Nakul.... :) good job.... hope to see new and more milestones in coming years.......

Forcefully remove replication publisher, subscriber and distributor in SQL Server I still remember one of my earlier post where I have mentioned how to remove replication and how to remove objects from replication. This is perfect solution for general u...

Monitor user login connected to SQL Server   SA and Windows Administrator login should be disabled in SQL Server due to security reason. I am not going to discuss those reasons in this article as there are many pro/cons and rules/regulations of som...

Performance counter is one of the biggest weapon system administrator and Database administrator can have. I have already written few things about performance counter in past article mentioned below: Performance Counter in SQL Server (Click Here) Perfor...

Add stored procedure in transactional replication by script in SQL Server I have already written many articles to cover different area of replication. Few days back I have written how to add articles (Table, View, SP etc.) into replication from GUI and ...

Add table in transactional replication from script in SQL Server I have already written many articles to cover different area of replication. Few days back I have written how to add articles (Table, View, SP etc.) into replication from GUI but today I a...

Find Object participated in replication It happens many times that we want to know the object participated in replication from publisher database. We may not have populated all database objects in replication so we might want to compare the object. Some...

Be familiar with important terms of replication in SQL Server After reading replication articles two of my regular blog reader asked me question about some terms I have used in articles. Here is their asking in question format for all blog reader. Q.1) ...

Find highest latency in transactional replication in SQL Server 2012 Replication is one of the very handy and useful high availability features SQL Server has provided. It is very easy to setup but maintaining health and keeping eye on performance of re...