Forum Replies Created

Viewing 15 posts - 48,436 through 48,450 (of 59,065 total)

  • RE: Cursor

    Heh... you keep adding scope to the problem, Simon. Not a problem but it would be nice to know the whole problem at once. For example, where did...

    September 2, 2008 at 8:28 pm

    #866316

  • RE: Debugger For SQL

    Carl Federl (9/2/2008)

    Jeff & GSquared:

    Did either of you get a chance to perform any additional analysis ?

    No, I sure haven't... my apologies. Have a new job with 1:10+ commute...

    September 2, 2008 at 7:58 pm

    #866312

  • RE: How to improve insert performance

    James Horsley (9/2/2008)

    It may be better to have a different index as the clustered index - obviously this might hurt performance elsewhere so it would require testing and a lot...

    September 2, 2008 at 7:54 pm

    #866310

  • RE: database and transaction logs on same drive?

    Yeaup... but if you loose the disk where the log file is, you're still going to miss data regardless of backups.

    September 2, 2008 at 7:52 pm

    #866309

  • RE: Delete File Without xp_cmdshell

    Peso (9/2/2008)

    A CLR procedure maybe?

    Heh... better be limited to only the directory being worked on or you might as well open up xp_CmdShell.

    September 2, 2008 at 7:44 pm

    #866307

  • RE: Problem with the text data column, variable

    I'm pretty sure you don't need PATINDEX if you prewrap the string to be split in delimiters... please see the section titled "One Final "Split" Trick with the Tally...

    September 2, 2008 at 7:41 pm

    #866306

  • RE: swap data between 3 fields?

    The 96 columns you're talking about each identify a region id for a person... and, I imagine that you have some nulls on each row. To normalize the table,...

    September 2, 2008 at 7:31 pm

    #866303

  • RE: Table Update

    Thanks for the feedback...

    September 2, 2008 at 7:27 pm

    #866302

  • RE: disabled component to install

    kiran4tech (9/2/2008)

    Thanks for the information Jeff

    -Kiran

    You bet... thank you for the feedback.

    September 2, 2008 at 7:24 pm

    #866301

  • RE: export data of all table to RAW files

    manish.jain (9/1/2008)

    Hi,

    Thanks for your reply,

    At this stag i am dumb... i am looking for some other good solution.

    Would you please suggest me any other good way?

    Thanks

    Manish Jain

    I'm...

    September 2, 2008 at 7:21 pm

    #866300

  • RE: Understanding Index defragmentation

    gcg_wilkinson (9/2/2008)

    I've found that even if u defrag an index and the physical disk is fragmented, then the index will remain fragmented.

    That would also be true. A disk defrag...

    September 2, 2008 at 7:14 pm

    #866299

  • RE: Compare Source Tables rows and destination Tables rows

    Is there no way to simply do a COUNT(*) from each source and compare the two?

    September 2, 2008 at 7:11 pm

    #866297

  • RE: Text file to sql server

    Then, you have several choices. A couple of them include...

    1. BCP the file in using a format file.

    2. Import the entire width of a file into a...

    September 1, 2008 at 10:07 pm

    #865822

  • RE: Text file to sql server

    Also, what are the delimiters between columns in the files? If fixed field, what is the starting position and length of each column?

    September 1, 2008 at 8:51 pm

    #865814

  • RE: disabled component to install

    kiran4tech (9/1/2008)

    I am trying to install sql server 2005 Enterprise edition

    That would require that the machine you are installing it on be running WINDOWS SERVER. It's not gonna work....

    September 1, 2008 at 8:12 pm

    #865811

Viewing 15 posts - 48,436 through 48,450 (of 59,065 total)