Forum Replies Created

Viewing 15 posts - 7,306 through 7,320 (of 8,760 total)

  • RE: Resetting dynamic port

    jralston88 (8/27/2014)


    We have a SQL Server 2008 Enterprise cluster two node environment (64 bit). We have a default instance and two named instances on it. With named instances...

  • RE: Recommended MAXDOP setting

    2Fire (8/27/2014)


    We are running SQL2012 with -

  • 2 physical processors
  • 6 cores per processor
  • 24 logical processors
  • NUMA enabled - 2 nodes and 12 logical processors/node
  • Per MSKB article - http://support.microsoft.com/kb/2806535

    β€’For servers that have NUMA...

  • RE: Are the posted questions getting worse?

    Does anyone have some funny sequence code to pitch in here?

    😎

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/27/2014)


    Steve Jones - SSC Editor (8/27/2014)


    Lynn Pettis (8/27/2014)


    Anyone else feel uncomfortable answering this question?

    Not at all. I'd give a range for my company, rather than specifics, but no...

  • RE: Need Help - SQL Select Statement

    Lynn Pettis (8/27/2014)


    Eirikur Eiriksson (8/27/2014)


    keshabsingh (8/27/2014)


    Thanks Eirikur Eiriksson!.

    Your attempt is not bad. πŸ˜›The approaches other users presented are more robust and accurate. Thanks anyway.

    I guess that now it's your turn...

  • RE: Unicode issue

    Robert Heynen-454800 (8/27/2014)


    I tried that first...didn't work

    I researched a bit and found something called a surrogate pair, where if the char number is higher than a certain range, it introduces...

  • RE: Need Help - SQL Select Statement

    keshabsingh (8/27/2014)


    Thanks Eirikur Eiriksson!.

    Your attempt is not bad. πŸ˜›The approaches other users presented are more robust and accurate. Thanks anyway.

    I guess that now it's your turn to make an effort....

  • RE: Need Help - SQL Select Statement

    Lynn Pettis (8/27/2014)


    Why did people post code? It would have been nice to see what the OP had tried first since this looks like homework even though the OP...

  • RE: Unicode issue

    Robert Heynen-454800 (8/27/2014)


    I tried that first...didn't work

    I researched a bit and found something called a surrogate pair, where if the char number is higher than a certain range, it introduces...

  • RE: Need Help - SQL Select Statement

    Quick question, what version and edition of sql server (select @@version) are you on?

    😎

  • RE: Need Help - SQL Select Statement

    keshabsingh (8/27/2014)


    This is not homework session. Your approach is very limited with hard coding the values. What if data is like this?

    Then, that in itself is a change to the...

  • RE: How to get the resultset datatypes of a stored procedure ?

    patrickmcginnis59 10839 (8/27/2014)


    fregatepllada (8/27/2014)


    Deprecated SET FMTONLY statement did the trick

    http://msdn.microsoft.com/en-us/library/ms173839.aspx

    also check sp_describe_first_result_set, thanks to Eirikur Eiriksson for heads up on that one!

    http://www.sqlservercentral.com/Forums/FindPost1573301.aspx

    Further on this, the code in my initial post...

  • RE: Need Help - SQL Select Statement

    keshabsingh (8/27/2014)


    Run this script

    create table #table1(steps int)

    insert into #table1(steps)values(1)

    insert into #table1(steps)values(3)

    insert into #table1(steps)values(4)

    insert into #table1(steps)values(5)

    select steps from #table1

    drop table #table1

    You will get this

    steps

    1

    3

    4

    5

    I want this way.

    stepFrom stepTo

    1...

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/27/2014)


    rodjkidd (8/27/2014)


    jcrawf02 (8/27/2014)


    rodjkidd (8/27/2014)


    One of the PM's near me is having a meting at his desk. Explaining something to another person. They are almost replying with umhum with...

  • RE: How to apply same data manipulation codes to a group of SSIS components' inputs?

    Mr.Sahand (8/27/2014)


    Come on Eirikur, it is not that similar!:Whistling:

    Ooops, wrong number:-D

    😎

  • Viewing 15 posts - 7,306 through 7,320 (of 8,760 total)