What happens when we drop a column on a SQL Server table? Where's my space?
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection dialog. This post looks at this feature and how […]
Learn about Azure CLI and how to manage your Azure resources using commands instead of using the Azure portal.
In celebration of their 25th anniversary in 2024, Redgate, as the host of PASS Summit, is thrilled to introduce the PASS Summit Futures Scholarship. This initiative aims to empower the next generation of data professionals from diverse backgrounds.
Applications are open internationally to students and early-career professionals. Each of the 10 lucky winners will be awarded:
Steve has a quick turnaround between trips that was a bit unexpected. Is there compensation for this?
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy.
In the first level of the Stairway to Database Containers, we learn how to get started with Docker for Windows, downloading an image, and starting a container.
The second level of the Stairway to Database Containers looks at the basics of persisting storage in your containers.
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers