Forum Replies Created

Viewing 15 posts - 241 through 255 (of 465 total)

  • RE: charindex patindex substring

    girl_bj (8/19/2014)


    7/5/2014 0:0:0 DEPARTURE AUS UK 7/5/2014 18:21:0 7/5/2014 20:45:0 ARRIVAL 7/5/2014 19:10:0 7/5/2014 23:30:0

    that DEPARTURE and ARRIVAL

    Okay, inserting such strings is trivial, but how do we determine WHERE to...

  • RE: charindex patindex substring

    girl_bj (8/19/2014)


    i have a long list of string that look like this:

    7/5/2014 0:0:0 AUS UK 7/5/2014 18:21:0 7/5/2014 20:45:0 7/5/2014 19:10:0 7/5/2014 23:30:0

    how can i add in some indicator in...

  • RE: Stuck stored procedure

    Found it - there are a series of chained VBScript routines that activate all this, and one of them was sending a bad parameter to the stored procedure. Simple mistake,...

  • RE: Index grows really fast!

    murnilim9 (7/23/2014)


    pdanes (7/23/2014)


    murnilim9 (7/22/2014)


    pdanes (7/22/2014)


    murnilim9 (7/22/2014)


    pdanes (7/22/2014)


    twin.devil (7/22/2014)


    I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which...

  • RE: Index grows really fast!

    murnilim9 (7/22/2014)


    pdanes (7/22/2014)


    murnilim9 (7/22/2014)


    pdanes (7/22/2014)


    twin.devil (7/22/2014)


    I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can...

  • RE: Index grows really fast!

    murnilim9 (7/22/2014)


    pdanes (7/22/2014)


    twin.devil (7/22/2014)


    I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can see in...

  • RE: Index grows really fast!

    twin.devil (7/22/2014)


    I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can see in the procedure,...

  • RE: Index grows really fast!

    murnilim9 (7/21/2014)


    twin.devil (7/21/2014)


    If you are loading large data in that particular table where you have created the index, then you can use disable and restore approach which can increase your...

  • RE: disk space 90% full...

    Jeff Moden (7/21/2014)


    pdanes (7/21/2014)


    samking (7/21/2014)


    If the disk contains only data files...than what action we have to take......

    If the disk contains only data files and is 90% full, then you will...

  • RE: disk space 90% full...

    samking (7/21/2014)


    If the disk contains only data files...than what action we have to take......

    If the disk contains only data files and is 90% full, then you will need a bigger,...

  • RE: Stuck stored procedure

    Sean Lange (7/21/2014)


    How long does your procedure take? I am wondering if your are running into concurrency issues because you have multiple backups being run at the same time. 15...

  • RE: Why Primary Keys can be important on large tables

    Interesting article, but there is no explanation of WHY declaring a primary key caused the database to shrink, or why not having one caused excessive growth.

  • RE: Transfer data from SQL Server to MySQL

    patrickmcginnis59 10839 (6/19/2014)


    pdanes (6/19/2014)


    patrickmcginnis59 10839 (6/19/2014)


    He claims to be out of ideas, and I can't think of what else I might try to help him. Everything works for me, so...

  • RE: Transfer data from SQL Server to MySQL

    patrickmcginnis59 10839 (6/19/2014)


    He claims to be out of ideas, and I can't think of what else I might try to help him. Everything works for me, so I have difficulty...

  • RE: Field definition in view

    Sean Lange (4/23/2014)


    Can you simply cast your stuffed column as a varchar?

    SELECT VLTO.SkupinaAutoID, cast(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(STUFF

    ...

Viewing 15 posts - 241 through 255 (of 465 total)