Well…don't think I've seen this hack before..I guess you might call it a setbased way to create a numbers table.
Who has done it this way before?
USE [dba] GO
Read more →
"OK Brett, Now that I Removed all my Foreign Keys to Truncate the Data, Now What? I'm Hosed! Thanks a bunch" OK, Well....sorry to keep you hangng out there. But, if you followed the code in the above link you will have all of the RI saved to the work table, so now all you need to do is replay it.
Read more →
I've been asked to assist (this time BEFORE Project initiation for a change) in the developmennt of a new application. The Business Liason/Tech group that is doing this has been collecting requirements (basically reviewing an EXCEL Spreadsheet on steriods) and is coming up with a data model.
Read more →
So, we've gotten into the business of sanitizing or scrambling sensitive production data for development environments. This is, for the most part, was the direction to do this for mainframe flat files.
Read more →
Why, I still didn't get an answer from the poster in this post. But with Rudy laying the ground work I came up with the following. Why anyone would need to do thids, I have no idea.
Read more →