SQL Server 2008 and 2008R2 End of Life – coming soon
Microsoft has announced that as of July 2019 SQL Server 2008 and SQL Server 2008R2 will be at the end of life support. What does… Read More »SQL Server 2008 and 2008R2 End of Life – coming soon
SQL 2008
T-SQL: A Simple Example Using a Cursor
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
Installing Sample Databases for SQL Server 2008R2
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
DATEFROMPARTS function in TSQL
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
Using a CTE to Split a String Into Rows with Line Numbers
Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String… Read More »Using a CTE to Split a String Into Rows with Line Numbers
How BIG is too BIG for a BIGINT IDENTITY?
After writing a recent blog post on Are you wasting half the capacity of IDENTITY, I started thinking about how much is too big for an… Read More »How BIG is too BIG for a BIGINT IDENTITY?
SQL Server 2008 – Filtered Indexes
SQL Server 2008 introduces a new feature called Filtered Index. A filtered index is a way of adding a WHERE clause to the index definition… Read More »SQL Server 2008 – Filtered Indexes