Forum Replies Created

Viewing 15 posts - 3,811 through 3,825 (of 8,731 total)

  • RE: Today's Random Word!

    DonlSimpson (11/16/2015)

    Ed Wagner (11/16/2015)

    anthony.green (11/16/2015)

    djj (11/16/2015)

    anthony.green (11/16/2015)

    Ed Wagner (11/16/2015)

    Sith

    Dark

    Chocolate

    Bean

    Coffee

    Java

    Jabba

    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

    November 16, 2015 at 12:42 pm

    #1840100

  • RE: Shrinking Database

    luissantos (11/16/2015)

    What is the best solution to the problem since users complain of slowness.

    Why do you believe that slowness is related to the size of the data file and 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

    November 16, 2015 at 12:42 pm

    #1840099

  • RE: DBA path discussion

    sqlfriends (11/16/2015)

    Hello, I would like to discuss a little about DBA path.

    Other than server management, what other skills or path DBA should learn and prepare for future?

    For example, skills like...

    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

    November 16, 2015 at 10:28 am

    #1840043

  • RE: Add current date to a bulk insert

    My solution would be to add a default constraint to get the current date on the column. With that in place, use a format file to insert values only 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

    November 16, 2015 at 10:14 am

    #1840034

  • RE: Calculate Recent Form Football standings ( for example Last 5 games standings )

    This will return the last five games for each team.

    If you want to return the last five games for a single team, you can have a simpler approach (or approaches).

    DECLARE...

    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

    November 16, 2015 at 9:40 am

    #1840012

  • RE: Calculate Recent Form Football standings ( for example Last 5 games standings )

    There's a lot to be done. As you don't have nothing installed yet, I'll assume that you'll get the latest version available (2014). I strongly suggest that you read 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

    November 16, 2015 at 8:29 am

    #1839975

  • RE: Calculate Recent Form Football standings ( for example Last 5 games standings )

    Just to be clear.

    MS Access, MS SQL Server, MySQL, PostgreSQL and others are different products to handle databases. They share similarities, but queries are written different for each one of...

    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

    November 16, 2015 at 7:57 am

    #1839961

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/14/2015)

    GilaMonster (11/14/2015)

    I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and...

    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

    November 14, 2015 at 4:29 pm

    #1839834

  • RE: Are the posted questions getting worse?

    GilaMonster (11/14/2015)

    I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and research really...

    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

    November 14, 2015 at 1:25 pm

    #1839827

  • RE: Using SSIS ... Get only numbers from a column

    What I posted doesn't use a function and it'll be the best way to do it. If you want to filter rows, you just change the condition to the WHERE...

    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

    November 13, 2015 at 1:46 pm

    #1839746

  • RE: JOIN in date range slow

    RVO (11/13/2015)

    Added DDL for two problematical tables...

    S_CLIENT_SHARED

    S_CLIENT_ACCOUNT_ASSOCIATION_SHARED

    You're lacking indexes on those tables. If we're talking about millions of rows, that will definitely be a problem.

    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

    November 13, 2015 at 1:31 pm

    #1839736

  • RE: Using SSIS ... Get only numbers from a column

    etirem (11/13/2015)

    Please, I need only Integers and in SSIS, thank you.

    Is this a question for a test? Why do you have restrictions? Why are you cheating?

    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

    November 13, 2015 at 1:27 pm

    #1839734

  • RE: JOIN in date range slow

    RVO (11/13/2015)

    Thanks Luis.

    Without DISTINCT, row count is actually 20 billion something.

    Maybe that's what Estimated Row counts show ?

    To me if without DISTINCT query returns 20 billion records from 80...

    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

    November 13, 2015 at 1:26 pm

    #1839733

  • RE: Displaying Months As Series - Ordering by Month Number

    For Q1:

    You need to set different values for the Value and Label properties for your month attribute in the date dimension.

    For Q2:

    You need to build a hierarchy to be able...

    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

    November 13, 2015 at 1:21 pm

    #1839730

  • RE: Returning two characters from a column

    Ed Wagner (11/13/2015)

    Luis Cazares (11/13/2015)

    hoseam (11/13/2015)

    Hi

    I have a column that has values [1,2,3....10,11,13,14 ...]

    I want to return just two characters, e.g [01, 02, 03....10,11,12...]

    I concatenated a string before to

    '0'||CAST(m.d_depend...

    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

    November 13, 2015 at 1:18 pm

    #1839725

Viewing 15 posts - 3,811 through 3,825 (of 8,731 total)