Viewing 15 posts - 3,361 through 3,375 (of 4,080 total)
Here it is. Many dark and arcane secrets buried within it.....
Seriously, I'm sure you will have questions. First run it, and let's see if it does...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 1:00 pm
I think I see what you're driving at, and I think we can get it done in one step without an update. Hang on and I'll see if...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 12:17 pm
conceded
The word is "conceited". Conceded is something you should have done days ago. Sorry, I couldn't resist that one. 😉 By the way,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 12:05 pm
No problem. 🙂
Here is a revised version that includes a batch number. Please just run it and look at the results, then I can answer specific questions about...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 10:20 am
If you have a sequential row number column in #tempAA you can update it using the following CTEs.
Can you show us the create table for ##tempaa and maybe some sample...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 10:04 am
Time be time. -- Maelcum
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 9:36 am
It's now DBCC TIMEWARP. It takes 127 parameters, none of which are documented anywhere. Most of the parameters are for detailing your exact position in the space-time continuum and your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 9:27 am
Point taken, Jeff.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 9:13 am
Time
And
Relative (Relational?)
Distance (Dimensions?)
In
Space
"We're running out of time!"
"Don't talk to me about time. Time is my business."
[Now I've got the theme song running through my head.]
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 9:07 am
Glad I could help. CTEs are a good thing. I prefer them to subqueries because they read from top to bottom, which is more intuitive...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 8:58 am
Hey Alvin
In fact, I am coming up to Memphis Thursday night. Expressly to attend the PASS meeting. Our head DBA used to work for FedEx...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 8:08 am
Thanks to you too, Chris.
Gail, I have been answering questions for some time now, and hope to continue. But with the evolution of The Thread, I've rolled up...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 7:59 am
Thank you Gail, I will look for them in Memphis at first opportunity.
Lynn, continuing the casual conversation from the rant thread, I live in Oxford, Mississippi which is about an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 7:17 am
Knock rings about what? (This is not a sarcastic question, Jeff.)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 6:58 am
Great 😀
I only learned about the speed of ITVFs in the last couple of months, from someone else in here. The performance gains are enough to justify the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 6:50 am
Viewing 15 posts - 3,361 through 3,375 (of 4,080 total)