A Shot of SQLEspresso

SQL Blogs by Monica Morehouse (Rathbun)

  • Home
  • Session Downloads
  • Event Calendar
  • PASS
    • Hampton Roads SQL User Group
    • SQL Saturday
    • PASS WIT VC
  • DCAC
  • Contact Me
    • Disclaimer
  • Home
  • Session Downloads
  • Event Calendar
  • PASS
    • Hampton Roads SQL User Group
    • SQL Saturday
    • PASS WIT VC
  • DCAC
  • Contact Me
    • Disclaimer

No Widgets found in the Sidebar Alt!

SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL

read more

Wait… Could This Be the End of Index Maintenance?

read more

SQL Server Is Still Here and Microsoft Is Still Investing in It

read more

Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant

read more

Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain

read more
Link 1
Azure Cloud Chronicles with Microsoft MVPs
Link 2
Data Exposed YouTube
Link 3
Paul Randals -SQL Server Wait Statistics Library
Link 4
Glenn Berry'd SQL Server Performance DMVs
Link 5
sp_whoisactive Download
  • Back to Basics,  Problems & Solutions

    Resizing Tempdb (When TEMPDB Wont Shrink)

    September 9, 2020 /

    Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of whack. To resize we have three options, restart the SQL Server Service, add additional files, or shrink the current file. We most likely have all been faced with run away log files and in an emergency situation restarting the SQL Services may not be an option but we still need to get our log file size smaller before we run out of disk space for example. The process of shrinking down that file can get tricky so I created this flow…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Memory Optimized Tables in SQL Server

    January 8, 2020

    Sorting in Stored Procedures – Food for Thought

    January 29, 2020

    Summit Submission Feedback Response

    June 28, 2016
  • Azure,  Performance Tuning

    Adaptive Joins in SQL Server

    September 2, 2020 /

    SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box with no code changes to implement. One of those features introduced was Adaptive Joins. In this feature the join operator is dynamically determined at runtime by the optimizer, which defines a threshold number of rows and then chooses between a Nested Loop or Hash Match join operator. This operator switch can produce a better join and improve performance of your queries without you having to lift a finger. Not all queries will qualify for this new feature. The feature only applies…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Synchronous VS Asynchronous Statistics Updates

    October 25, 2017

    QUICK & DIRTY: Table name change for all stored procedures

    December 10, 2015

    Hide and Group Columns in SSRS Using a Parameter

    December 9, 2016
  • Azure

    Change Azure SQL Database Service Level Objectives in SSMS

    August 28, 2020 /

    Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place. Lucky for me I discovered the other day that I can change my Azure SQL Database Service Level Object options within SQL Server Management Studio (SSMS) without ever having to go to the Azure Portal. By right clicking on your database properties and choosing the Configure SQL page you can change your Subscription and Azure Location. Even more and what is really cool is I can also scale up and down my Edition (which is generally referred to as Service Tier outside of SSMS), Size and Storage Tiers as well.…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Understanding Columnstore Indexes in SQL Server Part 1

    June 26, 2019

    Attending Summit as a New Leader

    November 6, 2015

    Why I Go to Summit Each Year?

    October 11, 2017
  • Azure

    Caution When Dropping Unused Indexes on an Azure SQL Database

    August 12, 2020 /

    Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your database. Cleaning up unused indexes can save a lot of overhead on Insert/Update/Delete operations. To achieve that goal, I typically run a script like the one shown below and check out whether or not an index has had any seeks or scans against it as a starting point in my cleanup regiment. SELECT d.name,        OBJECT_NAME(i.[object_id]) AS [ObjectName],        i.[name] AS [IndexName],        s.user_seeks,        s.user_scans FROM sys.indexes AS i     LEFT OUTER JOIN sys.dm_db_index_usage_stats AS s         ON i.[object_id] =…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    SQL Index Creation Using DROP EXISTING= ON

    February 17, 2021

    Being a Woman in the SQL Community

    February 26, 2020

    Back up Encryption for SQL Server

    September 5, 2018
  • Azure

    What is Azure SQL Database Serverless?

    July 1, 2020 /

    What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform, is my database just floating in the air? No, I am not really thinking that, but still the word serverless can be hard to understand. So, let’s walk through what it is. Serverless is a term commonly used for function as a service patterns like Amazon Lambda, or Azure Functions, where you have a piece of code that is called and executed without you deploying any infrastructure. Azure Logic Apps are another version of this—a program that exists to do a…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Ruh-Roh! SQL Server 2025 Finally Brings Us a Free Standard Developer Edition – Scooby Dooing Episode 2

    August 28, 2025

    Are My SQL Server Indexes Being Used?

    August 28, 2019

    November #SQLChat – How to Build your Name Recognition and SQL Network

    November 12, 2015
  • Uncategorized

    Open Letter to PASS

    June 19, 2020 /

    As you know, I spoke to 12 Chapter Leaders and 4 Regional Mentors yesterday. All are very upset with PASS right now and feel slighted, which as a volunteer myself, I empathize. I have given the feedback, to you. After talking with them here is where the problem lies IMHO: communication and transparency. We received an email taking away our token of appreciation PASS gives us for all our yearlong hard work that helps to build and amplify this community. In the email we also were asked to please promote and encourage Summit registrations among other things. You cannot take something away and then turn around and ask the leaders…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    What is Automatic Tuning in Azure SQL Database

    August 28, 2018

    So How Did It Go?

    September 28, 2015

    Understanding Columnstore Indexes in SQL Server Part 3

    July 17, 2019
  • Performance Tuning

    What is Batch Mode on Rowstore in SQL Server?

    June 16, 2020 /

    Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There is no action needed to turn on batch mode aside from being on the proper compatibility mode. You also have the ability to enable it as a database scoped configuration option (as shown below), and you can hint individual queries to either use or not use batch mode (also shown below). If you recall in my earlier blogs on columnstore, it is batch mode in conjunction with page compression that drastically increases query performance. This feature, Batch Mode on Rowstore, allows…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Please Don’t Do This! Default Index Fill Factor

    September 6, 2017

    In Memory Table Indexes

    January 22, 2020

    SQL Server Vulnerability Assessment

    December 12, 2018
  • SQL Family

    My Thoughts on PASS Virtual Summit – An Editorial

    June 11, 2020 /

    On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server community. Many events are moving to a virtual platform as well as being able to offer them at no costs to all attendees. PASS though, is a different kind of “company” for lack of a better word. We are a community of people that built this “company” from the ground up. Due to normal day to day commitments, like jobs, most of us do not have time to run the day to day operations of the “company” and we rely on…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    New Resumable Online Index Create SQL Server 2019

    November 28, 2018

    Free Training 24HOP

    April 18, 2018

    Trouble Shooting Little Jewel -Windows PSR (Problem Steps Recorder)

    March 29, 2017
  • Speaking

    The New Public Speaking

    April 29, 2020 /

    The need to transition to virtual speaking engagements is not easy for me. As someone who loves public speaking and delivering in person training, not being able to do so right now is very difficult. I struggle with staring at my screen talking to my camera as a teaching mechanism. I get asked all the time to speak at virtual user group meeting and online conferences but usually kindly decline. Now that virtual events are our only avenue to speak, I am forcing myself out of my comfort zone and trying a few on for size. There are a several reasons why this is not my first choice in delivering…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Please Don’t Do This! Default Index Fill Factor

    September 6, 2017

    Why I Go to Summit Each Year?

    October 11, 2017

    How Your Hypervisor Can Impact Your CPU

    March 6, 2019
  • Performance Tuning

    Coding Standards Gone Bad in SQL Server

    April 21, 2020 /

    Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I spend much of my day’s performance tuning code. In doing so, I get to see many ways code can introduce excess database reads. One of the most recent things I have come across has to do with NULLs. The environment I was working in had no default values in their table design, so it was riddled with NULL values. Over the years they had implemented coding standards to try and mitigate these NULL values within their code. In every column search…

    Read More
    Monica Morehouse (Rathbun)

    Related Posts

    Attending Summit as a New Leader

    November 6, 2015

    Install ALL Things SQL Server… What?

    November 26, 2019

    Template Explorer Gold Mine in SQL Server Management Studio

    March 27, 2018
23456

About Me

Monica Morehouse (Rathbun)

Microsoft MVP, Performancing Tuning Expert, Leader Hampton Roads SQL Server User Group, Read More…

Consulting

Sessions List

Favorite Tidbits

  • Reminder to Developers

Topic Categories

  • Azure
  • Back to Basics
  • Configurations
  • Data Masking
  • DevOps
  • Encryption
  • Idera Ace
  • Important Links
  • Indexes
  • Lone DBA
  • Misc
  • MVP
  • New SQL Version
  • Performance Tuning
  • Posts with Scripts
  • Problems & Solutions
  • Quick and Dirty
  • Security
  • Speaking
  • SQL Family
  • SQLSaturday
  • SSRS
  • Summit
  • Training
  • TSQL Tuesday
  • Uncategorized

Top Posts & Pages

  • Understanding Columnstore Indexes in SQL Server Part 2
    Understanding Columnstore Indexes in SQL Server Part 2
  • Wait… Could This Be the End of Index Maintenance?
    Wait… Could This Be the End of Index Maintenance?
  • Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox
    Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox
  • Scheduling things to Run in SQL Server
    Scheduling things to Run in SQL Server
  • Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
    Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
  • SQL Server Statistics Health Reminder
    SQL Server Statistics Health Reminder
  • Simple-Talk Article...Understanding Azure Storage Options
    Simple-Talk Article...Understanding Azure Storage Options
  • Memory Optimizer Advisor
    Memory Optimizer Advisor
  • Hmmm... What’s This? Date Correlation Optimization in SQL Server
    Hmmm... What’s This? Date Correlation Optimization in SQL Server
  • Adaptive Joins in SQL Server
    Adaptive Joins in SQL Server
Graceful Pro Theme by Optima Themes - 2026 ©
Loading Comments...