SQLServerCentral.com Articles tagged video, T-SQL

Using the Union Statement - SQL School Video

Tue, 24 Mar 2009 06:00:00 UT

In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.

Using Intersect - SQL School Video

Tue, 17 Mar 2009 06:00:00 UT

This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.

Using Views and Synonyms for Abstraction - SQL School Video

Thu, 22 Jan 2009 07:00:00 UT

In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Generating Random Results - SQL School Video

Thu, 15 Jan 2009 07:00:00 UT

How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.

Using the CheckSum Function - SQL School Video

Thu, 18 Dec 2008 07:00:00 UT

There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.

Bypassing a Trigger - SQL School Video

Tue, 16 Dec 2008 07:00:00 UT

Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Modifying Data - SQL School Video

Tue, 30 Sep 2008 06:00:00 UT

MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.

Summarizing Data with Aggregate Queries - SQL School Video

Thu, 28 Aug 2008 06:00:00 UT

Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.