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
Latest
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
career development
New Job Postings for 01/26
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.Jit Sequencer Aerotek
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
career development
New Job Postings for 01/24
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.Linux/novell/groupwise
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
Henry Ford Didn't Invent the Car. He Invented the System.
The Wright Brothers didn't invent flight. Plenty of people had been throwing themselves off cliffs and hilltops before Kitty Hawk. What they invented was controlled, repeatable, powered flight — a system for making it work every time. Henry Ford is the same story. Karl Benz patented the first true
Resources That Move: How Cloud Elasticity Breaks Your Naive Connection Strings
On-prem SQL Server lives at a fixed IP address on a fixed machine. Your connection string points at a name or IP, and that name or IP resolves to the same hardware until someone physically moves something. This assumption is so reliable that most .NET developers in 2010 never thought
career development
New Job Postings for 01/12
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.#dotNET #DEVELOPER in
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
career development
New Job Postings for 01/10
Here are the latest jobs sent in. If you're interested in any of these jobs, let me know! There's an application on each job page.#DEVELOPER in Alpharetta,