Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update

Status
Not open for further replies.
youngun

youngun

Programmer
Apr 27, 2001
61
US
Simple question, I've always heard that in SQL server the update command is really slow. I am just wondering is this still the case for SQL Server 2000? Is there any trick involved to make it faster?

Thank you.
 
Sort by date Sort by votes
I've never found that statement to be true unless in comparison to a search with the same criteria. Updates can be slower if a table has many indexes or if deadlocks occur. However, with proper indexing and query tuning, SQL performance has been excellent in our situation since we started with version 4.2a. Terry
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
1K
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
1K
gmmastros
gmmastros
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
453
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Update another column if text in another exists 2
Replies
4
Views
394
Cpreston
Cpreston
Auguy
  • Locked
  • Question
Passing Table Variable to Update Table
Replies
2
Views
348
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top