Tag: T-SQL

Here Jen explains what a stored procedure is, and how to create a basic one with no parameters. She also compares it with other Continue reading “What is a Stored Procedure”

Knowing how and when to use Insert Into or Select Into can quite often make or break your load process. Here I show you Continue reading “Insert Into vs. Select Into”

Sometimes you need to get info on objects you’ve created. Here you can see how you can query for this info, and even learn Continue reading “Querying Dev Metadata”

There’s a step you can make in your code to improve it many times over. It’s an easy step to take, but it can Continue reading “Best Habit for Coders”

Here I talk about UNION and UNION ALL, and the different rules about using ORDER BY, GROUP BY, SELECT INTO, and INSERT INTO with a Continue reading “UNION and UNION ALL”

Here I get on my cert soapbox again. I was going through a practice cert exam and came across an answer to a question Continue reading “Designing Efficient Functions”

Here we discuss relational division, the counterpart to relational multiplication (cross joins). We’ll hit a couple of examples, using subqueries to implement two different Continue reading “Relational Division”

Here’s a quick talk on relational multiplication that gets us to take a closer look at what our joins are really doing.

Here I show you how to set SSMS up to work with Team Foundation Server

Follow Jen as she steps you through 3 progressively elegant solutions for finding the last day of the month.

Here Jen and I go over grouping sets the only way we can. I hope you guys enjoy us late at night.

Show how to use OVER and PARTITION BY to get groups of data with aggregation.

Here we work our way through a coding scenario—inserting rows—that should illustrate the process of solving a problem from the simplest case to your intended Continue reading “Insert Non-duplicate Rows”

Here I show you how to setup source control in SSMS and who should and shouldn’t use it.

Dirty tricks are the little tricks we use that aren’t official, may not be “proper”, but are insanely useful. Today we look at script building Continue reading “Dirty Tricks: Text Manipulation”

Here’s one of my dirty tricks: getting a list of folders or files from a command prompt, and formatting it for use in code using Continue reading “Dirty Tricks 2: Get List From Command Line”

Here’s a ground level intro to grouping, with a lovely 80s arcade theme. This is a reshoot of the original Grouping Basics video (now Continue reading “TSQL: Grouping Basics”

Here’s an intro to case statements, in the form of a conversation with Sean. I cover simple case and searched case, and the special Continue reading “T-SQL: CASE Statement”

I’m actually excited to be able to bring you this video because this is a topic that comes up quite often in DBA circles. Continue reading “Sending HTML SQL Emails”

Here I show you a couple methods for getting around really hard to read dynamic SQL.

This video shows you how to use the Identity() function to create an identity column on the fly during a select into statement. You don’t Continue reading “Select Into with Identity()”