Blog Archives

TSQL JOIN Types Poster (Version 4)

So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , , , , , ,

Using The TSQL EOMONTH Function

Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. The EOMONTH function returns the last day of a given

Posted in 70-461 Training, TSQL 2012 Tagged with: , , , , , ,

TSQL JOIN Types Poster (Version 3)

NOTE:: There is an updated version of the poster available now.   Version 4 is now available. So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference

Posted in TSQL Tagged with: , , , ,

Using The TSQL DATEADD Function

Here is a quick video training on how to use the T-SQL DATEADD function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the

Posted in 70-461 Training, TSQL Tagged with: , ,

Using The TSQL DATEDIFF Function

Here is a quick video training on how to use the T-SQL DATEDIFF function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the

Posted in 70-461 Training, TSQL Tagged with: , ,

Using The TSQL DATEPART Function

Here is a quick video training on how to use the T-SQL DATEPART function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the

Posted in 70-461 Training, TSQL Tagged with: , ,

Using the TSQL GetDate Function

Here is a quick video tutorial on how to use the T-SQL GetDate function on SQL Server 2012, SQL Server 2014 or newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the

Posted in 70-461 Training, TSQL Tagged with: , , , ,

The TSQL DATEPART Function

You can use the TSQL DATEPART function to extract individual parts of the date from a date or time item. For instance: Will return the following output:   The second parameter is the date/time element which can be any of

Posted in SQL Server, TSQL Tagged with:

SQL Server Join Types Poster (Version 2)

So many times I have been asked for help with a query, where the questoin really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , ,

Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD

First lets take a look at two queries using CURSORS, the first one will use the FORWARD_ONLY type cursor, and the second will use the FAST_FORWARD type cursor. These two types sound very similar, but perform quite differently. Now for

Posted in 70-461 Training, TSQL Tagged with: , , , , , , ,

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: