Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»»

TRUNCATE Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 9:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 11,194, Visits: 11,166
vk-kirov (2/10/2010)
In the example above, we will see request_mode = Sch-M (schema modification). This is specific to DDL events.

Not true. From Books Online - Lock Modes:

Some data manipulation language (DML) operations, such as table truncation, use Sch-M locks to prevent access to affected tables by concurrent operations.


So, table truncation is explicitly defined as a DML operation.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #892901
Posted Tuesday, March 30, 2010 1:42 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
Paul White NZ (3/30/2010)
vk-kirov (3/3/2010)
So, db_ddladmin can run any DDL command; db_ddladmin can run TRUNCATE TABLE. This means TRUNCATE is a DDL command, I believe

Crows are birds.
All crows are black.
Therefore, all birds are black.

Oh dear.


Impeccable logic Paul


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #893253
Posted Tuesday, March 30, 2010 1:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 11,194, Visits: 11,166
Peter Trast (3/30/2010)
Impeccable logic Paul

Given the bird theme, I suppose it should be im-peck-able logic really

(sorry)




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #893263
Posted Tuesday, March 30, 2010 1:54 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
Paul White NZ (3/30/2010)
Peter Trast (3/30/2010)
Impeccable logic Paul

Given the bird theme, I suppose it should be im-peck-able logic really

(sorry)


Booooo.... lol...


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #893268
Posted Wednesday, March 31, 2010 12:53 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
Paul White NZ (3/30/2010)
Some data manipulation language (DML) operations, such as table truncation, use Sch-M locks to prevent access to affected tables by concurrent operations.


So, table truncation is explicitly defined as a DML operation.

Nice find, thank you.

So, if it barks like a dog, it behaves like a dog, what is it?..
...it may be a duck in SQL Server
Post #893508
Posted Wednesday, March 31, 2010 1:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 11,194, Visits: 11,166
vk-kirov (3/31/2010)

Nice find, thank you. So, if it barks like a dog, it behaves like a dog, what is it?...

It is a duck, with some arguably dog-like features




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #893528
Posted Wednesday, March 31, 2010 8:08 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
Paul White NZ (3/31/2010)
vk-kirov (3/31/2010)

Nice find, thank you. So, if it barks like a dog, it behaves like a dog, what is it?...

It is a duck, with some arguably dog-like features


Interesting de-duck-tion....


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #893789
Posted Wednesday, March 31, 2010 8:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 11,194, Visits: 11,166
Peter Trast (3/31/2010)
Paul White NZ (3/31/2010)
vk-kirov (3/31/2010)

Nice find, thank you. So, if it barks like a dog, it behaves like a dog, what is it?...

It is a duck, with some arguably dog-like features

Interesting de-duck-tion....

Boooooo!




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #893810
Posted Wednesday, March 31, 2010 8:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
Paul White NZ (3/31/2010)
Peter Trast (3/31/2010)
Paul White NZ (3/31/2010)
vk-kirov (3/31/2010)

Nice find, thank you. So, if it barks like a dog, it behaves like a dog, what is it?...

It is a duck, with some arguably dog-like features

Interesting de-duck-tion....

Boooooo!


Hey, people from middle earth can't boo!


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #893837
Posted Wednesday, March 31, 2010 8:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 11,194, Visits: 11,166
Peter Trast (3/31/2010)
Hey, people from middle earth can't boo!

Middle Earth, if you please




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #893842
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse