database

Technology for the Non-Technical

I am potentially one of the least technical people in my generation. I’m 30 and I am afraid of my cellphone, my laptop, Netflix, the microwave…. Okay, afraid is maybe a strong word, but baffled by them at the very least. In high school, while my classmates wrote most of their papers and assignments on…

SQL Server Statistics: Maintenance and Best Practices

What are Statistics? There are multiple paths a database can use to answer a query, some of them being faster and more efficient than others. It is the job of the query optimizer to evaluate and choose the best path, or execution plan, for a given query. Using the available indexes may not always be…