Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 14,953 total)

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (12/2/2011)


    GSquared (12/2/2011)


    Ninja's_RGR'us (12/2/2011)


    Steve Jones - SSC Editor (12/2/2011)


    Ninja's_RGR'us (12/2/2011)


    Steve Jones - SSC Editor (12/2/2011)


    SQL Server is better than Oracle

    Then why is your server hosted on Oracle?? :hehe:

    /walks away...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Insert file in DB

    Are you talking about storing a file, or about importing data from a file into tables?

    You can store files in BLOB columns, either directly or as filestream objects.

    You can import...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: A Welcome Intruder

    jay holovacs (12/2/2011)


    Steve Jones - SSC Editor (12/2/2011)


    GSquared (12/2/2011)


    We were also attacked by Annonymous a while back, but when they failed to accomplish anything, they changed targets. I guess...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (12/2/2011)


    Steve Jones - SSC Editor (12/2/2011)


    Ninja's_RGR'us (12/2/2011)


    Steve Jones - SSC Editor (12/2/2011)


    SQL Server is better than Oracle

    Then why is your server hosted on Oracle?? :hehe:

    /walks away to better...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: High-level overview question - important SQL topics?

    T-SQL vs PL/SQL is going to vary in importance depending on whether you write database software (scripts, stored procedures, functions, et al), or if you are more purely administrative.

    If your...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/2/2011)


    NHibernate ROCKz

    HEY!! This is supposed to be family-friendly site!

    Filter or no filter, there's going too far, and then there's NHibernate!

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Dropping and restoring DB to fix file fragmentation

    Dev (12/2/2011)


    cfradenburg (12/2/2011)


    Unless reindex hasn't been doing it's job I'm not worried about internal fragmentation. I'll update this post with how it goes (or if we decide...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/2/2011)


    Steve Jones - SSC Editor (12/2/2011)


    Don't be making me add IZ, haz, sertinz and a few more to the "bad words" list here.

    There's a "bad words" list? Let...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Disable all the SQL jobs at once

    Guras (12/2/2011)


    GSquared (12/2/2011)


    Guras (12/1/2011)


    GSquared (12/1/2011)


    Of course, the other option would be to put a first step in those jobs that would check the time/date, and cause the job to abort...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Roy Ernest (12/2/2011)


    Stevie haz givon up in uz.

    Stevie sertinz givez up in uz looooong timez ago.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Dropping and restoring DB to fix file fragmentation

    That should do it, since it'll initiate a new file. Depending on free-space extents on the drive after dropping, you might need to clear the drive off and the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: A Welcome Intruder

    PCI compliance (https://www.pcisecuritystandards.org/) requires periodic scanning by a third party for common/known security issues. We don't store any credit card information, but we still have to get the scans...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Identify the Column for 'String or binary data would be truncated'

    The easy way to find which column is the problem is to change the Insert statement into a Select Into using a temp table as the target, then compare the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/1/2011)


    Hey, guys. Is Gus gone yet?

    GSquared (12/1/2011)


    - GSquared, RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL,...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Disable all the SQL jobs at once

    Guras (12/1/2011)


    GSquared (12/1/2011)


    Of course, the other option would be to put a first step in those jobs that would check the time/date, and cause the job to abort if run...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 2,686 through 2,700 (of 14,953 total)