script

Size Matters: Table Rows and Database Data Pages

by

I’m on my way to the PASS Business Analytics conference today. If you are attending, and you are reading this blog post, come find me and Rob Collie (blog | @powerpivotpro) during the welcome reception on Wednesday night; we’d love to talk data. Speaking of data…I was finishing up a session at the Colorado Springs SQL Saturday recently … Read more

How To: Right-sizing The Datatypes Currently In The Buffer Pool

by

Recently I shared a piece of code that would help you to right size the datatypes inside of a database. I’ve received a lot of feedback since that post and it has spurred me to think a little bit deeper on the topic of datatypes and performance. The script I shared only examined whats are … Read more