Tag Archives: Performance

Database Queries and Scalability

Posted on October 21, 2013 by way0utwest

I ran across this post with a very provocative title:  (thanks Brent Ozar Unlimited). It’s an interesting read from a developer, talking about how so many website designs aren’t built for scalable because they rely too heavily on a set of database … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Database Queries and Scalability

Achieve Better Performance

Posted on July 1, 2013 by way0utwest

One of the hottest topics at most every SQL Server event I attend is performance. The sessions that talk about improving performance through various means are well attended, and that tells me a few things. One is this is an … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Achieve Better Performance

What Do You Want to Know About I/O?

Posted on March 27, 2013 by way0utwest

There’s lots I want to know. What affect does an SSD have if I use it for a log file? One of my filegroups with indexes? What about tempdb? How do you dig in and prove latency to the storage … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on What Do You Want to Know About I/O?

The Default Fillfactor for an Index

Posted on January 7, 2013 by way0utwest

I ran down the rabbit hole on transaction logs recently. I started with Paul Randal’s post over at the SQL Sentry blog on trimming the transaction log, then went to his video on log analysis. I also glanced at the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The Default Fillfactor for an Index