Forum Replies Created

Viewing 15 posts - 7,546 through 7,560 (of 59,072 total)

  • Reply To: AS400 as Linked Server

    Ken McKelvey wrote:

    SELECT * FROM OPENQUERY([AS400], 'SELECT * FROM AS400.S78359E0.QS36F.INDETLWO')

    I do not know much about AS400/DB2 but I think three part naming would be more likely to work with OPENQUERY

    --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 14, 2020 at 2:15 am

    #3734367

  • Reply To: Query Help - History Table with no range data.

    I'm a bit confused by the first row of your posted desired result...  Is the 4/1/2008 date for the SaleDate just a typo that should have been 1/1/2008 or am...

    --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 14, 2020 at 2:09 am

    #3734366

  • Reply To: Are the posted questions getting worse?

    Brandie Tarvin wrote:

    So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled. I...

    --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 14, 2020 at 12:11 am

    #3734356

  • Reply To: Could you list db modeling tools you use on daily basis?

    A lot of people don't even know about it and a lot of people that have been spoiled by other things don't care for it but SQL Server "Diagrams" 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 14, 2020 at 12:09 am

    #3734355

  • Reply To: Generate Index only Script for Whole db

    Admingod wrote:

    Simple recovery model. Approx 15 million rows. Unless bulk-logged is faster than simple?

    Simple and Bulk Logged are the same for this type of thing.  You didn't answer the rest...

    --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 14, 2020 at 12:00 am

    #3734352

  • Reply To: Generate Index only Script for Whole db

    Admingod wrote:

    Thanks! I ran some tests first with clustered index in-place and second with clustered index dropped, load the data and add the  clustered index back . Noticed second one...

    --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 13, 2020 at 11:16 pm

    #3734339

  • Reply To: Details of the transactions in Sql Server 2008 R2.

    Grant Fritchey wrote:

    Jeff Moden wrote:

    Heh... Hi!  My name is Jeff.  Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀

    HA!

    And why you want to?

    I'll give you 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 13, 2020 at 10:28 pm

    #3734330

  • Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

    Thom A wrote:

    Jeff Moden wrote:

    Aye.  And I'd also like to see them fix the actual code for the ordinal.  All they need to do is change one bloody word in the code...

    --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 13, 2020 at 3:12 pm

    #3734092

  • Reply To: Details of the transactions in Sql Server 2008 R2.

    Heh... Hi!  My name is Jeff.  Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀

    --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 13, 2020 at 3:11 pm

    #3734090

  • Reply To: Cursor inside a Stored procedure

    Hold the phone a minute... if this worked on a different instance, you have to ask yourself what changed when you copied it to the new instance if it doesn't...

    --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 13, 2020 at 2:50 pm

    #3734075

  • Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

    Aye.  And I'd also like to see them fix the actual code for the ordinal.  All they need to do is change one bloody word in the code and update...

    --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 13, 2020 at 2:46 pm

    #3734074

  • Reply To: top cqu sql how to tune

    We're spinning our wheels because we don't know enough about your code or the underlying tables.  You even have an error in the FROM clause of the code in your...

    --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 12, 2020 at 11:36 pm

    #3733845

  • Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

    I wonder if this is based a bit on old pre-2005 wives' tales that possibly used to be true and a bit on the 5 Monkeys Syndrome or maybe on...

    --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 12, 2020 at 11:08 pm

    #3733838

  • Reply To: Query Tuning Question

    coolchaitu wrote:

    Is query tuning the responsibilty of a Developer or is it a combined responsibility of DBA and SQL Developer.

    jonathan.crawford wrote:

    You simply do your best. If you are not allowed...

    --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 12, 2020 at 10:55 pm

    #3733835

  • Reply To: SQL patching solution and automation

    Aren't those supposed to be backslashes instead of forward slashes?  Could that be the remaining issue?

     

    --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 12, 2020 at 10:30 pm

    #3733819

    • Viewing 15 posts - 7,546 through 7,560 (of 59,072 total)