SQL 302
- Checking for Computed Columns Posted on: 20110106
So I’ve been building an auditing system for my new employer that will help track all the changes to the data. Right now, some changes could be made, and we wouldn’t be able to tell who made the change, or when the change was made. I had an “Ah-ha” moment pretty early on. “Let’s [...] - Types of Optimization Posted on: 20101220
One of the things I love most about my current position is the fundamental shift in the types of optimization I’m doing. Early on in my career I was concentrating on queries that would run once an hour, and cover thousands, sometimes tens of thousands of records per hour. I think that’s a great [...] - Optimization Isn't Always Easy Posted on: 20101210
I’ve been at my new job for two weeks. In that time I’ve diagrammed all the databases as they are today. I’ve suggested recommendations on adding keys to some tables that had none. I’ve also started diagramming the object data that’s being collected in the system, I’m hoping to find duplication within the system [...]
