Skip to content

Data Adventures with an Architect

  • Facebook
  • Twitter
  • GitHub
  • LinkedIn
  • RSS Feed
  • YouTube

Strate SQL

  • Home
  • About
  • Publications
  • Reference Material
    • Wait Statistics
    • 10 Monthly Maintenance Tasks for SQL Server
    • Plan Cache
    • Free Tools for the Data Platform Professional
    • SSIS Resources
    • Security Resources
  • Contact
  • SQL Karaoke

Tag: Locking

The Side Effect of NOLOCK (video)

June 13, 2013 by jasonstrate, posted in Database Administration, SQL Server, SQLServerSyndication

A while back I put together a blog post on the side effect of NOLOCK.  Today I thought I'd push out a video of the issue, in hopes of reaching more people and changing more minds. What are your thoughts?

Tagged Locking, SQL Server4 Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 138 other subscribers

Recent Posts

  • SQL Server Indexing Book Giveaway – Part 7
  • SQL Server Indexing Book Giveaway – Week 6 (Index Myths)
  • SQL Server Indexing Book Giveaway – Week 5
  • SQL Server Indexing Book Giveaway – Week 4 (the late edition)
  • SQL Server Indexing Book Giveaway – Week 3

Top Posts & Pages

  • Using SELECT INTO with UNION Statements
  • 10 Monthly Maintenance Tasks for SQL Server
  • Security Questions: What permissions are required to create temporary tables?
  • Identify Reporting Services Version and Edition
  • Getting Rid of a Certificate
  • Grouping and Rounding Dates
  • Determining Filegroup for a Table
  • XQuery for the Non-Expert - Value
  • Security Questions: Difference between sysadmin and CONTROL SERVER Permission
  • XQuery for the Non-Expert - @Variable Use

Facebook

Facebook

Categories

Archives

Tags

#Meme15 #TSQL2sDay .NET 31DaysSSIS Archive Blog Series Business Intelligence Career Certification Checklist Community Community and Conference Database Administration DBADiagnostics Deadlocks DMO Extended Events Geek High Availability Holiday Index Analysis Index Black Ops Indexing Indexing for Performance List MCM Meme Microsoft Office Monthly Checklist Off Topic Parallelism PASS PASS 2011 PASSMN PASSWIT Performance Tuning Plan Cache PowerShell Presentation Professional Development Reblog Security SharePoint Social Networking Solid State Drive SQL Azure SQLIO SQLRally SQL Saturday SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQLServerSyndication SSIS SSRS StmtUseDb sys.dm_db_index_operational_stats sys.dm_db_operational_stats sys.dm_exec_cached_plans sys.dm_exec_query_plan T-SQL Thanksgiving Tip Tool Troubleshooting Virtualization Visual Studio Wait Stat Wait Type Webcast White Paper XQuery
Blog at WordPress.com.
  • Follow Following
    • Strate SQL
    • Join 138 other followers
    • Already have a WordPress.com account? Log in now.
    • Strate SQL
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar