Forum Replies Created

Viewing 15 posts - 151 through 165 (of 1,473 total)

  • RE: Blocks query does not give accurate process query

    While playing with this some more, I've noticed that the stmt_start and end will be 0 if the status is sleeping. The entry is still there because the connection...

    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]

    April 12, 2010 at 5:10 pm

    #1150430

  • RE: Find All Compressed tables in database - script

    What do you mean by "better"? Does this have the information you need, or are you looking for something more? Like, perhaps, the compression settings of the indexes...

    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]

    April 12, 2010 at 3:44 pm

    #1150400

  • RE: Archiving Millions of Image records

    You might also implement something using SET ROWCOUNT 50 or SET ROWCOUNT 100.

    Should be similar to the cursor in that it wouldn't cause long term locking but doing it in...

    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]

    April 9, 2010 at 3:36 pm

    #1149396

  • RE: Do u have a Idea about Navision DB?

    I was thinking that as I was replying last time =). But it's screwy either way, because all the replies reference the whole not replying here thing, so if...

    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]

    April 9, 2010 at 1:47 pm

    #1149346

  • RE: Create a Temp table or have different join for each aggregation

    Not enough information to go on.

    In general, the less rows you have to touch the better. So if the last table is large and the result of your aggregation...

    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]

    April 9, 2010 at 1:43 pm

    #1149344

  • RE: Slipstreaming SP1 and Enterprise edition

    I was thinking it persisted all your server settings and everything as well. Just installing SP1 in the same step doesn't really seem worth it for a one time...

    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]

    April 9, 2010 at 12:09 pm

    #1149303

  • RE: Recursive cross join to get all available combinaisons

    Ninja's_RGR'us (4/9/2010)

    Garadin (4/9/2010)

    Chris Morris-439714 (4/9/2010)

    Oh cr@p - Seth, let me know if you're still considering setting up a challenge and I'll edit this out.

    I am, but I know Jacob already...

    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]

    April 9, 2010 at 11:36 am

    #1149294

  • RE: Do u have a Idea about Navision DB?

    Oops, had an extra HTTP in there. Fixed.

    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]

    April 9, 2010 at 11:22 am

    #1149286

  • RE: Recursive cross join to get all available combinaisons

    Chris Morris-439714 (4/9/2010)

    Oh cr@p - Seth, let me know if you're still considering setting up a challenge and I'll edit this out.

    I am, but I know Jacob already has the...

    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]

    April 9, 2010 at 9:30 am

    #1149218

  • RE: Do u have a Idea about Navision DB?

    No worries, it happens. We just try to pick one before everything gets fragmented.

    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]

    April 9, 2010 at 9:23 am

    #1149212

  • RE: Do u have a Idea about Navision DB?

    Duplicate post, replies here please.

    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]

    April 8, 2010 at 11:25 pm

    #1148825

  • RE: Slipstreaming SP1 and Enterprise edition

    I'm debating playing with it too. I know Jack Corbett just wrote a couple posts about slipstreaming on his blog that I've been meaning to go back and read...

    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]

    April 8, 2010 at 10:50 pm

    #1148809

  • RE: Group By Clause not working - (Is Pivot an option?)

    vktaylor (4/8/2010)

    I tried you suggestion, but it returned the following message.

    StartTime is invalid in the select list because it must be contained in an aggregate function or group...

    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]

    April 8, 2010 at 10:45 pm

    #1148805

  • RE: table comparision

    If the situation is really as simple as your example, then you can check it with case statements... (Note: sorry, not on a SQL Server atm, so not tested)

    DECLARE...

    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]

    April 8, 2010 at 10:36 pm

    #1148801

  • RE: need help with stored procedure

    What a nice trip back through memory lane. You just made me dig back through oooold code to find this ;-). Yes kids, way back when, I actually...

    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]

    April 8, 2010 at 10:19 pm

    #1148796

Viewing 15 posts - 151 through 165 (of 1,473 total)