updating 1,000 records takes 5-6 minutes I would like to decrease the time that takes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Strategies » updating 1,000 records takes 5-6 minutes I...

25 posts, Page 3 of 3

«««1 2 3

updating 1,000 records takes 5-6 minutes I would like to decrease the time that takes

Rate Topic

Display Mode

Topic Options

Author

Message

itsmeman

Posted Tuesday, January 19, 2010 7:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, January 27, 2011 9:06 AM
Points: 25, Visits: 64

Very good advice. I love this site and the books offered for free have helped my knowledge tremendously. Dissecting SQL Execution Plans.... Perfect for tuning SQL.

Post #849709

David.Poole

Posted Thursday, March 18, 2010 2:35 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:35 AM
Points: 2,749, Visits: 1,407

And I thought I was hard done by because a 1.5 million record update took 15 seconds!

LinkedIn Profile

Post #885911

SQLRNNR

Posted Thursday, March 18, 2010 2:54 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

itsmeman (1/19/2010)

Very good advice. I love this site and the books offered for free have helped my knowledge tremendously. Dissecting SQL Execution Plans.... Perfect for tuning SQL.

Can we get those items that Gail and Lynn requested?

Execution Plans (actual)
DDL
DML

It will really improve the ability to provide you with some tuning help.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #885927

Ion Freeman

Posted Tuesday, June 01, 2010 3:18 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 8:38 AM
Points: 55, Visits: 122

itsmeman (1/5/2010)

what advice would you all have to not using cursors if you
have sensitive data that needs to be checked to maintain its integrity?

I believe that SQL 2000 had a technology called 'Foreign Keys' to enforce something it called 'referential integrity.' Check constraints, triggers and even data types were available back then.

Post #931002

PaulB-TheOneAndOnly

Posted Saturday, June 05, 2010 1:31 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 2,984, Visits: 4,403

Ion Freeman (6/1/2010)

itsmeman (1/5/2010)

what advice would you all have to not using cursors if you
have sensitive data that needs to be checked to maintain its integrity?

I believe that SQL 2000 had a technology called 'Foreign Keys' to enforce something it called 'referential integrity.' Check constraints, triggers and even data types were available back then.

Back then? w00t

Let me break some news for you. FK "technology" can be traced back in time much closer to the big bang than SS2000. You are correct, there is something -we crazy people- call "referential integrity" BigGrin

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Post #933177

« Prev Topic | Next Topic »

25 posts, Page 3 of 3

«««1 2 3

Permissions