http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8271.aspxWed, 12 May 2010 18:49:03 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8271neo0http://sqlserver.ro/forums/thread/8271.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8271Va multumesc.http://sqlserver.ro/forums/thread/8267.aspxWed, 12 May 2010 18:11:06 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8267xmldeveloper0http://sqlserver.ro/forums/thread/8267.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8267Evitati cursoarele. In situatia descrisa de dumneavoastra un ciclu while este mult mai eficient.http://sqlserver.ro/forums/thread/8257.aspxFri, 07 May 2010 16:02:42 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8257neo0http://sqlserver.ro/forums/thread/8257.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8257am zeci de milioane de inregistrari si mai multe aplicatii care ruleaza in timp real...si ma intreb care dintre variantele de stergere are planuri de executie si costuri mai eficiente pentru a nu cauza blocaj(e).http://sqlserver.ro/forums/thread/8256.aspxFri, 07 May 2010 15:58:30 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8256Diana0http://sqlserver.ro/forums/thread/8256.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8256Nu vad de ce ai avea nevoie de cursor.http://sqlserver.ro/forums/thread/8255.aspxFri, 07 May 2010 15:47:11 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8255neo0http://sqlserver.ro/forums/thread/8255.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8255Stergerea utilizand un "cursor", din pct de vedere incarcare este mai fiabila comparativ cu o stergere in bucla "while"? <br /> <br />Multumesc.http://sqlserver.ro/forums/thread/8254.aspxFri, 07 May 2010 15:41:12 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8254Diana0http://sqlserver.ro/forums/thread/8254.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8254Sterge de exemplu 1000 de inregistrari intr-un batch, Vezi <br />http://www.sqlservercentral.com/articles/T-SQL/67898/http://sqlserver.ro/forums/thread/8253.aspxFri, 07 May 2010 13:47:18 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8253neo0http://sqlserver.ro/forums/thread/8253.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8253pot sterge maxim o mie de linii o data si doar din script si nu trebuie sa utilizez nu din job.http://sqlserver.ro/forums/thread/8252.aspxFri, 07 May 2010 12:45:05 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8252katalyn0http://sqlserver.ro/forums/thread/8252.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8252pai si un simplu delete 10000 ? eventual poti face o procedura care face delete top 1000 from .... order by PK where .... si o poti executa printr-un job pe care sa-l setezi sa se execute cand "Start whenever the CPUs become idle" ... sau poti sa rulezi stergerea noaptea .... O alta idee ar fi sa folosesti resource governor daca vrei sa te complici putin.http://sqlserver.ro/forums/thread/8251.aspxFri, 07 May 2010 10:15:32 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8251neo0http://sqlserver.ro/forums/thread/8251.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8251Salut, <br /> <br />Cum as putea realiza pe un tabel o stergere recursiva controlata care sa tina cont de incarcare (spid-uri) iar daca situatia devine critica procesul sa se opresca pe parcursul stergerii (si sa si checkpointeze...sa nu faca rollback).(sql server 2005 std edition). <br />Tabelul are constrangeri, chei primare insa e vorba de niste inregistrari orfane care trebuie sterse si sunt f multe zeci de milioane. Cu un simplu "delete " mi s-ar bloca aplicatiile. <br />Multumesc