Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Deletes takes a long time, but CPU, Disk and RAM untroubled...why ? RE: Deletes takes a long time, but CPU, Disk and RAM untroubled...why ?

  • September 25, 2013 at 5:28 am

    #1653069

    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?

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/