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 |
|
karthick.amace
Starting Member
23 Posts |
 Posted - 2011-05-06 : 01:21:02
|
| Hi all SQL geeks I have question regarding the Transaction on views. If the view is under deadlock what will happen for the Underlying table. That also under deadlock victim.------------------------------------------------------"Desire makes what you wants to do" |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-06 : 05:25:46
|
| Lock would be always on base table and NOT the view--------------------------http://connectsql.blogspot.com/ |
 |
|
|
karthick.amace
Starting Member
23 Posts |
Posted - 2011-05-06 : 07:50:39
|
| I thought to avert block on table to use the Viewscan anybody give the solution to avoid the lock on table------------------------------------------------------"Desire makes what you wants to do" |
|
|
|
s.chyna
Starting Member
2 Posts |
Posted - 2011-05-07 : 03:53:26
|
| i have a problem withh yhe query the below query generate monthly report i want to exclude sundays frm, that. how can i do it.s.singh |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-07 : 04:33:01
|
| Avoid locks or minimise the time they are taken for? For the latter, optimise the queries. For the former, consider snapshot isolation. Just be aware of the impact on tempdb.--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-07 : 04:33:41
|
quote:
Originally posted by s.chyna
i have a problem withh yhe query the below query generate monthly report i want to exclude sundays frm, that. how can i do it.
Please post new questions in a new thread.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Transaction on views