Forum Replies Created

Viewing 15 posts - 24,151 through 24,165 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    WayneS (8/15/2011)

    GilaMonster (8/15/2011)

    All that tech talk's reminded me I need to spec and order my new server.

    2TB internal storage and 1 TB external sound enough for now?

    Only if you're...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 7:24 am

    #1368592

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/15/2011)

    GilaMonster (8/15/2011)

    All that tech talk's reminded me I need to spec and order my new server.

    2TB internal storage and 1 TB external sound enough for now?

    What about...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 7:09 am

    #1368579

  • RE: Are the posted questions getting worse?

    All that tech talk's reminded me I need to spec and order my new server.

    2TB internal storage and 1 TB external sound enough for now?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 6:29 am

    #1368559

  • RE: problem on @@ROWCOUNT

    Is there a trigger on the table? Is that SELECT @@rowcount the VERY NEXT statement after the update?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 6:16 am

    #1368551

  • RE: How do I get an entry level job with a cert?

    Ninja's_RGR'us (8/15/2011)

    GilaMonster (8/15/2011)

    Kiara (8/15/2011)

    No matter what career field you want to move into, you might want to rethink the way you both think about women and talk about them...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 6:13 am

    #1368550

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/15/2011)

    He's young and male. Therefore, he's a moron.

    My take too, and why I mostly ignored that comment. Plus for the last year I've been working with a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 6:10 am

    #1368546

  • RE: How do I get an entry level job with a cert?

    Kiara (8/15/2011)

    No matter what career field you want to move into, you might want to rethink the way you both think about women and talk about them - because...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 5:51 am

    #1368534

  • RE: Studying for 70-432; using SQL 2008R2 instead of 2008?

    You can use R2. There were just about no core database changes between 2008 and 2008 R2.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 4:48 am

    #1368505

  • RE: Transaction log is growing on Mirrored database

    The principal database is in full recovery (has to be) as such you MUST back it up or the log will grow until it fills the drive. It's not optional.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2011 at 4:47 am

    #1368503

  • RE: How do I get an entry level job with a cert?

    SQL Kidd (8/14/2011)

    This is one of my primary concerns. I fear not having the accreditation will actually make me look like an unqualified person.

    At this point you are...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 14, 2011 at 11:51 pm

    #1368457

  • RE: Are the posted questions getting worse?

    No, as long as you don't use any paid services, like their cloud services (it doesn't have my credit card).

    That's just so you can easily add books. You can add...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 14, 2011 at 11:23 pm

    #1368456

  • RE: we got this error during a db import

    Those aren't SQL Server errors. Maybe from whatever tool you're using to import.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 14, 2011 at 5:05 pm

    #1368431

  • RE: How do I get an entry level job with a cert?

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

    BI is by far the hardest job I've had. You need to know EVERYTHING about the business to do a good job. Even a competent BI dev...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 14, 2011 at 4:56 pm

    #1368430

  • RE: Does querying a view extract values for all rows before WHERE?

    During the parsing phase SQL replaces the view names with the view definitions. That's done before the optimiser starts. So what the optimiser sees is not

    SELECT * FROM MyView WHERE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 14, 2011 at 4:54 pm

    #1368429

  • RE: Are the posted questions getting worse?

    Anyone want to add anything here: http://www.sqlservercentral.com/Forums/Topic1158751-10-1.aspx. Looks like the guy's making decisions for all the wrong reasons, lot of arrogance of youth there too

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 14, 2011 at 2:51 pm

    #1368414

Viewing 15 posts - 24,151 through 24,165 (of 49,552 total)