Tag Archives: SQL103

SQL103 – Designing Triggers

We’ve finally made it to the last post in the SQL103 series.  I’ve written posts about triggers before.  I’ve shared with you how triggers can be good things and bad things.  It’s all in how you design them.  Today, I hope to teach you how you can design good triggers.  Let’s dive right in! Understand […]

Comments ( 0 )

SQL 103-Designing Stored Procedures

We’re nearing the end of the SQL103 series. We’ve designed tables, relationships, indexes and views. There’s plenty more to learn. Today we’re going to discuss designing stored procedures. When you start designing stored procedures you’re generally trying to build a wrapper around a collection of T-SQL statements that you can then hand off to developers. […]

Comments ( 0 )

SQL103 – Designing Indexes

So you’ve designed your tables, then you set up your primary and foreign keys.  You even defined views that your programmers will use to present the data to end users.  What’s next?  Well, if you want to take a proactive approach to database design, you’re going to want to start thinking about indexing. Initial Indexes […]

Comments ( 0 )