Forum Replies Created

Viewing 15 posts - 6,031 through 6,045 (of 8,731 total)

  • RE: SQL DBA high ended question (5+ years’ experience)

    Eirikur Eiriksson (8/5/2014)

    Luis Cazares (8/5/2014)

    Koen Verbeeck (8/5/2014)

    Grant Fritchey (8/5/2014)

    You get a phone call. The person on the phone says the database is slow. What do you do?

    Migrate from Oracle to...

    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

    August 5, 2014 at 3:40 pm

    #1735416

  • RE: Query Help

    Why are you looping? What RDBMS are you using?

    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

    August 5, 2014 at 3:23 pm

    #1735402

  • RE: SQL DBA high ended question (5+ years’ experience)

    Koen Verbeeck (8/5/2014)

    Grant Fritchey (8/5/2014)

    You get a phone call. The person on the phone says the database is slow. What do you do?

    Migrate from Oracle to SQL Server? Do I...

    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

    August 5, 2014 at 3:17 pm

    #1735398

  • RE: Reverse Engineer SQL Table

    To search within SSIS packages that are in the file system, I use Notepad++ with the "Find in Files" option (Ctrl+Shift+F). It'll find if the text is used in 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

    August 5, 2014 at 2:52 pm

    #1735387

  • RE: Change my Query please

    To have a good explanation on how to do it, read the following article: http://www.sqlservercentral.com/articles/T-SQL/63681/

    And remember that MAX() is an aggregate function that you can use on strings.

    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

    August 5, 2014 at 10:19 am

    #1735302

  • RE: Query Help

    You are on the right track with your last sentence. Here's how you could do it. I'm leaving your option and an additional one.

    --Your option

    SELECT *

    --DELETE

    FROM Vend_Comp

    WHERE ID NOT IN...

    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

    August 5, 2014 at 10:04 am

    #1735297

  • RE: Oracle's INTICAP in sql

    I'm not sure, but I believe that this is the fast scalar function I was talking about. http://www.sqlservercentral.com/Forums/FindPost1222341.aspx

    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

    August 5, 2014 at 8:46 am

    #1735235

  • RE: Oracle's INTICAP in sql

    Sean Lange (8/5/2014)

    Luis Cazares (8/5/2014)

    Maybe this thread can give you some ideas. http://www.sqlservercentral.com/Forums/Topic1531616-392-1.aspx

    There's another option that uses a scalar function which seems to be faster but I'll have to find...

    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

    August 5, 2014 at 8:39 am

    #1735232

  • RE: populating 1 column from 2 different columns

    Please post DDL and sample data as insert statements so we can have something to test on. You should post expected results based on that sample data.

    Otherwise, I'm not sure...

    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

    August 5, 2014 at 8:37 am

    #1735231

  • RE: Sql - Count value in case statement

    Maybe something like this?

    WITH SampleData(id, date, value1, value2) AS(

    SELECT 1, '21040605', 'Yes', 'No' UNION ALL

    SELECT 1, '21040606', 'No', 'Yes' UNION ALL

    ...

    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

    August 5, 2014 at 8:33 am

    #1735229

  • RE: Rows into Columns - remove duplicates and variable rows

    Maybe you culd read Part 2 of the Cross Tabs and Pivots series. 😉

    http://www.sqlservercentral.com/articles/Crosstab/65048/

    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

    August 5, 2014 at 8:24 am

    #1735223

  • RE: Oracle's INTICAP in sql

    Maybe this thread can give you some ideas. http://www.sqlservercentral.com/Forums/Topic1531616-392-1.aspx

    There's another option that uses a scalar function which seems to be faster but I'll have to find 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

    August 5, 2014 at 8:19 am

    #1735214

  • RE: Selecting a Max Amount of rows with top down priority

    Hi Renee,

    Welcome to the forums. You're quite new, so I'm explaining some best practices when posting. You explained your problem almost clearly enough but I'm not sure if your priorities...

    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

    August 4, 2014 at 4:15 pm

    #1734964

  • RE: using IDENTITY INSERT

    The SET statements are session specific (unless someone corrects me). That means that if you set identity_insert on, you can only use that option in that session and other sessions...

    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

    August 4, 2014 at 1:02 pm

    #1734927

  • RE: SSRS - Formatting a multi-value field??

    Hi Daniel,

    The problem in this case is not about splitting but about joining the values.

    Another problem is that you're using a multi-statement table valued function that uses a recursive...

    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

    August 3, 2014 at 6:39 pm

    #1734714

Viewing 15 posts - 6,031 through 6,045 (of 8,731 total)