Some SQL Server performance goodies

Hi folks. It’s been a long time, but Databases Never Die (this could be a movie name, don’t you think?). Below are a few performance articles to think about performance.

First one is SQL on Windows vs. SQL on Linux. Some interesting numbers here: http://www.sqlservercentral.com/articles/vnext/152671/?utm_source=SSC&utm_medium=pubemail

Then some tips about compression, this is really worth checking: https://sqlperformance.com/2017/01/sql-performance/compression-effect-on-performance

And finally some index goodness. Indexes are Always a good thing to learn more about: http://www.sqlservercentral.com/blogs/confessions-of-a-microsoft-addict/2017/02/08/dba-101-what-you-may-be-missing-with-missing-indexes/?utm_source=SSC&utm_medium=pubemail

cya!

 

Advertisements

About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s