Back To Basics: Creating Indexes
After you have created your tables, and stored procedures you will have a basic idea of what queries are going to be running against your database. If you haven’t already done so, its now time to start adding indexes to your database. The catch with index is that there is such a thing as to […]
How to configure storage in SQL Server DB with more writes than reads
All to often articles and presentations about storage work under the assumption that you have a typical OLTP database with mostly reads. However there are plenty of databases out there which are mostly writes and very few reads. Setting these systems up takes a different technique for best performance. In my just released article on […]
Back To Basics: What’s the difference between a Scan and a Seek?
There are a few basic operations which SQL will perform when looking for the data that you need. Here they are listed in the order of worst to best. Table Scan Clustered Index Scan Index Scan Clustered Index Seek Index Seek The basic rule to follow is Scans are bad, Seeks are good.
ITKE is getting an upgrade soon
I’ve been informed that at some point in the near future (within the next couple of weeks probably) that we’ll be upgrading the version of Word Press that we use for the blogs.