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.… Continue reading SQL 103-Designing Stored Procedures

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… Continue reading SQL103 – Designing Indexes