This is intended as a brief overview of indexing on SQL Server. Understanding and using indexes can lead to some major performance improvements. Non-Clustered Indexes… Read More »Index Overview – Clustered and Nonclustered
For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. Cursors are a feature of SQL Server… Read More »T-SQL: A Simple Example Using a Cursor
In my Common Table Expressions presentation the topic of recursion often comes up, but for scalar functions in T-SQL, it might not be as common.… Read More »Recursive Scalar Function in T-SQL
Here is a quick rundown on the T-SQL DATEPART function for SQL Server. DATEPART is used to pull a single part of a date/time element… Read More »T-SQL DATEPART Explained
As I work on testing the Database Health Reports project, I have configured several test servers running as virtual machines using Hyper-V. Part of setting… Read More »Installing Sample Databases for SQL Server 2008R2
The Database Health Reports project is going strong. Database Health Reports is a free application for monitoring the key metrics on your SQL Server. Created by… Read More »Database Health Reports Beta 5 is Going Strong
SQL Server 2012 adds a new function called DateFromParts. This new function simplifies the creating of a DATE type in TSQL over the older ways of… Read More »DATEFROMPARTS function in TSQL
SQL Server 2012 adds many new features to Transact SQL (T-SQL). One of my favorites is the Rows and Range enhancements to the over clause.… Read More »Rows and Range, Preceding and Following
The following articles are a collection of my favorite SQL Server related posts over the last 6 months. 3 Steps to Work More Efficiently in… Read More »Select Favorite SQL Server 2012 Articles
SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is… Read More »T-SQL 2012 Procedure sp_describe_first_result_set