SQL Server SELECT

SELECT [tips tricks and commentary] FROM [my experiences] WHERE subject IN ('database', 'data warehouse', 'business intelligence')

Showing posts with label Referential Integrity. Show all posts
Showing posts with label Referential Integrity. Show all posts
Wednesday, June 16, 2010

Unique Constraint or Unique Index?

›
A few things to keep in mind when deciding whether you want a unique index or constraint. 1) The index creation options other than FILLFAC...
Sunday, February 28, 2010

Clustered Index Doesn't Have to be the Primary Key

›
Believe it or not, you don’t have to cluster your primary keys. Most SQL Server mortals assume that their primary keys should be clustered...
Wednesday, January 6, 2010

Should Foreign Key Columns be Indexed?

›
People seem to be confused when it comes to indexing of foreign key columns. For one, I believe some people assume that when you create a fo...
›
Home
View web version

About Me

My photo
d.elish
Everywhere & Nowhere in My Airstream Trailer
Delivering bulletproof, data-centric software solutions to organizations such as Disney, PwC, Cymer, Boston Scientific, the Pittsburgh Steelers, Blue Cross Blue Shield of Massachusetts, Irving Oil, Bain Capital, LoJack, PETCO, and State Street Bank for over 14 years. Driven by a passion for problem solving, technology, and profitability.
View my complete profile
Powered by Blogger.