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 ««12

Deletes takes a long time, but CPU, Disk and RAM untroubled...why ? Expand / Collapse
Posted Wednesday, September 25, 2013 5:28 AM

Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, July 29, 2015 12:19 AM
Points: 711, Visits: 1,212
greg.bull (9/24/2013)

3) How could it be being blocked, I wonder ?

If you have FK keys referencing this table then there are chances that you can experience blocking.

what is the value of maximum degree of parallelism defined?

SQL Server DBA | MCSE SQL Server 2012/2014
Post #1498263
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse