Remove Files From tempdb
I made a mistake with a script today. I created three new tempdb files sized at 10GB each that filled up a hard drive. Whoops.
I made a mistake with a script today. I created three new tempdb files sized at 10GB each that filled up a hard drive. Whoops.
In last week’s post I discussed the basics of how automatic updates to statistics occur in SQL Server. This week I want to talk about
One of my favorite topics in SQL Server is statistics, and in my next two posts I want to cover how they are updated: either
One of the most useful logs you can review when there’s a problem in SQL Server is the ERRORLOG. It may not always be the
“You should always use trace flag X for a SQL Server install.” “Have you tried trace flag Y?” “We fixed the problem using an undocumented
This past weekend at SQLSaturday Cleveland I presented a new session related to Query Store, Ensuring Plan Stability with Query Store. I went into detail
A question came up recently about plan guides and compatibility mode, and it got me thinking about forced plans in Query Store and compatibility mode.
Cleveland peeps – we are a week away from SQLSaturday Cleveland, are you registered?! There’s still time if you’re not, AND there is still time
The crew over at Brent Ozar Unlimited is hosting this month’s T-SQL Tuesday, and the request was to find an interesting Connect item (bug fix
I was perusing the release notes for SQL Server 2014 SP2 and found this gem: Information about enabled trace flags is added to the showplan
This week I’m in Chicago for our last SQLskills Immersion Event of the year, IE0, which is one of my favorite classes to teach. Jon
This week I’ve been working with SQL Server 2016 and it’s been a lot of fun – this is truly a great release from the
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.