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 April 2015, around the Database Corruption Challenge, and June 2013 with 27 posts, and May 2013 with 27 posts. I …
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 edition has a database size limit to 4GB Microsoft SQL Server 2008 Express edition has a database size limit to …
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 here, but for a server with many databases that could take some time. Here are some of the compatibility levels …
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 PostsRead More » TempDB Sizing QuestionJune 24, 2020 Question submitted at SteveStedman.com: Is there any formula to calculate size of …
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 else created, but it’s your problem to fix. I can think on several big problems, for instance one system that …
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? Consider the situation of 2 SQL Server with the same size databases, exact same hardware, the same tables, but the …
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, SQL Server 2008R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019 and Azure …
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 much as possible so that you can learn from this over time, but how much is too much depends on …
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 out that people who are asking for help with a query have some really complex queries, where it is going …