Forum Replies Created

Viewing 15 posts - 136 through 150 (of 859 total)

  • RE: Today's Random Word!

    L' Eomot Inversé (11/5/2012)

    opc.three (11/5/2012)

    ACTION ITEM

    INACTION ITEM

    in action figure

    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]

    November 5, 2012 at 12:46 pm

    #1556189

  • RE: create table

    The other issue could be running over 8060 bytes for a row. its possible since a varchar(100) can take up as much as 102 bytes. SQL Server...

    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]

    November 5, 2012 at 12:37 pm

    #1556184

  • RE: Having a SQL 2008 R2 Database in Memory

    rmudway (11/5/2012)

    Hi sanket!!

    Thanks for your response, that was a nice little piece of info. I found that my test machine had the whole DB in RAM, but the Main SQL...

    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]

    November 5, 2012 at 12:12 pm

    #1556180

  • RE: Today's Random Word!

    Cliff Jones (11/2/2012)

    crookj (11/2/2012)

    Append

    Overwrite

    over flow

    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]

    November 2, 2012 at 4:07 pm

    #1555685

  • RE: Help with Calculation

    Since you are asking about the output the best thing to do is post some input and the complete query and expected results for the given input. what i...

    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]

    November 2, 2012 at 3:25 pm

    #1555671

  • RE: Exclude Rows from one table based on items in two columns

    Sean Lange (11/2/2012)

    Was thinking about this during a meeting and one challenge with capnhectors code is that it could get unwieldy pretty quickly.

    If the list contained more values for manufacturer...

    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]

    November 2, 2012 at 2:21 pm

    #1555658

  • RE: Exclude Rows from one table based on items in two columns

    Another method is with an OR in the where clause and use parenthesis to group your and conditions.

    ;with cte as

    (

    select 'Volvo' as CARS, 2001 as Year union all

    select 'Volvo',...

    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]

    November 2, 2012 at 12:24 pm

    #1555629

  • RE: Memory Pressure

    menon.satyen (11/2/2012)

    Please go through the below link

    http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/

    Careful with the missing index DMV's. it may suggest 2 indexes with slight differences that could be accomplished with one index. 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]

    November 2, 2012 at 11:34 am

    #1555613

  • RE: How many rows in a table before using a clustered index?

    One thing to note is that sql server defaults to a clustered primary key. If the tables have a Primary key they most likely (Note: not always and certainly...

    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]

    November 2, 2012 at 11:24 am

    #1555610

  • RE: New To SQL, Need To Learn About Triggers

    David92595 (11/1/2012)

    Can Fields B, C, and D still be manually changed after the fact if need be? or are fields B,C, and D locked as computer values at that point?

    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]

    November 1, 2012 at 5:04 pm

    #1555246

  • RE: New To SQL, Need To Learn About Triggers

    David92595 (11/1/2012)

    okay, so for starters I'm not brand brand new to SQL. Maybe I should have been a bit more clear about that. I've got about a year...

    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]

    November 1, 2012 at 4:48 pm

    #1555240

  • RE: Licensing - acquiring new license keys

    you could also go with an evaluation copy. that would give you 180 days to license the server. however if you go that route i would not go...

    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]

    November 1, 2012 at 4:11 pm

    #1555231

  • RE: New To SQL, Need To Learn About Triggers

    George M Parker (11/1/2012)

    capnhector (11/1/2012)

    Michael Valentine Jones (11/1/2012)

    It is probably best if you avoid triggers completely until you have a lot of experience with SQL Server.

    if designed properly and tested...

    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]

    November 1, 2012 at 3:35 pm

    #1555225

  • RE: Licensing - acquiring new license keys

    pveilleux (11/1/2012)

    Hello, everyone....

    I am about ready to install a new SQL Server to support a SharePoint installation, and need to acquire a SQL 2008 R2 license. We're just about...

    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]

    November 1, 2012 at 2:58 pm

    #1555203

  • RE: New To SQL, Need To Learn About Triggers

    Michael Valentine Jones (11/1/2012)

    It is probably best if you avoid triggers completely until you have a lot of experience with SQL Server.

    i would tend to disagree. you need 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]

    November 1, 2012 at 2:04 pm

    #1555183

Viewing 15 posts - 136 through 150 (of 859 total)