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.
2024-04-26
2,548 reads
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-04-26
2,548 reads
This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...
I recently graduated with a Master’s in Strategic Communication from the University of Delaware....
By Steve Jones
Recently I was trying to delete a folder and kept getting the “something is...
Comments posted to this topic are about the item Adding Hints with Query Store
Comments posted to this topic are about the item PostgreSQL UNION, INTERCEPT & EXCEPT...
Comments posted to this topic are about the item Life in a Startup
I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes
See possible answers