SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance
Sometimes it is critical to get back to basics when working on solving a complex problem at Comprehensive Database Performance Health Check. Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the s …
A Beginner’s Guide to SQL String Functions
The post A Beginner’s Guide to SQL String Functions appeared first on SQLServerCentral.
SQL SERVER – Copy Database Without Statistics Query Store
I love the follow-up questions as they demonstrate that my blog posts are read and help everything think of their own environment. Here is the follow-up question I have received to my earlier blog post about Clone Database Using DBCC CLONEDATABASE. Thi …
Test data provisioning for development – free whitepaper
The post Test data provisioning for development – free whitepaper appeared first on SQLServerCentral.
Update only Year, Month or Day in a SQL Server Date
The post Update only Year, Month or Day in a SQL Server Date appeared first on SQLServerCentral.
Monitor Current Analysis Services Activity
Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any loc …
Query Store Training: SQLBits 2020
I am thrilled to announce that I will be heading back to London in spring 2020 for a day of Query Store training. The training day schedule for the SQLBits conference has been announced, and I will be presenting a full day pre-conference session …
Join Me in London for My SQLbits Pre-Con Workshop: Mastering Index Tuning
I’m teaching an all-new hands-on workshop, Mastering Index Tuning. I’m taking my favorite, toughest modules of my 3-day online class and condensing them down into a 1-day workshop. You’ll learn quick, easy techniques to use the right …
Microsoft’s Guidance on How to Set MAXDOP Has Changed
For years, SQL Server’s Maximum Degree of Parallelism (MAXDOP) – the number of cores that a parallel query could use – defaulted to 0, meaning unlimited. This led to rampant CXPACKET waits because queries went wild with parallelism. O …
SQLBits Training Day – SQL Server Performance Tuning Real-World Scenarios
I will be presenting a day-long training day (pre-con) at SQLbits on 31 March 2019 ExCel London on the topic SQL Server Performance Tuning Real-World Scenarios. This blog post is about SQLBits Training Day. SQLbits is from 31 Mar to 4 April and the ful …
All Good Things Must Come to an End
All good things must come to an end. After slightly over seven and a half great years at SQLskills, it is time for me to move on to a new adventure. My last day at SQLskills will be December 31, 2019.I have had the privilege and honor to work with a gr …
SQL SERVER – Clone Database Using DBCC CLONEDATABASE
The other day I ended up on a very interesting situation with my client while we were working with Comprehensive Database Performance Health Check. The client had a unique requirement that we can’t run any query even SELECT queries on the product …
SQL Server performance issue after an upgrade
Recently, I came across a problem where the client reported severe performance degradation of their OLAP system. Most of the reports that were running were either timing out or were returning data after a long time. The problem started right after the …
Controlling how SQL Prompt Formats your Code: The Knobs and Dials
The post Controlling how SQL Prompt Formats your Code: The Knobs and Dials appeared first on SQLServerCentral.
A Toolbox Every DBA Should Have
The post A Toolbox Every DBA Should Have appeared first on SQLServerCentral.