Archives: June 2011
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.
A discussion of how Google can serve as an invaluable resource when facing a SQL-based challenge.
Today I briefly want to mention a question a colleague at work asked: How can a comma delimited string be split using T-SQL but without using a cursor/loop? I wasn’t sure at first, but… Read more
A discussion of how a separate database is used for storing table backups.
In a recent article, one of the things I mentioned was saving table backups before important and/or risky processes. For example, I generally do this before truncating the next year school assignment and school waitlist tables… Read more
Why being careful is such an important mindset when working with SQL and databases.
At the Boston Public Schools, certain processes need to be run at particular times of the school year. There’s a couple of specific windows of time where we print choice forms for students. There’s a few… Read more
A small post regarding a couple SQL books I bought from Amazon.
A couple new books arrived in the mail from Amazon.com. Both are by Stéphane Faroult, whose videos I mentioned a few days ago.
The books are:
I’m not… Read more
A continuation of the data dictionary discussion with information about how the documentation is done.
Today I’m going to continue discussing the data dictionary tables we’ve set up at the Boston Public Schools. The SQL for creating the tables and inserting the baseline example records is in my previous data… Read more
A brief discussion and links to a series of YouTube videos from Stéphane Faroult.
I’ll continue the discussion of the table dictionary tomorrow. Today I’m sharing an informative and funny short series of youtube videos I found from Stéphane Faroult:
The videos are humorous,… Read more
Why table and column documentation is useful and some SQL for setting up the data dictionary tables.
At Boston Public Schools, we have many hundreds of data tables. Some are used all the time, others are used only during certain times of the year, while others are simply backups or… Read more
A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.
Being able to replicate production bugs is highly important. A key aspect to this is having data that is similar or [preferably] identical in a non-production environment where the issue can be… Read more
A discussion about nightly populated tables and how they have reduced SQL Server load.
What’s more important – speed or data accuracy/quality when generating reports? There’s no definitive correct answer to this question as there’s often a trade-off between the two. In many cases a cost/benefit analysis needs to be… Read more
Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just don’t go well together. Similar to how OR conditions can significantly impair queries having subqueries, they can wreak havoc on joins as well.
Take, for example, the… Read more