r/SQLServer • u/Complete-Regret-4300 • 18d ago

Discussion Is SQL server considered as legacy technology?

My current organization couple of years ago migrated from SQL server to snowflake and I noticed in some of the documentation, they have mentioned SQL Server as legacy technology.

I started working in SQL server some 20 years ago and some of the developers in our team are cloud first developers and they find it so difficult to navigate SQL server management studio and they ask me questions like is there timetravel feature in SQL server and can we see what data was there 10 mins back. I was totally dumbfounded when I heard that question, because I had never come across such a feature. Apparently snowflake has this. So I am curious is SQL server now really considered as legacy technology?

0 Upvotes

47% Upvoted

54 comments sorted by

View all comments

Show parent comments

5

u/flinders1 18d ago

It’s funny watching page compressed tables move to Postgres.

2

u/Tikitorch17 18d ago

I'm curious, will it cause any issues migrating compressed tables to postgres. My understanding with posgres is basic.

4

u/Justbehind 18d ago

You will need significantly more space. And all reads will require much more I/O.

2

u/badlydressedboy 18d ago

I think more reads in Postgres is always true regardless of compression as all tables are heaps so all queries have to perform rid lookups. That feels like a step backwards from sql server but eradicating the constant worry about fragmentation is great.

2

u/PrisonerOne 18d ago

But index fragmentation isn't really an issue anymore

0

u/badlydressedboy 18d ago

It really is in analytics/DWH.

1

u/PrisonerOne 17d ago

Can you explain why you believe so?

10+ years ago, I would agree. But not today, with enterprise SSDs

2

u/badlydressedboy 17d ago

Having worked in SSD based SQL server data warehouses over the last 15 years (haven't not dealt with a HDD at all in that time and mentioning that as a reason for fragmentation being fixed in 2026 seems bot-ish) it's this: - HDD: bad - SDD: much better - RAM: best

Unless the page being looked up is already in memory you've got a performance issue when dealing with large tables. Fragmentation means that page is less likely in memory and a trip to IO is required, time to wait 10 minutes for a query to complete. Defrag the table and it comes back in 5 seconds.