June 2020 Blog Posts by Steve
At the beginning of June I realized that I was slightly behind on my blogging, so today, June 30th marks 30 days of 30 blog… Read More »June 2020 Blog Posts by Steve
June 2020
SQL Server Express File Size Limitation
Recently while working on a project I ran into the SQL Server Express File Size Limitation. After tracking it down I thought it would be… Read More »SQL Server Express File Size Limitation
Switching Compatibility Levels on Multiple Databases
Recently as part of an upgrade to SQL Server 2019, I needed to set the compatibility levels for a database to 150 (for 2019). You… Read More »Switching Compatibility Levels on Multiple Databases
Weekly Summary June 26, 2020
Biggest MessJune 25, 2020 As a DBA, what is the biggest problem or mess you have had to clean up in a SQL Server. If… Read More »Weekly Summary June 26, 2020
Biggest Mess
As a DBA, what is the biggest problem or mess you have had to clean up in a SQL Server. If you have been a… Read More »Biggest Mess
TempDB Sizing Question
Question submitted at SteveStedman.com: Is there any formula to calculate size of TempDB? There are some great formula’s out there for instance to calculate the… Read More »TempDB Sizing Question
Some SQL Humor
A query walks into a bar and sees two tables. He walks up to them and says ‘Can I join you?‘ One table responds… Only… Read More »Some SQL Humor
What Version of SQL Server Are You Using?
For me, I support SQL Server version from SQL Server 2000 all the way to SQL Server 2019 and Azure SQL. In a typical week… Read More »What Version of SQL Server Are You Using?
How Much Backup History is Too Much?
How much is too much when it comes to backup history. What we are talking about here is how much backup history do you want… Read More »How Much Backup History is Too Much?
Help With SQL Queries
A few times each week I get questions from people wanting help with a query. If the solution is something simple that I can see… Read More »Help With SQL Queries