Skip to content

SQL Nuggets

Nuggets Of SQL Server Knowledge

Menu
  • Home
  • Blog
  • Speaking
  • Presentations
  • Downloads
  • About

Tag: NOLOCK

NOLOCK may not be doing what you think it does

Posted on August 26, 2015December 4, 2015 by Eric Cobb

When working with developers, I’ve noticed that some have a tendency to put WITH (NOLOCK) on every table in a SELECT query. When I inquire about this, the typical response I …

Search

Subscribe via Email

Receive notifications of new posts by email.

SUBSCRIBE VIA RSS

RSS Feed RSS - Posts

Categories

  • Availability Groups
  • Azure
  • Backups
  • Career
  • Conferences
  • Corruption
  • DB Engine
  • Errors
  • Extended Events
  • Indexes
  • MongoDB
  • Monitoring
  • Open Source Projects
  • PowerShell
  • Security
  • SQL Scripts
  • SSIS
  • System Views
  • T-SQL
  • Tools

Recent Posts

  • Slides From Scenic City Summit 2018
  • Speaking At Adobe ColdFusion Summit 2018
  • Speaking At Scenic City Summit 2018
  • Using PowerShell To List Folders And Sizes
  • Notes From A SQL 2017 Azure Install – Availability Group Nodes Across Multiple Azure Regions

Top Posts

  • SQL Scripts: How To Check Logins And Permissions
  • SQL Scripts: How To Find Index Fragmentation
  • List All Foreign Keys Referencing A Table In SQL Server
  • Change The Isolation Level Of An Availability Group Database
  • Checking The Status Of Email Sent From SQL Server

Tags

Automation Azure Migration Backups Bad T-SQL Client Tools Clustered Indexes Database Mail Database Maintenance Data Files Data Storage DBCC CheckDB dev.Objective() Encryption Execution Plans Express Edition Getting Started Index Basics Internals NOLOCK Nonclustered Indexes NoSQL Performance Permissions Presentations Quickies Server Administration Speaking SQL Agent SQL Index Insight SQL Metrics Pack SQL Permissions Manager SQL Saturday SQL Sentry SQL Server 2008 R2 SSMS Storing Passwords System Procedures Top Developer Tips Trace Flags Transaction Isolation Levels Visual Studio
Copyright © 2018 SQL Nuggets – OnePress theme by FameThemes
This website uses cookies to improve your experience. To find out more see our Privacy & Cookies Policy. Accept
Privacy & Cookies Policy