Forum Replies Created

Viewing 15 posts - 256 through 270 (of 859 total)

  • RE: convert to binary

    Sean Lange (7/23/2012)

    weston_086 (7/23/2012)

    I have two inputs “address” and “net” . I may have to convert these two inputs into binary form. And then apply logic...

    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]

    July 23, 2012 at 1:47 pm

    #1516452

  • RE: Selecting from a text defined value into varchar

    lokeshvij (7/23/2012)

    Try using VARCHAR(MAX) instead for VARCHAR(8000)

    For details check this link: http://www.sqlservercentral.com/Forums/Topic647815-145-1.aspx

    - Lokesh

    The OP may be trying to avoid off page storage of certain parts of data which VARCHAR(MAX)...

    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]

    July 23, 2012 at 12:44 pm

    #1516424

  • RE: Front-End GUI....

    depending on what you need to do, MS Access can be used however a custom written front end would also work. depends on how and what you want 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]

    July 23, 2012 at 12:27 pm

    #1516416

  • RE: Today's Random Word!

    Dumb Phones

    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]

    July 23, 2012 at 12:14 pm

    #1516409

  • RE: Windows 7 + SQL Server 2K8 Expression edition

    Have you tried downloading the.net 3.5 stand alone installed not the Sql install

    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]

    July 21, 2012 at 5:17 am

    #1515840

  • RE: Windows 7 + SQL Server 2K8 Expression edition

    i would try installing .net 3.5 first before running the 2k8 express installer. im running windows 7 pro with 2k8R2 express installed just fine. works great for 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]

    July 20, 2012 at 1:47 pm

    #1515735

  • RE: Server Level roles

    Sqlism (7/20/2012)

    Can we create server level roles in 2008R2?

    I am not getting option 'New Server Role' when i right click server roles.

    But How come this document shows can do it.

    http://cm-bloggers.blogspot.com/2010/12/creating-user-defined-server-role-in.html

    Thanks...

    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]

    July 20, 2012 at 1:35 pm

    #1515729

  • RE: Today's Random Word!

    Cliff Jones (7/20/2012)

    capn.hector (7/20/2012)

    Daniel Bowlin (7/20/2012)

    Cliff Jones (7/20/2012)

    SQLRNNR (7/20/2012)

    Pension

    Retirement

    Second career

    Second Base

    Descalso

    St Louis

    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]

    July 20, 2012 at 1:31 pm

    #1515724

  • RE: Today's Random Word!

    Daniel Bowlin (7/20/2012)

    Cliff Jones (7/20/2012)

    SQLRNNR (7/20/2012)

    Pension

    Retirement

    Second career

    Second Base

    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]

    July 20, 2012 at 1:01 pm

    #1515714

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/20/2012)

    .... I might even set it up so that SQL Server automatically sends the email for me every week. 😀

    week after you leave and forget 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]

    July 20, 2012 at 1:00 pm

    #1515713

  • RE: Create 15 min inc time matrix?

    yep you got that part right. it took me a little while to fully grasp CTE's but looks like you got it.

    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]

    July 20, 2012 at 12:35 pm

    #1515702

  • RE: Cursor within a cursor question

    Mountain Steve (7/20/2012)

    Yes that is it.

    I just don't see the benefit in doing it and it adds to code complexity.

    since you are working with nested cursors it makes sure you...

    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]

    July 20, 2012 at 10:47 am

    #1515650

  • RE: Workaround Needed to Replicate from Enterprise to Standard and Enterprise has Partitioning

    you can use a roll your own solution using partioned views http://msdn.microsoft.com/en-us/library/ms190019(v=sql.105).aspx, it may take some work to get the large table broken into the new tables but you 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]

    July 20, 2012 at 7:59 am

    #1515538

  • RE: Insert query is too slow in one server and working fine in on another server of same configuration

    are there differences in what is running on the servers?? are all the indexes the same?? there is so much that can be going on here.

    please see this 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]

    July 20, 2012 at 7:51 am

    #1515535

  • RE: script to copy missing data

    THE-FHA (7/20/2012)

    SCENARIO,

    i have tbl1, tbl2,tbl3 in qa and prod.

    tbl1(id int identity(1,1),DomainName varchar(250),Daate datetime,results varchar(20))

    tbl2(id int identity(1,1),tbl1_id int,Desc varchar(max))

    tbl3(id int identity(1,1) ,tbl2_id int,comment varchar(max))

    At this point i assume we all understand...

    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]

    July 20, 2012 at 7:33 am

    #1515517

Viewing 15 posts - 256 through 270 (of 859 total)