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
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
SQL301
Manually Deleting Stinks!
Go ahead and set up your TroubledTable by running the Create Troubled Table T-SQl Script. Now take a look at your duplicate rows. SELECT email, COUNT(*) FROM
SQL301
Design Patterns Session
On February 6, I'm going to tele-present a session on T-SQL design patterns to the Brazil SQL Server Users Group. During this session I'll cover three common
SQL301
SQL301–XML VALUE Method
Last time, I covered the EXIST Method. This time around I wanted to show you how to pull out values from XML stored in SQL. Let's start with what should have
SQL301
SQL 301-XML EXIST Method
And now it's time to wrap up the XML in SQL posts. At least, this is the last of the information you're required to know for the 70-433. Anything above and
microsoft sql
SQL 301-The XML Data Type
We’ve spent the last few posts working on getting relational data out of our tables and into XML format. Most of the time, that’s what I’ve used XML