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 |
|
dbhota
Starting Member
1 Post |
 Posted - 2009-12-08 : 05:24:56
|
| Dear ExpertsRequire your advices. I have a simple query as "Select FieldA from TableB". What are the ways, I can fine tune this query ?I have heard of No Lock, which ignores the locks if any has been put on Table, Record or Page Level. How does this work ?Appreciate your help.RegardsDbhDBHota |
|
|
crö
Starting Member
6 Posts |
Posted - 2009-12-11 : 01:29:39
|
quote:
Originally posted by dbhotaI have heard of No Lock, which ignores the locks if any has been put on Table, Record or Page Level. How does this work ?
Hello DBHotaUsage: SELECT fieldA FROM tableB WITH (NOLOCK) Attention: We speak of "dirty reads" when we use such a query, because it doesn't respect locks of other transitions. In my opinion it is practical for evaluation queries, that have to be merely indicative.Regards – crö. |
 |
|
|
|
|
|
Query Fine Tuning