Read Uncommitted, locks, and transactions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Craig Farrell » Read Uncommitted, locks, and transactions

54 posts, Page 1 of 6

1 2 3 4 5 »»»

Read Uncommitted, locks, and transactions

Rate Topic

Display Mode

Topic Options

Author

Message

Evil Kraig F

Posted Sunday, February 12, 2012 7:34 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:09 PM
Points: 5,658, Visits: 6,100

Comments posted to this topic are about the item Read Uncommitted, locks, and transactions

- 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 #1250898

Koen Verbeeck

Posted Sunday, February 12, 2012 9:49 AM

SSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364, Visits: 6,462

Nice question Craig, thanks!

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1250914

Evil Kraig F

Posted Sunday, February 12, 2012 6:52 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:09 PM
Points: 5,658, Visits: 6,100

Koen Verbeeck (2/12/2012)

Nice question Craig, thanks!

Thanks. I was concerned that I wouldn't explain the components well enough. Hopefully the scenario is clear and this doesn't end up as an anti-NOLOCK discussion instead of one regarding troubleshooting the differences between DELETE and TRUNCATE.

Also kind of surprised, this wasn't supposed to be available until tomorrrw. Hehe

Post #1250974

Paul White

Posted Monday, February 13, 2012 1:37 AM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

Good question, no complaints from me Smile

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1251025

palotaiarpad

Posted Monday, February 13, 2012 1:39 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 2:20 AM
Points: 841, Visits: 317

Nice question, i learned something again.

Post #1251026

Hugo Kornelis

Posted Monday, February 13, 2012 1:46 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 5,232, Visits: 7,022

Great question. I especially liked how you explicitly included the rationale for (and dangers of) using NOLOCK.
Thanks!

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #1251030

Koen Verbeeck

Posted Monday, February 13, 2012 2:12 AM

SSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364, Visits: 6,462

Evil Kraig F (2/12/2012)

Koen Verbeeck (2/12/2012)

Nice question Craig, thanks!

It is explained well enough - at least according to me - and the MSDN article linked to also explains it all.
Your question did say the end users decided they could live with incomplete or missing data, so an anti-lock discussion is not necessary: the DBA/report developer did his job in my opinion. He informed the users about the consequences and they accepted them.

Evil Kraig F (2/12/2012)

Also kind of surprised, this wasn't supposed to be available until tomorrrw. Hehe

That's because is used DBCC_TIMEWARP to solve this question BigGrin

Ok seriously now, in the weekend questions usually appear a few hours too early.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1251042

call.copse

Posted Monday, February 13, 2012 2:42 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:33 AM
Points: 1,080, Visits: 687

I liked this question - partially at least because I could recall the answer from double checking the answer to the last truncate question.

Post #1251059

cengland0

Posted Monday, February 13, 2012 2:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

This was a good question. I like how it was written in the terms of a real problem to solve.

What other ways can you change the entire contents of a table and still have the reports available without dirty data?

I've thought of creating a view that points to the table. Then, you can populate another table with the new information and then update the view to point to the new table. Once all the queries are done running on the old dataset table, the old table can then be deleted. I've never tried this so I'm curious what the experts on this forum have to say about this. Does the view get locked if a query is running it? Any negative sides to my proposed solution?

Post #1251060

440692 I am just a number

Posted Monday, February 13, 2012 2:48 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:12 AM
Points: 1,631, Visits: 2,028

Thank you.
Great question and I really appreciate the time and effort you took in creating the scenario, rather than just posting up the code and asking what's going on.

Post #1251061

« Prev Topic | Next Topic »

54 posts, Page 1 of 6

1 2 3 4 5 »»»

Permissions