In my last article - Identify Tables With Dropped Columns - we saw how we can identify tables that have columns that were dropped. Today, we are going to...
2024-08-05
9 reads
On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop...
2024-07-22 (first published: 2024-07-09)
330 reads
This article was initially posted on SQLServerCentral @ 2024-04-26.
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable.
But, most importantly - The record/table size will remain...
2024-05-29
228 reads
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some files to lower the bill.
To check my progress I needed to...
2024-05-02
135 reads
At the beginning of this week, I shared how you can Search for queries with Query Store GUI .
Today I want to share something, Query Store related, that bugged...
2024-02-16 (first published: 2024-02-01)
337 reads
Hey folks, long time no write!
Today I want to bring a tip that I use every week but I found that most SSMS users are unaware it exists.
I can...
2024-02-09 (first published: 2024-01-29)
626 reads
Who doesn’t like a good red and verbose exception? At PowerShell community we often call it a “sea of red” which we found as something that can be intimidating....
2022-06-27 (first published: 2022-06-07)
356 reads
Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...
2022-06-13 (first published: 2022-06-02)
287 reads
Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just...
2021-12-29
10 reads
This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it's simple to...
2020-09-22
26 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...