Forum Replies Created

Viewing 15 posts - 631 through 645 (of 1,473 total)

  • RE: Help writing a SQL

    Jeff Moden (9/18/2009)

    Turn off the execution plan and see what you get.

    Without the execution plan, 12 seconds for quirky with MAXDOP 1, 151 for the RCTE. I ran them...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 1:08 pm

    #1055838

  • RE: Help writing a SQL

    Taking this one step further, if anyone wants to supply the script for a CLR function(and possibly explain to me how to use it) or any other alternate method they...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 11:24 am

    #1055760

  • RE: Help writing a SQL

    And the results are in. It probably wasn't a fair contest to begin with. You were going up against a gut accustomed to eating 2 day old Taco...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 11:15 am

    #1055751

  • RE: Help writing a SQL

    Dave Ballantyne (9/18/2009)

    Your wish is my command 🙂

    Happy to be proved wrong , evidence either way is good in my book.

    You just need to manually update the acct value ,

    and...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 9:43 am

    #1055701

  • RE: Help writing a SQL

    Dave Ballantyne (9/18/2009)

    Also, with the quirk update , although you have specified index(0) are the rows guaranteed to come back in the required order ? . If you joined...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 9:40 am

    #1055695

  • RE: insert headers into sql query result

    First, a disclaimer.

    This is most likely not the best method for this. There may be an exporting service like SSIS or one of those that can handle this much...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 9:00 am

    #1055666

  • RE: Help writing a SQL

    Dave Ballantyne (9/18/2009)

    My 'gut' feeling is it should be light on the system than a quirky update though.

    My gut feeling is that you're wrong :-D. But that's what we...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 8:47 am

    #1055661

  • RE: Records per hour?

    BOL[

    timestamp

    timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 7:38 am

    #1055595

  • RE: Records per hour?

    Does your table have another field that is actually related to the date of the records? Despite its' name, a timestamp field has nothing to do with time and...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 18, 2009 at 7:33 am

    #1055592

  • RE: Help writing a SQL

    Jeff Moden (9/17/2009)

    Garadin (9/17/2009)

    It's ok. Everybody forgets the index :-P.

    I'm still looking for another way to do iterative logic that can compare with this method. I've heard CLR...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 17, 2009 at 10:06 pm

    #1055359

  • RE: Help writing a SQL

    Jeff Moden (9/17/2009)

    Seth,

    I haven't executed your good code but it looks right. My only suggestion would be to add OPTION (MAXDOP 1) to the update to prevent any parallelism...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 17, 2009 at 10:00 pm

    #1055355

  • RE: Help writing a SQL

    Greg Snidow (9/17/2009)

    Ok, this might be a dumb question, but if I specify the physical order of the records on the insert, then why is the index so vital? ...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 17, 2009 at 9:55 pm

    #1055353

  • RE: Help writing a SQL

    It's ok. Everybody forgets the index :-P.

    I'm still looking for another way to do iterative logic that can compare with this method. I've heard CLR functions can beat...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 17, 2009 at 6:11 pm

    #1055314

  • RE: Help writing a SQL

    Greg Snidow (9/17/2009)

    Admitedly, I don't fully grasp how it works exactly

    The article is under construction atm, but I've prettymuch got it memorized :hehe:. The whole theory...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 17, 2009 at 5:14 pm

    #1055304

  • RE: TSQL Query from SQL server 2000 to SQL server 2005

    So, you're claiming the following?

    You have an offsite SQL2000 DB (Central) with a table containing 300 records

    You have an onsite SQL2005 DB.

    You are attempting to use this SQL2005 DB to...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    September 17, 2009 at 11:59 am

    #1055177

Viewing 15 posts - 631 through 645 (of 1,473 total)