sql
Duplicates
Duplicates. I honestly can't tell you how many times the root cause of a problem has been records in a table get repeated, where there should never be
Latest
sql
A Better sp_who2
If you've ever needed to work with sp_who2 to figure out what's going on, then you know it would be nice to be able to sort the results, right? Well, if you use
t-sql
Moving Data Between Tables
Very early into my SQL career I had to get comfortable moving records around between tables and databases. There are several ways to do it, you just have to
Certification
70-432:Multiple Solutions, Multiple Instances
At work our database server is humming along. It runs a little under 50% on the CPU, the RAM is a bit high, and the IO is very responsive. But, it could be
Posted in: Microsoft SQL
T-SQL Challenge: Find Days of the Week
My personal goal is to post an article every Monday, Wednesday and Friday. What I’d like to do is create stubs in my content database with each of those days already set aside. That way, I can look at the next stub available and simply start writing. The challenge for...
dba
Incomplete Tables
One of the things I’ve noticed while performance tuning is many of the tables in my current environment are incomplete. They all have columns defined, and
microsoft sql
SQL 201 – Combining Query Results
Overview There comes a point in your SQL career where you will need to combine the results of several queries into one data set, and present it in one view.
microsoft sql
SQL 101 – JOIN
Overview I want to cover a fundamental topic for SQL programming. This is the topic you should start studying right after you have a basic understanding of
microsoft sql
SQL 201 – Sub Queries
Sub queries or nested queries are complete queries wrapped inside of another complete query. Some times this technique is used as a replacement for a JOIN
microsoft sql
SQL 101 – GROUP BY
Consider the following table, orders. buyer productName purchaseDate qtyPurchased pricePaid -------------
Posted in: Personal
New Site Layout!
As you can see, the template has been replaced. It’s the same code you all know and love, just a new look and layout! As always, please leave feedback and tell me what you think! Related posts: Changes to ToyboxCreations! What Do You Think?
microsoft sql
SQL 101 – Summarizing Data
This is the last of the lessons on functions for the 100 level. I hope you've enjoyed them so far, but it's time to wrap these up! When beginning to learn