Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/20/2011)

    On a semi-technical note, can I just say that I figured out how to do a JOIN to an UNPIVOT without using a derived table in the mix?

    I'm...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 20, 2011 at 11:47 am

    #1355907

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/20/2011)

    Stefan Krzywicki (7/20/2011)

    Tom.Thomson (7/19/2011)

    SQLRNNR (7/19/2011)

    When is a table not a table?

    OK, it's a table. It maybe has four legs (one at each corner) and a plane top. ...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 20, 2011 at 11:45 am

    #1355906

  • RE: Are the posted questions getting worse?

    Tom.Thomson (7/19/2011)

    SQLRNNR (7/19/2011)

    When is a table not a table?

    OK, it's a table. It maybe has four legs (one at each corner) and a plane top. Or maybe it's...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 20, 2011 at 2:07 am

    #1355412

  • RE: Are the posted questions getting worse?

    Shame you can't see who is in the lead in voting. When are the results to be announced?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 19, 2011 at 12:11 pm

    #1355088

  • RE: Are the posted questions getting worse?

    GSquared (7/18/2011)

    I've had two different people from South Africa try to convince me that Afrikaans is "more original". They didn't seem to be trying to pull my leg, but...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 18, 2011 at 2:01 pm

    #1354482

  • RE: Restoring From Backup

    ALZDBA (7/15/2011)

    Mind me tossing in my all time favorit when it comes to what the log is all about and why your choice of recovery model matters ?

    - Managing Transaction...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 15, 2011 at 7:06 am

    #1353412

  • RE: Restoring From Backup

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

    sure. Why don't you do what you want??

    Sorry, I'm not sure what you're referring to here.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 2:39 pm

    #1353109

  • RE: Restoring From Backup

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

    Stefan Krzywicki (7/14/2011)

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

    Then why waste the ressources on the logs? Just move to simple if you don't need PIT recovery.

    Because it is likely that at some point...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 2:04 pm

    #1353091

  • RE: Restoring From Backup

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

    Then why waste the ressources on the logs? Just move to simple if you don't need PIT recovery.

    Because it is likely that at some point in the near...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 1:45 pm

    #1353081

  • RE: Restoring From Backup

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

    CheckDB reads all used pages. So if that works then you're good.

    The only thing left is to check all the backups (fulls, diffs, logs).

    And NO verify only is...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 1:31 pm

    #1353071

  • RE: Restoring From Backup

    Mostly I'm looking to know if dbcc is enough to know that the restore of the database is good. Do I need to do rowcount, sums, etc... of different tables...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 1:08 pm

    #1353053

  • RE: Are the posted questions getting worse?

    Might I ask for some opinions on this post?

    I haven't done much with the maintenance side of SQL Server yet and this is the first time I'll be involved in...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 11:33 am

    #1353000

  • RE: Are the posted questions getting worse?

    GSquared (7/14/2011)

    Stefan Krzywicki (7/14/2011)

    GSquared (7/14/2011)

    Stefan Krzywicki (7/12/2011)

    GSquared (7/12/2011)

    Unless you define a social contract as "anything two or more people agree to, even if the agreement is coerced", you can't call...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 10:56 am

    #1352974

  • RE: Are the posted questions getting worse?

    jcrawf02 (7/14/2011)

    Stefan, we have the luxury of contributing because we choose to (anticipating the mutual benefit), but that benefit was hard-won by those who did it because they were coerced...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 10:15 am

    #1352945

  • RE: Are the posted questions getting worse?

    GSquared (7/14/2011)

    Stefan Krzywicki (7/12/2011)

    GSquared (7/12/2011)

    Unless you define a social contract as "anything two or more people agree to, even if the agreement is coerced", you can't call the laws of...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    July 14, 2011 at 9:56 am

    #1352928

Viewing 15 posts - 1,576 through 1,590 (of 2,838 total)