Forum Replies Created

Viewing 15 posts - 541 through 555 (of 859 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (4/16/2012)

    Lynn Pettis (4/16/2012)

    With "the one", do you think it time to tell him the following?

    1. Get out a blank piece of paper.

    2. Put your name and today's date...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 3:18 pm

    #1474431

  • RE: how to integrate a solution into existing query

    it would probably be best to continue the discussion in the old thread.

    http://www.sqlservercentral.com/Forums/Topic1283875-392-1.aspx

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 2:31 pm

    #1474402

  • RE: Same Query , Same Database, Different Server ....Different Result!!!

    SQLKnowItAll (4/16/2012)

    My guess is that data is not actually there. How do you know it got refreshed? Can you use a SELECT * and verify that the data...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 2:20 pm

    #1474392

  • RE: check database integarity takes long

    Lynn Pettis (4/16/2012)

    GilaMonster (4/16/2012)

    This is one area where I and many others disagree with Book Online. Set the max server memory always. See chapter 4 of the book I linked...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 2:17 pm

    #1474389

  • RE: How many rows is it reasonable to put in SQL Server? (large data question)

    im looking at a table with close to 300 million records with proper indexes and have no problems. the key as people have stated is the proper clustered and...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 2:11 pm

    #1474378

  • RE: checking 2 sql columns and displaying result in 1 column

    Phil Parkin (4/16/2012)

    Actually the statement previous to the WITH (CTE) needs to be terminated with a semi-colon.

    Grrrr! Correct 🙂

    when posting code i always put the semi colon infront of the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 16, 2012 at 10:33 am

    #1474183

  • RE: URGENT PLEASE Got a SQL Scenario to solve

    you have a very vague question. can you post more detail and maby table deffinitions and sample data.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 15, 2012 at 3:55 pm

    #1473812

  • RE: How to make an action on each row from a data set

    Phil Parkin (4/15/2012)

    edvard 19773 (4/15/2012)

    Still thanks for having solved my immideate problem!

    I am aware of, that your solution is much faster than a row by row solution, and in this...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 15, 2012 at 8:03 am

    #1473727

  • RE: DATABASES

    vinu512 (4/13/2012)

    Seems like ETL to me. The various branches can accumulate the data in XML form or in the form of Excel sheets. This data can then be mailed to...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 14, 2012 at 9:49 am

    #1473662

  • RE: How to connect to SQL Server?

    i would hazard to guess your user is not authorized to the login to the server. in which case you would need to contact the system administrator.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 13, 2012 at 4:23 pm

    #1473580

  • RE: How to connect to SQL Server?

    are you editing out your user name or are you not providing a user name?

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 13, 2012 at 4:13 pm

    #1473576

  • RE: fetching date from 1 sp to another

    hbtkp (4/13/2012)

    at least help me with my code

    how to check while loop and increment date by 1 month in while loop

    we have no code to help you with, you have...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 13, 2012 at 4:11 pm

    #1473575

  • RE: checking 2 sql columns and displaying result in 1 column

    that creates all of your counts. you will need to modify the queries to get your wheres back in since i saw you included only one OrderHeader_ID

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 13, 2012 at 3:56 pm

    #1473570

  • RE: checking 2 sql columns and displaying result in 1 column

    ok here we go here is the code:

    ;WITH finding AS (select oa.id, oa.Risk_Rating, COUNT (orf.Prnt_ID) findingcount

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 13, 2012 at 3:50 pm

    #1473567

  • RE: code

    Duplicate post all replies here http://www.sqlservercentral.com/Forums/Topic1282601-392-1.aspx

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 13, 2012 at 3:16 pm

    #1473547

Viewing 15 posts - 541 through 555 (of 859 total)