microsoft sql
DATEPART(WK, DateColumn)
It's been a busy month since my last post. Moving from contracting to consulting requires a more work that I'd thought at first. In looking over the past
microsoft sql
microsoft sql
Upgrade SQL Server
One of the most difficult projects to undertake as a DBA is upgrading your SQL Server from one version to another. The biggest reason that it's so difficult is
SQL102
World Backup Day
This past Saturday was World Backup Day, It's not an actual government recognized holiday, but as a DBA you should start celebrating it. Maybe celebrate isn't
sql203
SQL203 — Indexes can help|hurt
Yeah, I used a pipe in my title. That's because indexes can help some things, but hurt others. The brief of it is indexing helps reads, but comes at a cost:
microsoft sql
SQL 201 – APPLY
Let's finish up with the SQL 210 series today with the APPLY operator. After you learn how to create your own functions, you're going to want to use them in new
microsoft sql
Loading Hierarchical Data Using a WHILE EXISTS
Last time, we discussed three methods for inserting data into a destination table that has a recursive relationship. In this article we're going to cover how
SQL301
Loading Hierarchical Data
Earlier this week the question came up on how can we insert data into a table that has a hierarchical data structure. If you're not familiar with a hierarchical
SQL301
Improve Performance by Replacing Cursors
This is the last article for my upcoming design patterns session. Today we're going to look into speeding up your queries by replacing cursors, a row-by-row
SQL301
Upserts
Up to this point in our design patterns sessions we've concentrated on removing duplicates from our troubled table. Now, let's look into preventing those
microsoft sql
De-duping by CTE
Ok, today we wrap up our design patterns for removing duplicates from tables by turning to common table expressions (CTE's). When I start talking CTE's some
SQL301
De-duping by Self join
Let's continue the series on getting rid of duplicate data. Today we're going to use self joins to get rid of them. A self join is a join from a table back to
SQL301
De-duping by temp table
Last time, we learned that manually removing duplicate rows from a table could be a long and manual process. Especially when you have as many duplicates as I