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 posts in the month of June. Some other big blogging months were March 2015 and …
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 posts in the month of June. Some other big blogging months were March 2015 and …
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 worth documenting here for the next time someone needs this. Microsoft SQL Server 2005 Express …
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 could certainly do this by clicking through the configuration dialogs for each database as shown …
Switching Compatibility Levels on Multiple Databases Read more »
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 you have been a DBA for long enough, at some point you … Latest 100 …
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 DBA for long enough, at some point you must have inherited a problem that someone …
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 max server memory setting (https://bornsql.ca/s/memory/), however calculating the size of TempDB is not that simple? …
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 if you are willing to commit.
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 I work on everything in between SQL Server 2000, SQL Server 2005, SQL Server 2008, …
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 to keep, backup sizes, what file was written, etc. It is nice to keep as …
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 right away without spending much time then I will suggest the solution. Frequently it turns …