Tag: RIGHT

TSQL Script to Display Agent Job History

It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job history to find specific agent jobs that have been run. To help speed that process up,

Posted in DBA Tagged with: , , , , , , ,

SQL Server Script to Display Job History

Its not always quick and easy in SQL Server to get a full list of the jobs that have been run, when they were run and how long they took. I created the following script to quickly check on the

Posted in SQL Server, TSQL Tagged with: , , , ,

SQL Saturday Redmond

Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks. SQL Saturday

Posted in SQL Saturday Tagged with: , , , ,

FULL OUTER JOIN vs CROSS JOIN

As I have been working on the SQL Server JOIN Types poster, I have received several questions around the difference between a CROSS JOIN, and a FULL OUTER JOIN. After looking at the Venn diagrams for the two, they are

Posted in Uncategorized Tagged with: , , , ,

SQL Sunday Fun – Word Search with SQL Server Keywords

The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END EXECUTE EXIT FOR FUNCTION GRANT IDENTITY INSERT KEY NOCHECK NONCLUSTERED NULL OFFSETS OPENDATASOURCE OPENQUERY OPENROWSET

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

T-SQL DATEPART Explained

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 out as shown below. The following query uses DATEPART to extract the year from the

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