Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

Read Uncommitted, locks, and transactions Expand / Collapse
Author
Message
Posted Friday, February 24, 2012 8:06 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 28, 2015 3:16 AM
Points: 955, Visits: 1,512
Straightforward question and highly detailed explanations!

Thank you.


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
Post #1257444
Posted Monday, May 7, 2012 12:49 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 6, 2014 11:42 AM
Points: 59, Visits: 197
Good question, it's actually the same scenario I am facing right now!!!
But I still have some questions:
#1 - I am using a partitioned view to union two tables, one is original table, one is backup table. So every time I will need to backup original table to backup table, and use partitioned view to union them then will return the same result as i query only original table.
#2 - Then I will delete from original table and then insert all new data. While I am performing this step, eventhough I use with (nolock) on my partitioned view with select statement, it will still be locked until the insert process is done, the same behavior like Truncate.

Am I doing something wrong here?
Post #1296043
Posted Tuesday, May 8, 2012 3:16 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 12, 2015 6:11 PM
Points: 5,467, Visits: 7,659
princa (5/7/2012)
Good question, it's actually the same scenario I am facing right now!!!
But I still have some questions:
#1 - I am using a partitioned view to union two tables, one is original table, one is backup table. So every time I will need to backup original table to backup table, and use partitioned view to union them then will return the same result as i query only original table.
#2 - Then I will delete from original table and then insert all new data. While I am performing this step, eventhough I use with (nolock) on my partitioned view with select statement, it will still be locked until the insert process is done, the same behavior like Truncate.

Am I doing something wrong here?


Whats the wait_type on the spid doing the select? I'd have to reconstruct the scenario to confirm. Also, what version is the server?



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1296782
Posted Thursday, October 11, 2012 1:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 21, 2015 12:59 AM
Points: 2,030, Visits: 2,535
just a wild guess n get +1 for that :)


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1371252
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse