Viewing 15 posts - 4,426 through 4,440 (of 8,416 total)
PaulB-TheOneAndOnly (4/1/2010)
The standard setup for FKs between FACTtual and DIMensional tables in data warehouse environments...
April 1, 2010 at 11:43 am
Lynn Pettis (4/1/2010)
Rereading the original post, it looks like a combination of garbage data and good data in different formats.
Glad you used the word 'garbage' rather than the somewhat inappropriate...
April 1, 2010 at 11:41 am
andersonrj18 (4/1/2010)
not worked, you know that!!This is my code ... it works!!
:laugh: A WHILE loop is no better than your original cursor! :laugh:
Try it on a million rows - your...
April 1, 2010 at 11:31 am
CirquedeSQLeil (4/1/2010)
Thanks for clarifying that for us Paul.
No problem, and at least you all stopped talking about certification for a while 🙂
April 1, 2010 at 11:25 am
CirquedeSQLeil (4/1/2010)
Nice concept Paul
Not really anything new, as I said...but ok, thanks 🙂
April 1, 2010 at 11:22 am
andersonrj18 (4/1/2010)
Your code doesn't work properly...
Have you run it? Works fine for me 😛
Your cursor code seems to have disappeared. All good!
Paul
April 1, 2010 at 11:13 am
PaulB-TheOneAndOnly (4/1/2010)
validate=no ... a.k.a. trust me, existing data is good.
enable=no ... a.k.a. don't bother in checking referential integrity please.
...the three of them...
April 1, 2010 at 10:58 am
Eric Zierdt (4/1/2010)
Just wanted to send a followup, after a week of running the changes, we haven't gotten a new duplicate. Thanks all!!!
Sweet as.
April 1, 2010 at 10:55 am
Lynn Pettis (4/1/2010)
If all your datetime strings are coded as above, the following code sample shows how you can covert the data to a datetime value:
I read the question as...
April 1, 2010 at 10:52 am
rdouglas66 (4/1/2010)
If you are looking for a defrag script then I would recommend Michelle Ufford's at http://sqlfool.com/2009/06/index-defrag-script-v30/ it does anything you could ever need.
Except defragment heaps 😀
The offending routine in...
April 1, 2010 at 10:46 am
JustANumber (4/1/2010)
Unfortunately, my column insert is not performed with an ALTER statement
Can I ask why not? Are you relying on 'column order' for something?
April 1, 2010 at 10:41 am
There is a very full analysis here:
http://www.sommarskog.se/share_data.html
Not just XML and TVPs either...:-)
April 1, 2010 at 10:33 am
PaulB-TheOneAndOnly (4/1/2010)
Paul White NZ (3/30/2010)
It surprises me that Oracle behaves differently, but there you go.
Actually - in the Oracle world, you have to define such particular FK as "rely" for...
April 1, 2010 at 10:30 am
Steve Jones - Editor (4/1/2010)
I believe the issue is that these are heaps. You need a clustered index on the data to defragment.
Not any more!
SQL Server 2008 supports the following...
April 1, 2010 at 10:25 am
Almost certainly 'parameter sniffing'.
Understand the issue, and the correct ways to resolve it:
April 1, 2010 at 10:18 am
Viewing 15 posts - 4,426 through 4,440 (of 8,416 total)