Forum Replies Created

Viewing 15 posts - 9,001 through 9,015 (of 19,560 total)

  • RE: Solving SUDOKU thru SQL Code

    Well, that is about 12 times faster on my machine. Where did you pick up that trick?

    I need to delve a bit more into it now.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 18, 2011 at 9:31 am

    #1370206

  • RE: Today's Random Word!

    Ocular proof

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 18, 2011 at 9:19 am

    #1370195

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/18/2011)

    Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 18, 2011 at 9:17 am

    #1370193

  • RE: Solving SUDOKU thru SQL Code

    Testing it now - on a puzzle with fewer givens.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 18, 2011 at 9:14 am

    #1370189

  • RE: Physical CPU or Logical Processors ?

    I would start with setting it at 4, test, baseline and then try a different value if necessary.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 9:01 pm

    #1369926

  • RE: syntax near a subquery

    ColdCoffee (8/17/2011)

    SQLRNNR (8/17/2011)

    I have seen it many times more often in a CTE than the older Derived table. I think this syntax has some usefulness when thinking through it....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 9:00 pm

    #1369925

  • RE: Are the posted questions getting worse?

    Some people need to get a clue.

    Anybody want to chime in on this cheater?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 8:59 pm

    #1369924

  • RE: Using Between operator...

    DatabaseHell (8/17/2011)

    Anyone with a grip on reality please answer?

    Again - why the need to attack?

    Think through the problem with a bit of logic.

    If you didn't have a typo in the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 8:57 pm

    #1369923

  • RE: Using Between operator...

    DatabaseHell (8/17/2011)

    Same values Chump

    Seriously?

    You come to a forum where people volunteer their time to ask for assistance with YOUR exam?

    The answer is obvious - talk to your prof about it....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 8:56 pm

    #1369922

  • RE: Stairway to Transaction Log Management in SQL Server, Level 2: A Brief Overview of Transaction Log Architecture

    Thanks for the article Tony.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 6:08 pm

    #1369906

  • RE: Physical CPU or Logical Processors ?

    awu (8/17/2011)

    From BOL:

    "The maximum value for thedegree of parallelism setting is controlled by the edition of SQL Server, CPU type, and operating system. If a value greater than the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 6:01 pm

    #1369905

  • RE: Using Between operator...

    Are the values you input into the table what was presented on the exam?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 5:58 pm

    #1369904

  • RE: using distinct

    I have seen it go both ways. It depends on the query and how the results are being displayed or not displayed.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 5:38 pm

    #1369899

  • RE: BACKUP to share over UNC path is very slow

    opc.three (8/17/2011)

    Alex Webber (8/17/2011)

    Thanks for the reply. This is actually backing up to box in the same data centre which we then copy offsite afterwards.

    Also, like I said before, I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 5:36 pm

    #1369898

  • RE: Using Between operator...

    That depends, if

    SELECT price, quantity FROM orders WHERE quantify BETWEEN 50 and 75;

    Is accurate, then none of the above is correct.

    But if you mean this:

    SELECT price, quantity FROM orders...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 17, 2011 at 5:26 pm

    #1369896

Viewing 15 posts - 9,001 through 9,015 (of 19,560 total)