|
Comments
|
|
Fantastic. I never thought to try that.
|
|
Dustin Ryan on
12/31/2008
Nice video, very informative.
|
|
Steve Harris on
12/31/2008
I did not know that you could do this. Very good tip.
|
|
Jack Corbett on
12/31/2008
I knew about the PK, but never thought of using a unique constraint.
|
|
|
I knew about adding a primary key - but I didn't know about the constraint! Definitely something to add to my bag of tricks.
|
|
|
I didn't know that!
|
|
|
I didn't know that!
|
|
|
Good tip to know.
|
|
|
able to create index on TV is cool. happy 2009.
|
|
|
When do the better query plans begin to pay back the cost of the constraints?
|
|
|
Satyabodhi, this depends on many parameters (data size, what type of queries you run, query complexity, etc.). In general if you have query predicates that utilize the underlying indexes you will see benefits. Best as always is to test with your data to see if it makes sense to use them.
|
|
|
Adding indexes to table variables will definitely come in handy.
|
|
|
Although I know this and use it a lot, it is very good. Many developers are unaware of this.
|
|
|
Straight and to the point. Could have added other index types or other constraints.
|
|
|
Ed, since you cannot run CREATE INDEX against a table variable, you cannot create other indexes. The techniques demonstrated in the video are based on the fact that PRIMARY KEY and UNIQUE KEY constraints are enforced via index.
|
|
|
Very good & Informative
|
|
|
Excellent video, never thought of using unique constraints before...
|
|
rupesh sharma on
2/16/2009
excellent video....very useful to implement this mostly i use in reporting services stored procs
|
|
|
pretty neat
|
|
|
Simple, good, conceptual and to the point. Thank you.
|
|
|
Very helpful, especially since a view of the before and after execution plans are included.
|
|
|
good
|