|
Comments
|
|
too fast and the script is too small to read.
|
|
|
good, quick demo.. good tip
|
|
|
http://blog.sqlauthority.com/2009/03/24/sql-server-2008-scope_identity-bug-with-multi-processor-parallel-plan-and-solution/
|
|
|
an excellent reminder
|
|
Martin Miller on
2/11/2010
Thanks Andy.
-Martin
|
|
|
very nice. well put together and brief
|
|
|
Really a great presentation. Thanks a lot.
|
|
|
Important for auditing!
|
|
Roman Yusfin on
2/11/2010
Excellent, concise video - a little more contrast/clarity to the code text.
|
|
|
good
|
|
Kamen Angelov on
2/11/2010
Ok, but in trigger on delete must use DELETED table.
|
|
|
very good
|
|
|
forgot to state the difference between @@Identity and SCope_Identity. could have talked little slower
|
|
|
Can we have difference between @@Identity and SCope_Identity?
|
|
|
Great tip
|
|
|
I can't read the screen very well--the same complaint that seems to come up regularly here, yet the videos continue to be made in the same size font.
|
|
|
That was quite fast , would have better if the pace was a bit slow while he was explaining the thnigs
|
|
|
great demo! But, content text so small to watch. Need zoom in action for text clarity. Thanks,
|
|
|
Clear succint explanation, thanks.
|
|
|
I wich you explained where @@identity can be an issue.
|
|
|
I do not have enough experience to judge the quality of informations given but my gut tells me this is excellent. When I put the video full screen, everything is blurry, like if the resolution was not big enough, but it doesn't make it impossible to watch
|
|
|
Thanks - great stuff continues into the new year
|
|
|
Good vid.
|
|
|
Huge! I use @@IDENTITY all over the place.
|
|
|
Great!
|
|
|
couldn't see due to font size
|
|
|
Video quality was not really as good.
|
|
|
Would have liked to have seen what @@identity would have returned.
|
|
|
Good refresher
|
|
|
Good tip, Andy.
But it would have been nice to see the Identity issue demonstrated as well.
|
|
|
Need to explain better why scope_identity is better than @@identity. Demonstrate the issue with the old way and the how the new way avoids it.
|
|
|
Any chance of improving the picture quality? Whenever you expand to full screen the picture becomes blurry. Thanks!
|
|
|
It would be better If I started with the scope Identity video
|
|
|
You should list prerequisite videos. I'm nowhere near this level of fluency in SQL and would like to view videos that lead up to triggers and what now. Is there a db od beginner videos for dummies I can watch?
|
|
|
good tip. also just watching running sql is so helpful while learning.
|
|
|
It would have been nice for you to show the problem using the @@IDENTIY after you added the Trigger to the table and that it would have returned the improper identity value.
|
|
|
great video
|
|
|
That was very informative.
|
|
|
bounced around to fast and talked to fast.
|