Forum Replies Created

Viewing 15 posts - 24,241 through 24,255 (of 59,102 total)

  • RE: Time of Day Trigger

    Tergum Rufus (3/2/2014)

    Thanks everyone for responses. JM - it's for clients with SQL EXPRESS Editions

    TR

    Ah... got it. Thanks.

    If you have Windows security running, SQLCmd does't require exposed credentials. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 3, 2014 at 6:29 am

    #1693534

  • RE: Trouble looping through a cursor

    The cursor will become a performance and resource usage problem. Do you have someone on-site that could help you turn this into a proper "upsert"?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 3, 2014 at 6:25 am

    #1693531

  • RE: Lazy CPUs ?? 7 Idle, 1 maxed out

    I don't believe this is a TempDB issue even if the symptoms say it is. I think it's either a resource intensive query that might need some tweeking because...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 3, 2014 at 6:16 am

    #1693525

  • RE: Lazy CPUs ?? 7 Idle, 1 maxed out

    homebrew01 (3/2/2014)

    I can only answer a couple of those right now.

    MAXDOP is 0, and Cost Threshold for Parallelism is 5. There was no blocking, but I know there was a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 7:51 pm

    #1693423

  • RE: Query of 100 mil rows with multiple parameters

    I guess my first recommendation would be to make the PK a nonclustered index. It's currently way too wide to be of any practical use as a clustered index...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 6:30 pm

    #1693415

  • RE: Trigger Usage

    born2achieve (3/1/2014)

    Hi Jeff,

    Thanks for your time. My Regular Table and Audit Table has the same schema other than the identity

    TableName: Users

    IdUser bigint identity(1,1) primary...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 6:09 pm

    #1693412

  • RE: How to shrink log in 2008 r2? URGENT!!!!!!

    SQL_Surfer (3/2/2014)

    Can I do this when db is online?

    Yes.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 5:38 pm

    #1693410

  • RE: Random rows generator:

    KoldCoffee (3/2/2014)

    I don't know why they did that in Books Online except, maybe, that it's easier to remember than 2147483647, which is the maximum postive number that an INT can...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 2:29 pm

    #1693396

  • RE: How to update a Table using Loop?

    eligiable (3/2/2014)

    Hi Jeff Moden

    1st alteration will allow to store the Counter values in CounterDesc as an INT or BigINT depends on the records (I got 1 Million and increasing), so...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 2:13 pm

    #1693395

  • RE: random records

    KoldCoffee (3/1/2014)

    Is the temp table of random numbers between min(ID) and max(ID) etc....really the superior one?

    For performance, absolutely. For accuracy in returning the proper number of rows,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 12:04 pm

    #1693392

  • RE: How to update a Table using Loop?

    eligiable (3/2/2014)

    Thanx ChrisM@home :-), that really helped, check out the following statement:

    SELECT DISTINCT TerminalNo, MerchantNo

    INTO #tblGen_TermCounter

    FROM tblRPT_TXNDetails;

    ALTER TABLE #tblGen_TermCounter ADD CounterDesc BIGINT;

    WITH Updater AS (

    SELECT CounterDesc, CounterNo = ROW_NUMBER() OVER(PARTITION...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 11:50 am

    #1693390

  • RE: Time of Day Trigger

    MyDoggieJessie (3/2/2014)

    I thought the same thing Jeff, but figured it was probably because either they didn't have permissions to create an Agent job or because they have hundreds of them...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 11:47 am

    #1693388

  • RE: Random rows generator:

    Shifting gears, I find the formula in Books Online to be inaccurate. The number of rows that it returns varies quite a bit. The following will always return...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 11:33 am

    #1693385

  • RE: Random rows generator:

    KoldCoffee (3/1/2014)

    Hi RBarryYoung,

    Can you please explain use of 0x7fffffff ?

    I don't know why they did that in Books Online except, maybe, that it's easier to remember than 2147483647,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 11:14 am

    #1693382

  • RE: Time of Day Trigger

    Tergum Rufus (3/1/2014)

    Please can someone tell me how to trigger an sp at a fixed time of day without using SQL server agent?

    Why? What's the problem with using SQL...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    March 2, 2014 at 11:04 am

    #1693379

Viewing 15 posts - 24,241 through 24,255 (of 59,102 total)