|
Comments
|
|
Thorough
|
|
Martin Miller on
2/17/2010
Thanks Andy.
-Martin
|
|
|
again concise and effective
|
|
|
Great video!
|
|
|
I'd always heard that Truncate didn't log; I'm glad you cleared up that urban myth! Thanks! Some of the caveats were new to me as well. This was an excellent video; just the right speed, and good clear information.
|
|
Peter Phipps on
2/17/2010
In SQL 2005 the truncate permission could not be delagated i.e. you needed to be a dbo to perform the operation. Is this still the case in 2008. If so this would be good to add to the demonstration.
|
|
|
caveats were especially helpful !
|
|
|
nice side effect points
|
|
|
One other very important caveat is permissions. Unlike DELETE, TRUNCATE is considered a DDL statement, so you must have at least ALTER TABLE permissions.
|
|
|
Thanks. I use truncate often but didn't know about the identity reset.
|
|
|
How can I get the sample SQL used during the video?
rfonner@wrbmag.com
|
|
Paul Sprunger on
2/18/2010
Thanks Andy. Great job.
|
|
|
Easy to follow - would have been helpful to have the code to run while pausing the video to get a more hands on feel.
|
|
|
I love these videos! They are quick and give valuable information step by step. I would consider myself an intermediate level of experience with SQL and many of these topics show me things that I haven't used before. Great job!
|
|
|
Some thnig I do quite often, but didn't fully understand the outlined caveats... many thanks
|
|
|
First time using this site and I like it.
|
|
|
very good video, covered a lot in short time. very clear and easy to follow. i've used truncate for a while and i learned some additional things from this video.
|
|
|
Fantastic information.
|
|
Emine Dekkar on
2/19/2010
rollback works with Trucate :) !!! wow did not know that!
|
|
|
Might be useful to note the permissions you need for Truncate Table.
|
|
|
Nicely put together !! Thanks
|
|
|
Very organized and scripted out so it was easy to follow and flowed well.
|
|
Irshad Malik on
2/22/2010
Great to know all the caveats...Nice
|
|
|
Good video to give valuable information on truncate
|
|
|
And I did think Truncate wasn't logged, so it dispelled that myth for me !
|
|
|
Truncate table can be delegated in 2005 and 2008. It's very important to remember that truncate table requires dbo / ddl admin rights, which is extremely high level of permissions to give to a user or an application / etl id. I have an example here of how to delegate.
http://www.lifeasbob.com/2010/02/22/GrantTruncateTablePermissionsrevisited.aspx
|
|
|
Good examples. Clear, consise, to the point.
|
|
|
well done at explaining and showing the differences
|
|
|
Wow, I always thought 'truncate' did NOT log! Learned something new.
|
|
|
very informative and concise
|
|
|
pretty clear, thank you
|
|
abdul samath on
5/30/2010
super
|
|
|
Video quality is not very clear please
|