Printed 2017/08/23 05:27PM

Run, The Sky is Falling (#memeMonday)

By Jen McCown, 2011/06/06

This month’s Meme Monday is “dumb SQL questions”.  Here’s the one that gets under my skin the most these days:

Let me explain this again...

Our databases are starting to get really big. When should we think about moving them to Oracle?

No. No, no, no, no, no no no no no no no no no no no no no no no no no NO.  Microsoft SQL Server is not Notepad. It’s not Access. It’s not Excel. It’s not a toy. It is a full fledged, enterprise ready relational database server. It’s all grown up and has its big boy boots on. It can handle it, you go right ahead.

Futhermore, the performance issues you see with your databases aren’t due to the incredible growth you’re seeing, oh no no. Your performance issues stem from bad code, badly designed vendor databases, badly maintained (or outright neglected) servers and DBs, and your own general lack of caring. In short, issues that will not go away by attempting to port to a whole other platform.

Bonus points: Said databases are fewer than 10, and smaller than 15 Gb apiece.

Now, behave yourself, and don’t make me explain it again.


Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.