Forum Replies Created

Viewing 15 posts - 391 through 405 (of 859 total)

  • RE: question on memory settings

    GSquared (4/30/2012)

    Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10%5B1%5D.pdf

    The OP was talking about Windows Server not SQL Server being the limiting factor the link...

    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 30, 2012 at 2:05 pm

    #1481478

  • RE: Sql Query to find invalid SSN Numbers

    mwaniki1 (4/27/2012)

    I guess am not getting your question because i don't need to validate anything all i need is a query that returns any Employees (id, ssn, and name) with...

    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 27, 2012 at 6:22 pm

    #1480778

  • RE: Changing Default Directory for Transaction logs

    rraja (4/27/2012)

    By modifying the log file directory wont create any issue. here is the steps.

    http://www.mssqltips.com/sqlservertip/1774/move-sql-server-transaction-log-files-to-a-different-location-via-tsql-and-ssms/

    from the OP's response it sounds as though existing databases are staying right where they...

    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 27, 2012 at 5:59 pm

    #1480775

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (4/27/2012)

    Lynn Pettis (4/27/2012)

    L' Eomot Inversé (4/27/2012)

    GilaMonster (4/27/2012)

    Lynn Pettis (4/27/2012)

    Gail, without really digging into this, isn't this just an expensive NOP?

    Yup.

    On the plus side, SQL's smart enough not...

    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 27, 2012 at 3:04 pm

    #1480732

  • RE: just curious

    ColdCoffee (4/27/2012)

    Sean Lange (4/27/2012)

    ColdCoffee (4/27/2012)

    Sean Lange (4/27/2012)

    Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted comment....

    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 27, 2012 at 3:02 pm

    #1480730

  • RE: insert into table variable

    Lynn Pettis (4/27/2012)

    Tables do not provide order, nor is there any guarantee of order. You must provide that order by using an ORDER BY on the select clause pulling...

    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 27, 2012 at 2:55 pm

    #1480720

  • RE: Today's Random Word!

    SQLRNNR (4/27/2012)

    EL Jerry (4/27/2012)

    Lynn Pettis (4/26/2012)

    Freedom!

    Wallace?

    Gromit

    tie down

    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 27, 2012 at 2:36 pm

    #1480700

  • RE: Table Table question with a twist

    take a look at Jeff's text splitter. i think it will be close enough to what you need it will get you a big push to the finish line...

    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 27, 2012 at 1:55 pm

    #1480666

  • RE: insert into table variable

    riya_dave (4/27/2012)

    but without it i am getting data into seconds ,and with it its running more than 7 minutes ,still not getting data

    what happens when you run just the procedure...

    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 27, 2012 at 1:41 pm

    #1480659

  • RE: # of characters

    If the OP does not have a tally table in there DB they can use the following to create one on the fly with out hitting sys.columns.

    ;WITH e1(n) AS (SELECT...

    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 27, 2012 at 12:28 pm

    #1480599

  • RE: Changing Default Directory for Transaction logs

    paradski (4/27/2012)

    We are running SQL server 2008 and are almost out of space on the drive where the Transaction logs are stored. IT has added another drive with more...

    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 27, 2012 at 12:21 pm

    #1480596

  • RE: # of characters

    Sean Lange (4/26/2012)

    jwbart06 (7/26/2011)

    I would have to agree that it is very slick.

    I was trying to think of doing it with out having to rely on sys.columns, but I can...

    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 27, 2012 at 11:27 am

    #1480584

  • RE: insert into table variable

    you can but as lynn said make sure you are returning 4 columns. i would also explicitly define the order (INSERT INTO bla (id,col1,col2) ...) get rid of...

    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 27, 2012 at 9:09 am

    #1480505

  • RE: Are the posted questions getting worse?

    dwain.c (4/26/2012)

    Maybe someone at the water cooler can help me with something perplexing. Steve posted the following earlier:

    Anyone want to tackle a semi-complex reporting / accounting issue?

    http://www.sqlservercentral.com/Forums/Topic1290025-1291-1.aspx#bm1290373

    My...

    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 26, 2012 at 7:06 pm

    #1480142

  • RE: I am so sad.... :-(

    have fun learning the new product. did your company decide to switch from the {extreme sarcasm} evil closed source model to the wonderful sent from heaven open source free...

    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 26, 2012 at 5:52 pm

    #1480131

Viewing 15 posts - 391 through 405 (of 859 total)