Skip to content
Born SQL

Primary Menu

  • Home
    • About
    • Contact Us
  • Hire me!
    • SQL Server Performance and Health Check (dbSnitch)
    • Upgrade Wizard
    • Disaster Recovery
    • 2-Day Tune-Up
    • DBA
    • Speaking
  • Resources
    • SQL 2000: Duplicate Index Finder
    • Database Backup Sync and Restore
    • Max Server Memory Matrix
    • SQL to Excel Exporter tool
    • Blog series links
  • Blog
  • IT documentation

Day: February 14, 2018

Why nested views are bad

Posted on 14 February 201813 February 2018 by randolph

Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you have a SELECT statement you tend to use all over the place (a very common practice when checking user permissions). There are five base tables in the join, but it’s fast enough. Instead of copying
-> Continue reading Why nested views are bad

Tagged design, nested views, Performance, T-SQL 3 Comments

Posts navigation

Randolph West

Randolph West

Randolph West (they/them) is a Microsoft Data Platform MVP, and has worked with SQL Server since the late 1990s. When not consulting, you can see them acting on the stage and screen, or doing voices for independent video games. Also available for mentoring, talks on SQL Server and technology in general, Randolph offers training for junior DBAs. Connect with Randolph on Twitter. Buy their books on Amazon.

View Full Profile →

Recent Posts

  • Welcome to the Azure Data Community, empowered by Microsoft
  • Calgary Data User Group – 24 February 2021 at 5pm MST
  • How does the buffer pool handle low memory conditions?
  • Professionalism in the age of COVID-19
  • T-SQL Tuesday Retrospective #010: Indexes
  • T-SQL Tuesday Retrospective #009: Beach Time
  • It’s 2021, so why are you reading this?
  • A blog post about writing blog posts
  • Security update for all supported versions of SQL Server (CVE-2021-1636)
  • T-SQL Tuesday Retrospective #008: Gettin’ Schooled

Follow @BornSQL on Twitter

Follow @_randolph_west on Twitter

Randolph West

Archives

Popular Tags

Azure Azure SQL Database Backup Backups Beginner Careers Cloud Community Compatibility Configuration Corruption Data Recovery data types date datetime datetime2 Development DevOps Disaster Recovery Fundamentals Internals Linux Maintenance Max Server Memory Migration PASS Summit Performance Recovery Security SQLNewBlogger SQL PASS SQLSaturday SQL Server SQL Server 2000 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server on Linux Storage Engine T-SQL T-SQL Tuesday Temporal Tables time tsql2sday Upgrade
Calgary, Canada
info@bornsql.ca
+1-587-997-4845
  • Twitter link
  • Linkedin link

Copyright © Born SQL, a 1690406 Alberta Ltd company

This site uses cookies: Find out more.