http://blogs.technet.com/b/sqlpfeil/en-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/sqlpfeil/archive/2012/07/14/four-tips-for-sql-tuning-for-sharepoint-part-3-tempdb.aspx#3555601Thu, 28 Feb 2013 16:32:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3555601Emmanuel ISSALY<p>Excellent series for non DBA like me, a lot of infos i suspected but couldn&#39;t find in one place. Now, where&#39;s part 4? :)</p> <p>I also got a question i have difficulty with : Given large DBs (say 5To+), do you keep dumping sql backups to local drives, then saving to network? or do you dump directly to the SAN (with the prospect of saturating network and I/O of the information system if you do a full backup)</p> <p>Thanks!</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3555601" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2012/12/12/the-case-of-the-unexplained-how-we-can-get-different-execution-plans-and-result-sets-for-same-query.aspx#3547172Mon, 21 Jan 2013 16:37:15 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3547172Ahsan Kabir<p>Nice article</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3547172" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2013/01/14/how-to-avoid-text-to-date-conversion-mismatches.aspx#3547163Mon, 21 Jan 2013 16:31:22 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3547163Ahsan Kabir<p>Excellent post. Thanks!</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3547163" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2013/01/21/check-your-sql-default-trace.aspx#3547161Mon, 21 Jan 2013 16:29:44 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3547161Ahsan Kabir<p>Excellent post. Thanks!</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3547161" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2013/01/14/how-to-avoid-text-to-date-conversion-mismatches.aspx#3546239Wed, 16 Jan 2013 12:51:40 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3546239Madhivanan<p>You can find more information on using unambiguous date formats in this post <a rel="nofollow" target="_new" href="http://beyondrelational.com/modules/2/blogs/70/posts/10898/understanding-datetime-column-part-ii.aspx">beyondrelational.com/.../understanding-datetime-column-part-ii.aspx</a></p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3546239" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2012/12/12/the-case-of-the-unexplained-how-we-can-get-different-execution-plans-and-result-sets-for-same-query.aspx#3540891Fri, 14 Dec 2012 15:17:10 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3540891Yossi <p>Thanks for this helpful info,</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3540891" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2012/11/11/sql-server-2012-new-feature-the-snippets.aspx#3533072Sat, 17 Nov 2012 07:38:19 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3533072Oren Bouni<p>You&#39;re Welcome</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3533072" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2012/11/11/sql-server-2012-new-feature-the-snippets.aspx#3532836Thu, 15 Nov 2012 23:55:11 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3532836The Thinker<p>snippets are very helpful! I love them! </p> <p>thanks for the post</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3532836" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2012/09/04/user-defined-server-roles-new-server-option-in-sql-server-2012.aspx#3517858Tue, 04 Sep 2012 10:39:43 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3517858Livio von Büren<p>Nice information!</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3517858" width="1" height="1">http://blogs.technet.com/b/sqlpfeil/archive/2012/05/21/network-bind-order-warning-during-sql-server-installation-at-failover-cluster.aspx#3499087Mon, 21 May 2012 16:25:33 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3499087Jeffrey S. Patton<p>Nice little utility, and love the last sentence! I know when I roll through an installation pre-check I try to turn all the reds and yellows to green, that way I don&#39;t lose sleep later!</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3499087" width="1" height="1">