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
Weekly Summary – June 19, 2020
Here is a list of my blog posts from the last week. SQL Server Text Data – Reclaiming spaceJune 18, 2020Earlier in the week I… Read More »Weekly Summary – June 19, 2020
SQL Server Text Data – Reclaiming space
Earlier in the week I answered a question about reclaiming space, and after that post, I decided to put it into a video. Take a… Read More »SQL Server Text Data – Reclaiming space
Worst Day as a DBA
What was your worst day as a DBA? We all have ups and downs in our life, perhaps some of those bad days are the… Read More »Worst Day as a DBA
Setting text field to empty or null does not release the space used
Here is a quest that was submitted on the blog today. HelloJust have a question about a table of mineone of the columns is of… Read More »Setting text field to empty or null does not release the space used