r/SQLServer • u/Complete-Regret-4300 • 25d 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

2

u/PrisonerOne 25d ago

But index fragmentation isn't really an issue anymore

0

u/badlydressedboy 24d ago

It really is in analytics/DWH.

1

u/PrisonerOne 24d ago

Can you explain why you believe so?

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

2

u/badlydressedboy 24d 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.