Skip to content

SQL Nuggets

Nuggets Of SQL Server Knowledge

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

Tag: NOLOCK

T-SQL

NOLOCK may not be doing what you think it does

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

2020 IDERA ACE
MSCE: Data Platform

SUBSCRIBE VIA RSS

RSS Feed RSS - Posts

Subscribe via Email

Receive notifications of new posts by email.

Categories

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

Recent Posts

  • PSSDIAG Error: There Is No Instance Named X
  • Disabling An Index Drops Compression
  • I Am Now A Microsoft Certified Trainer
  • Does SQL Server Now Distribute Transactions Evenly Across Multiple Log Files?
  • Setting Drive Allocation Unit Size With PowerShell

Top Posts

  • SQL Scripts: How To Find Missing Indexes
  • Performance Problem When Using OR In A JOIN
  • SQL Scripts: How To Find Index Fragmentation
  • Checking The Status Of Email Sent From SQL Server
  • SQL Scripts: List Databases A Login Can Access

Tags

Automation Azure Migration Backups Bad T-SQL Client Tools Clustered Indexes Database Mail Database Maintenance Data Files Data Storage dbatools DBCC CheckDB Encryption Execution Plans Express Edition Getting Started Index Basics Internals Log Files Music City Data 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 Training Transaction Isolation Levels Visual Studio
Copyright © 2020 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
Necessary
Always Enabled