Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-04-19 : 14:41:45
|
| If I am the only person acessing a db, and I want to improve the performance on a select * from the table, will a table lock do that?Any what about a big INSERT? Can you put a table lock on an insert to improve performance? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-19 : 15:08:20
|
| 1. Let SQL Server manage all of your locks.2. Big INSERT? Use BCP or minimaly logged operation like SELECT * INTO newTable FROM myTable99 +3. Best way to improve performance is indexes+ Don't use SELECT *, list out the columnsMOOBrett8-) |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-04-19 : 15:12:50
|
| 2a. BULK INSERT may be something to look into as well.Everything Brett said above was dead on, as usual.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Table Lock