mssqltips logo

SQL Server Constraints for Integrity and Performance

(this is an on-demand video)

Sponsored by - IDERA

Webcast Abstract

Constraints aren't exciting, are they? They seem so basic, so fundamental that we tend to forget about the value they add.

The goal of this presentation is to get you thinking about the use of constraints, starting with the basics of making sure the data in a single table is reasonably constrained. We'll start with data types, column lengths, and nullability, then move on to discuss unique constraints, CHECK constraints, and triggers.

We'll build on these topics by looking at how to constrain relationships across tables and even databases using foreign keys, triggers, and even indexed views.

Throughout the discussion we'll also discuss the overhead versus the benefits of constraints in terms of performance and the challenge of balancing that with raw performance. We'll wrap up with a list of things you might want to check after the webinar and as many questions as time permits.

Speaker - Andy Warren

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.




More SQL Server Solutions












download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools