My blog has informational reads/picks of various genres starting from minute inspirational/motivational reads to technical TitBits related to my play with T-SQL[SQL Server]/CLR Stored Procedures, LINQ With SQL, VSTS DBPro, and BDC feature of MOSS 2007. http://www.sqlcommunity.com/Resources/SQLServerBlogs/tabid/70/BlogId/7/language/en-US/Default.aspx en-US sirishak@microsoft.com sqlgurus@sqlcommunity.com Tue, 06 Jan 2009 06:08:10 GMT Tue, 06 Jan 2009 06:08:10 GMT http://backend.userland.com/rss Blog RSS Generator Version 3.4.0.39853 <div style="margin: 0in 0in 10pt"><span style="font-size: 12pt; color: #1f497d; line-height: 115%">Row Constructors are a relief to single ton manual inserts. They definitely help boost the efficiency of I-Transactions (INSERT).</span></div> <div style="margin: 0in 0in 10pt"><span style="font-size: 12pt; color: #1f497d; line-height: 115%">If you really want to second my statement <img alt="" src="/Providers/HtmlEditorProviders/Fck/FCKeditor/editor/images/smiley/msn/teeth_smile.gif" />… then I bet you should have a quick look at the case study below. </span></div> http://www.sqlcommunity.com/Resources/SQLServerBlogs/tabid/70/EntryID/23/language/en-US/Default.aspx sirishak@microsoft.com http://www.sqlcommunity.com/Resources/SQLServerBlogs/tabid/70/EntryID/23/language/en-US/Default.aspx#Comments http://www.sqlcommunity.com/Default.aspx?tabid=70&EntryID=23 Sun, 11 May 2008 18:41:00 GMT 0 http://www.sqlcommunity.com/DesktopModules/Blog/Trackback.aspx?id=23 <div style="margin: 0in 0in 10pt"><span style="color: #1f497d">Dependency Tracking in SQL Server 2008 is an aspect that helps users (SQL Developer/DBA) to track all the underlying dependencies or references of a given DB Object with minimum effort.</span></div> <div style="margin: 0in 0in 10pt"><span style="color: #1f497d">SQL Server 2008 facilitates some really cool utilities that are used to:</span></div> <div style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; line-height: normal"><span style="color: #1f497d">§&#160;</span><span style="color: #1f497d">Track both schema-bound and non-schema-bound dependencies.</span></div> <div style="margin: 0in 0in 0pt 0.5in; text-indent: -0.25in; line-height: normal"><span style="color: #1f497d">§&#160;</span><span style="color: #1f497d">Trac http://www.sqlcommunity.com/Resources/SQLServerBlogs/tabid/70/EntryID/22/language/en-US/Default.aspx sirishak@microsoft.com http://www.sqlcommunity.com/Resources/SQLServerBlogs/tabid/70/EntryID/22/language/en-US/Default.aspx#Comments http://www.sqlcommunity.com/Default.aspx?tabid=70&EntryID=22 Sat, 03 May 2008 14:24:00 GMT 0 http://www.sqlcommunity.com/DesktopModules/Blog/Trackback.aspx?id=22