How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/questions/T-SQL/122451/Mon, 02 Mar 2015 07:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/122451/Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference. ]]>http://www.sqlservercentral.com/redirect/articles/96786/Wed, 06 Feb 2013 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/96786/XML index]]>http://www.sqlservercentral.com/questions/Database+Design/91551/Tue, 17 Jul 2012 06:00:00 UThttp://www.sqlservercentral.com/questions/Database+Design/91551/Stored procedure to script tables, has many optionsI needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.]]>http://www.sqlservercentral.com/scripts/T-SQL/72179/Tue, 01 Feb 2011 07:00:00 UThttp://www.sqlservercentral.com/scripts/T-SQL/72179/XML IndexChecking XML indexs with a sample.]]>http://www.sqlservercentral.com/scripts/T-SQL/63781/Fri, 19 Sep 2008 06:00:00 UThttp://www.sqlservercentral.com/scripts/T-SQL/63781/Review of SQL 2000 Fast AnswersA monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
]]>http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/Fri, 18 Apr 2003 06:00:00 UThttp://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/