Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 8,731 total)

  • RE: Today's Random Word!

    HappyGeek (7/8/2016)

    Ed Wagner (7/8/2016)

    crookj (7/8/2016)

    Ed Wagner (7/8/2016)

    djj (7/8/2016)

    Ed Wagner (7/8/2016)

    djj (7/8/2016)

    Eric M Russell (7/7/2016)

    djj (7/7/2016)

    Luis Cazares (7/7/2016)

    whereisSQL? (7/7/2016)

    HappyGeek (7/7/2016)

    djj (7/7/2016)

    Rework

    Rethink

    Regret

    Retry

    Reboot

    Restore

    Refresh

    Renew

    Revitalize

    Spam

    Monte

    Anarcho-Syndicalist Commune

    Python

    rattlesnake

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 8, 2016 at 11:53 am

    #1889238

  • RE: Today's Random Word!

    whereisSQL? (7/7/2016)

    HappyGeek (7/7/2016)

    djj (7/7/2016)

    Rework

    Rethink

    Regret

    Retry

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 10:42 am

    #1889028

  • RE: Query performance change depending where condition date value

    Nice Chris, I hope that this helps Eliseo.

    I think that I understand what you're saying about the TOP filtering before the aggregate, even if the execution plan indicates otherwise with...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 9:47 am

    #1888994

  • RE: Stairway to Oracle or other learning

    This site can help you: http://docs.oracle.com/cd/E18283_01/nav/portal_booklist.htm

    Also, even if it's supposed to be used to move from Oracle to SQL Server, this could help you to check differences and similarities: https://mva.microsoft.com/en-us/training-courses/sql-server-2014-essentials-for-oracle-dbas-9062?l=VGDAvmR4_7004984382

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 9:42 am

    #1888988

  • RE: Error - data types

    Just convert your ntext column to nvarchar.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 8:52 am

    #1888963

  • RE: Query performance change depending where condition date value

    ChrisM@Work (7/7/2016)

    Luis Cazares (7/7/2016)

    ...The TOP 1000 is not helping because it needs to group the data before limiting the results....

    That was my first thought too Luis so I set up...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 7:57 am

    #1888928

  • RE: Improvements in SQL Server Environment

    Was that post a downgraded version of this one: https://www.brentozar.com/archive/2012/06/sql-server-poor-performance-checklist/ ?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 7:35 am

    #1888913

  • RE: Coalesce Function dynamically

    Are you looking for this function?

    NULLIF (Transact-SQL)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 7:09 am

    #1888902

  • RE: Query performance change depending where condition date value

    It seems that you could have a data issue. The amount of data is not similar on both dates.

    The TOP 1000 is not helping because it needs to group the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 6:58 am

    #1888901

  • RE: Dynamically passing values to IN clause.

    Your condition is the same as writing WHERE R.RoleName = @String

    Either you split the values (the best splitter can be found here: http://www.sqlservercentral.com/articles/Tally+Table/72993/) and remove the quotes.

    SELECT DISTINCT UT.TaskID, UT.TaskName,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 7, 2016 at 6:49 am

    #1888899

  • RE: Split AlphaNumeric

    PJ_SQL (7/6/2016)

    Sorry to keep changing requirement:

    ColA:

    AAAA-AOP/W 00160000

    ASSSS-DOU/W00160000

    O/OF EEEE 00000000

    So, I need to split the column on the criteria that if it starts with 0 then split it...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 6, 2016 at 1:03 pm

    #1888775

  • RE: Pickup the value from the 2nd set of string - MS SQL query

    You're really not helping us to help you. My suggestion would be to use the DelimitedSplit8k which can be found here along with its explanation:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    Having that, the query would be...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 6, 2016 at 12:49 pm

    #1888771

  • RE: Split AlphaNumeric

    PJ_SQL (7/6/2016)

    How do I split Characters and numbers from sql:

    I have this data :DEP-A CALLEJ00025000

    Need

    cola ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 6, 2016 at 12:40 pm

    #1888768

  • RE: Query for splitting a single row into multiple rows based on a column data

    TheSQLGuru (7/6/2016)

    Luis Cazares (7/6/2016)

    You're over complicating yourself. Here's a simpler version of your query.

    SELECT l.pageno,

    l.batchid,

    l.loadid,

    n AS lnidmin,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 6, 2016 at 12:12 pm

    #1888760

  • RE: Query for splitting a single row into multiple rows based on a column data

    You're over complicating yourself. Here's a simpler version of your query.

    SELECT l.pageno,

    l.batchid,

    l.loadid,

    n AS lnidmin,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 6, 2016 at 7:17 am

    #1888676

Viewing 15 posts - 2,536 through 2,550 (of 8,731 total)