What's Newhttp://sup.live.com/WhatsNew/RAFeed.aspx?cid=645e3fc14d5130f2&mkt=en-USWindows Live2009-11-13T16:11:15.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!596Vinay added a blog entry Microsoft Release end dates:<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!596.entry">Microsoft Release end dates:</a>"I realize that we all should know when the support of Microsoft sql server will expire. we should have this information handy. hence want to keep it in my Blog...."2009-11-13T16:11:15.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!595Vinay added a blog entry Comparison Microsoft Sql Server with other DBMS/RDBMS<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!595.entry">Comparison Microsoft Sql Server with other DBMS/RDBMS</a>"Today I was just thinking about to know what is the difference between sql server vs.. other DBMS/RDBMS. so thought of documenting this.searched on net and foun..."2009-11-04T21:53:51.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!594Vinay added a blog entry Consider this while doing any UPDATE<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!594.entry">Consider this while doing any UPDATE</a>"Trigger: When you create trigger for insert and delete we will get two reference table as “inserted” and “deleted” respectively now what if we create a trigger ..."2009-10-30T19:52:24.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!592Vinay added a blog entry Replication Setup:<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!592.entry">Replication Setup:</a>"  I saw too many questions on forum asking step by step process of configuring replication I have these links in my favorites so though consolidating it. For Sq..."2009-10-28T19:38:38.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!180Vinay added a blog entry Transaction isolation level<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!180.entry">Transaction isolation level</a>"Transaction isolation level:
 
1. Uncommitted Read (NoLock)
2. Committed Read (blocking)
3. Repeatable Read (phantom)
4. Snapshot  (no blocking)
5. Serializable..."2009-10-28T19:13:25.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!591Vinay added a blog entry Tricks and issues Part 1<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!591.entry">Tricks and issues Part 1</a>"Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see the comments on his Blog. G..."2009-10-23T20:51:03.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!590Vinay added a blog entry Some useful commands and sp I use for Transaction Replication:<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!590.entry">Some useful commands and sp I use for Transaction Replication:</a>"I write several blog  about replication and mansion commands and stored procedure related to transaction replication, but I would like to dedicate one blog (ser..."2009-10-23T17:01:30.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!589Vinay added a blog entry Logins no longer exists.<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!589.entry">Logins no longer exists.</a>"Today while checking the logins, just want to clear/clean logins, which are no longer, exists on NT domain. To get the logins which are no longer exits run the..."2009-10-22T15:55:55.0000000Ztag:www.live.com,2008-08:/whatsnew/6262816084389404/0/!!d6f4ca5821b4fad2!645e3fc14d5130f2Vinay joined Alan's network<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> joined <a href="http://cid-d6f4ca5821b4fad2.profile.live.com/">Alan</a>'s network2009-10-21T15:58:42.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!588Vinay added a blog entry Table Variable and Temp Table<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!588.entry">Table Variable and Temp Table</a>"  Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I would like to keep this blog as my refe..."2009-10-16T16:28:49.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!587Vinay added a blog entry Network backup Access via Query Analyzer<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!587.entry">Network backup Access via Query Analyzer</a>"Hi, Today while working on query analyzer found very interesting thing about security. My sql server A is running with service account which is same as service ..."2009-10-14T14:56:29.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!586Vinay added a blog entry Blogging<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!586.entry">Blogging</a>"Hi, Yesterday while talking to my friend, he reviewed my blog and suggested that I was having so many spelling issues in my blog... so was working from morning..."2009-10-13T20:29:44.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!249Vinay added a blog entry reindex and update stats.<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!249.entry">reindex and update stats.</a>"today was reading blog by ben nevarez it is great... (I am impressed with ben now a days) thats why Kalen always ask him for reviewing his book (all INSIDE book..."2009-10-09T20:32:18.0000000Ztag:www.live.com,2008-08:/whatsnew/6192451635166736/0/645E3FC14D5130F2!243Vinay added items to Other then Sql Server.<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added items to <a href="http://cid-645e3fc14d5130f2.profile.live.com/lists/cns!645E3FC14D5130F2!243/">Other then Sql Server.</a><ul><li>Very important Deaming... Sleeping.</li><li>spending time with dearest Baby (family).</li><li>Walking</li><li>Movies</li><li>Music</li></ul>2009-10-09T15:41:40.0000000Ztag:www.live.com,2008-08:/whatsnew/6192451635166736/9/645E3FC14D5130F2!242Vinay added a movie to Other then Sql server.....I like <a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a movie to <a href="http://cid-645e3fc14d5130f2.profile.live.com/lists/cns!645E3FC14D5130F2!236/">Other then Sql server.....I like </a><a href="http://cid-645e3fc14d5130f2.profile.live.com/lists/cns!645E3FC14D5130F2!236/">and very important Sleeping...</a>2009-10-09T15:39:27.0000000Ztag:www.live.com,2008-08:/whatsnew/6192451635166736/0/645E3FC14D5130F2!108Vinay added items to sql server<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added items to <a href="http://cid-645e3fc14d5130f2.profile.live.com/lists/cns!645E3FC14D5130F2!108/">sql server</a><ul><li>twitter</li><li>sqlblog</li><li>Microsoft</li><li>Vinay</li></ul>2009-10-09T15:34:46.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!231Vinay added a blog entry Select count(*)<a href="http://cid-645e3fc14d5130f2.profile.live.com/">Vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!231.entry">Select count(*)</a>" 
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..."2009-10-09T14:15:26.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!229vinay added a blog entry Unstall Instance<a href="http://cid-645e3fc14d5130f2.profile.live.com/">vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!229.entry">Unstall Instance</a>"Hi,
 
Today While playing with replication and instance and DR stategy. Found very interested thing.so though to blog that.
 
I have 6 instance on my box(yeah i..."2009-09-29T16:16:08.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!228vinay added a blog entry Transaction Replication Backup/Restore or DR<a href="http://cid-645e3fc14d5130f2.profile.live.com/">vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!228.entry">Transaction Replication Backup/Restore or DR</a>"Hi,
 
Want to discuss on DR plan or Backup restore plan for transactional replicaiton (here I will discuss on PUSH T replication).
 
Distribution database plays..."2009-09-14T20:53:40.0000000Ztag:www.live.com,2008-08:/whatsnew/6403544982806810/0/645E3FC14D5130F2!226vinay added a blog entry Replicaiton troubleshotting.<a href="http://cid-645e3fc14d5130f2.profile.live.com/">vinay</a> added a blog entry <a href="http://cid-645e3fc14d5130f2.spaces.live.com/blog/cns!645E3FC14D5130F2!226.entry">Replicaiton troubleshotting.</a>"Hi All,
Continue on Transaction replication discussion:
Today I would like to share some of the  imporant ways of handling/troubleshooting replication issues w..."2009-09-08T20:40:25.0000000Z