Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 18,926 total)

  • RE: Database can't be recovered? Any help would be appreciated!!!

    Is the db in the db list?

    Is the server case sensitive?

  • RE: Moving Terabyte Databases

    steveb. (7/20/2011)


    I would go for the backup/restore method outlined above over the dettach/attach as this way you can have minimal downtime.

    Also if you move the db and even...

  • RE: Moving Terabyte Databases

    You can do that in multiple steps to.

    Take full backup, copy to new location and restore (norecovery).

    Then the day before the move, take a diff and move / restore.

    During the...

  • RE: Are the posted questions getting worse?

    bopeavy (7/20/2011)


    Ninja's_RGR'us (7/20/2011)


    SQLRNNR (7/20/2011)

    --------------------------------------------------------------------------------

    Jannie-186227 (7/20/2011)

    --------------------------------------------------------------------------------

    ahem.

    How do you reply to a thread with 23 thousand replies?

    Is there any more value to be added in this thread?

    Cheers

    Jannie

    Plenty of...

  • RE: SSRS - Export report into CSV File

    Guesses...

    do you have hidden columns in the report?

    Do you have calculated columns?

    do you have matrixes or groups to create new columns?

    AFAIK, csv exports the raw data, nothing really formatted.

  • RE: That case filter

    cfradenburg (7/20/2011)


    I can't think of any SQL stories where I've done something on a similar level even though I know they do exist. What does come to mind is...

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/20/2011)


    Jannie-186227 (7/20/2011)


    ahem.

    How do you reply to a thread with 23 thousand replies?

    Is there any more value to be added in this thread?

    Cheers

    Jannie

    Plenty of value - all watercooler - or...

  • RE: Are the posted questions getting worse?

    GilaMonster (7/20/2011)


    Ninja's_RGR'us (7/20/2011)


    What's the level of the material you'll be covering? I'm interested but not if you stay in the 100-200 level most of the day... I might...

  • RE: Are the posted questions getting worse?

    GilaMonster (7/20/2011)


    Jim Murphy (7/20/2011)


    As a tip: I would love to actually practice on my lappy in the class. Kind of a "do like I'm doing" sort of thing. Not...

  • RE: I Want Stupid Employees

    sturner (7/20/2011)


    anelson 66875 (7/20/2011)


    "Training" is dead - for IT jobs anyway. Training, as in getting somebody up to speed on a routine repeatable task like, say, machining an engine...

  • RE: PK/FK on a same column, INSERT fails

    That error is rally clear. It means that the pk value is already in the table (or twice in the data set you're inserting).

    Try doing select PkKey FROM (select...

  • RE: SQL server shuts off after Backup...any ideas?

    homebrew01 (7/20/2011)


    Ninja's_RGR'us (7/20/2011)


    bernard black (7/20/2011)


    Find out what bars you've been at on Sat night. Get someone to monitor your behavior when you leave the bar.

    I don't get it, care...

  • RE: DataFile size and the log file size

    GilaMonster (7/20/2011)


    Wow, normally people are complaining that the log file is too big...

    Leave the files alone unless you have a really good reason to do otherwise.

    Ya that's a nice change...

  • RE: I Want Stupid Employees

    Grant Fritchey (7/20/2011)


    I really like that picture... well, the left side of it anyway.

    Hey Grant, where can I buy it? 😉

  • RE: That case filter

    Rob Schripsema (7/20/2011)


    Toreador (7/20/2011)


    My original thought was that there would be no rows returned as this was an insert.

    But I then thought that was silly, and I was being unfair...

Viewing 15 posts - 4,696 through 4,710 (of 18,926 total)