SQL102

SQL102

World Backup Day

This past Saturday was World Backup Day, It's not an actual government recognized holiday, but as a DBA you should start celebrating it. Maybe celebrate isn't

SQL102

Foreign Keys and Witchcraft

I've worked with hundreds databases in my career. I could probably design a handful of them from memory if asked. I have notes to remind me of lessons learned

Posted in: Microsoft SQL

SQL 102-SELECT * Overhead

How many of you have heard me rant against using "SELECT * FROM tableName"? If you have I'm sure you've heard me mention the following reasons why SELECT * is

SQL102

Referential Integrity

OK, I've talked about Primary Keys and Foreign Keys. Now let's talk about Referential Integrity. Basically this just means that any Foreign Key value in one

t-sql

SQL 102 – Indexes With Included Columns

I've shown you how to create indexes, CLUSTERED versus NONCLUSTERED indexes, today I want to build on that. Let's say you have a lookup query that takes names,

dev

SQL 102 – UNIQUE INDEX

Ok, you understand how to create an INDEX. You understand the differences in CLUSTERED and NONCLUSTERED indexes. Did you know you could index a view? You can.

t-sql

SQL 102 – CLUSTERED vs. NONCLUSTERED Indexes

Previously, I covered the basics of creating an index using CREATE INDEX. Today, I'm going to dig a little deeper. I'd like to teach you the difference in an

SQL102

Nesting an Exception

Like just about every other technique in Microsoft SQL you can nest your exception handling. The basic template is: BEGIN TRY BEGIN TRY -- Nested try

SQL102

DDL Triggers

Introduction OK, we all know that when we create objects in a database, we're using Data Definition Language (DDL) commands. Every time we create an object,

SQL102

Triggers Overview

OK, What do you know about triggers? Did you know you can use them to run a bit of T-SQL on data changes? Those would be called Data Manipulation Language

microsoft sql

DELETE Triggers

This is the last of my three posts on triggers. We've already covered INSERT and UPDATE TRIGGERS. This time we're doing DELETE triggers. All the same rules

SQL102

UPDATE Triggers

Last time we discussed triggers, we covered insert triggers. This time we're doing UPDATE triggers. All the same rules apply to UPDATE triggers that apply to