SQLServerCentral.com Content tagged T-SQL, Video

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 your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

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.

Check SQL Server performance at a glance
We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

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.

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.