Forum Replies Created

Viewing 15 posts - 151 through 165 (of 859 total)

  • RE: disk performance question

    Here we use raid 5. its fast to read and write and has parity spread out through out the array. we also run with a hot spare so...

    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]

    October 30, 2012 at 4:55 pm

    #1554418

  • RE: How can I demonstrate what DBCC CheckDB will show if corruption is found?

    jasona.work (10/30/2012)

    Or I could have searched on Google for "sql server create corrupt database" in which case the top two results would be an article by Perry Whittle (How 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]

    October 30, 2012 at 4:48 pm

    #1554416

  • RE: SQL Server query Automation

    What you are asking is possible through the blessing and curse of dynamic sql. before you start in on dynamic sql have a read through this as it has...

    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]

    October 30, 2012 at 4:06 pm

    #1554409

  • RE: Memory Pressure

    bala2 (10/30/2012)

    Hi,

    We have Production server win 2003 with Sql server 2008 running on it.

    Ram --4GB.

    We have performance issue for a database which application is running very slow.

    Can any one...

    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]

    October 30, 2012 at 3:10 pm

    #1554397

  • RE: Question on Lock wait types

    baabhu (10/28/2012)

    Hello Everyone,

    Our production server experiences lot of blocking and locking from application.

    I have attached the top waits from server. Can anyone help to understand or guide me...

    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]

    October 29, 2012 at 12:50 pm

    #1553869

  • RE: Alphanumeric number generation

    ChrisM@Work (10/29/2012)

    Jeff Moden (10/29/2012)

    Eugene Elutin (10/29/2012)

    Jeff Moden (10/27/2012)

    I wonder how many 3 and 4 letter swear words such a proccess will actually spell out...

    Actually it depends how you take 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]

    October 29, 2012 at 12:24 pm

    #1553856

  • RE: Parsing out email address in FROM field

    vu_tran764 (10/27/2012)

    Capnhector,

    So I got what I needed however I need to update a field in Tbldoc (maybe called as UPDATEDTO).

    What I can see in the last statement(below) is 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]

    October 29, 2012 at 10:29 am

    #1553798

  • RE: Parsing out email address in FROM field

    i see where the error is.

    in your initial cte you have the following

    with cte as

    (

    select 1 as listid, [To] as tolist from tblDoc where [To]IS not null AND [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]

    October 26, 2012 at 6:16 pm

    #1553459

  • RE: Just taken new Job as a SQL Server DBA, can anyone recommend some learning material?

    Dave Morris (10/18/2012)

    Hi Bugg,

    I think 'Trounbleshooting SQL Server, A Guide for Accidental DBAs' by Johnathan Kehayias and Ted Krueger, would be a good read before you start. It's available on...

    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]

    October 26, 2012 at 5:00 pm

    #1553449

  • RE: The client was unable to reuse a session with SPID 157, which had been reset for connection pooling. The failure ID is 29.

    here is the best microsoft connect item on the issue http://connect.microsoft.com/SQLServer/feedback/details/540092/sql-server-2008-sp1-cu6-periodically-does-not-accept-connections

    im guessing the event id is 18056? if so the above will have allot of information. we are...

    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]

    October 26, 2012 at 4:53 pm

    #1553447

  • RE: Index defragmentation script needed for all databases

    Alexander Suprun (10/26/2012)

    http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

    had to fix the url. The link Alex posted is to Ola Hallengren's Database Maintenance Scripts. they are a wonderfully complete scripts for index maintenance.

    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]

    October 26, 2012 at 4:29 pm

    #1553443

  • RE: Parsing out email address in FROM field

    vu_tran764 (10/26/2012)

    Thank you Lowell and Sean! Much appreciated!

    This reply post is for Lowell. I am testing out your codes and I think I'm slightly not getting some part 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]

    October 26, 2012 at 4:23 pm

    #1553441

  • RE: Parsing out email address in FROM field

    Sean Lange (10/26/2012)

    Well it looks like Lowell beat me to the punch on this one. I rolled my own version, which also uses the DelimitedSplit8K function. 😉

    ;with cte 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]

    October 26, 2012 at 4:13 pm

    #1553436

  • RE: Retrieve data between 2 '.'

    Eugene Elutin (10/26/2012)

    ...

    they are all really close over 1 million records

    ...

    If you want your CLR with Regex to perform well you need to declare your Regex object as static 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]

    October 26, 2012 at 4:09 pm

    #1553434

  • RE: how to show single column value (separated by ;) as multiple columns otherwise null

    asita (10/26/2012)

    Thanks for all the man kind

    i great full to al of you

    hisakimatama

    Luis Cazares

    capnhector

    Steven Willis

    i got the answer from hisakimatama, when he gave his first reply, i am...

    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]

    October 26, 2012 at 10:37 am

    #1553296

Viewing 15 posts - 151 through 165 (of 859 total)