Forum Replies Created

Viewing 15 posts - 41,221 through 41,235 (of 49,552 total)

  • RE: Printing from CLR throws an exception

    Um..

    The CLR proc runs on the server, within the database server. Where do you think it's going to print to?

    What exception is it throwing?

    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

    February 3, 2009 at 12:18 pm

    #937431

  • RE: Some tables won't replicate because they do not have primary keys defined

    noeld (2/3/2009)

    Fail back with "peer-to-peer" is a non issue 😉

    True. I was thinking Transactional.

    I keep forgetting about peer-to-peer because I've never experimented with it.

    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

    February 3, 2009 at 12:16 pm

    #937427

  • RE: SQL Injection

    NotManyPoints (2/3/2009)

    More that they have an awareness and be somewhat ‘up to speed’ as it were in their chosen profession.

    Would that go for every aspect of the database...

    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

    February 3, 2009 at 12:13 pm

    #937425

  • RE: SQL Injection

    ex__inferis (2/3/2009)

    So in a way I am not critisizing him. I'm actually critisizing all of you for replying, however correctly and kindly, in a way that someone doing his best...

    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

    February 3, 2009 at 12:04 pm

    #937417

  • RE: Where does the uncommitted updated data gets stored ??

    santhosh (2/3/2009)

    If our database is in simple recovery mode. Is there any chance to overwrite the uncommitted data by any other user?

    Recovery model has no effect on how transactions 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

    February 3, 2009 at 11:57 am

    #937409

  • RE: Some tables won't replicate because they do not have primary keys defined

    The you want mirroring, not replication. Replication is for when you need a reporting database or similar. It does create a copy, but the failover's not immediate and the fail...

    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

    February 3, 2009 at 11:49 am

    #937403

  • RE: Guest Editorial: And Now; a Recitation

    RBarryYoung (2/3/2009)

    It's a metaphor for territorial acquisition and control. I would think that any loyal subject in the crown's empire would be able to relate to that... 😀

    We call...

    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

    February 3, 2009 at 11:48 am

    #937402

  • RE: statement runs very slow what have I done wrong or what could I change to make it better

    Table definition and index definitions please?

    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

    February 3, 2009 at 10:09 am

    #937307

  • RE: Some tables won't replicate because they do not have primary keys defined

    Why are you replicating the sharepoint databases? What's the end goal?

    Should I use SS2K5 database mirroring in a production environment?

    Why not? What's your concern?

    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

    February 3, 2009 at 10:05 am

    #937298

  • RE: audittrace.trc

    What drive is the C2 trace been written to? That's the drive that's out of space.

    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

    February 3, 2009 at 10:04 am

    #937295

  • RE: Where does the uncommitted updated data gets stored ??

    santhosh (2/3/2009)

    Now where does this value get stored temporarily ??? Does it store this value in tempdb or does it use log files for this purpose ??

    Neither. That 1000 is...

    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

    February 3, 2009 at 10:03 am

    #937293

  • RE: SQL Injection

    NotManyPoints (2/3/2009)

    Jonathan Kehayias (2/3/2009)

    There are plenty of decent DBA/Developers out there that don't know about SQL Injection. Just look at the number of major sites that have been hit...

    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

    February 3, 2009 at 10:00 am

    #937290

  • RE: statement runs very slow what have I done wrong or what could I change to make it better

    Grant Fritchey (2/3/2009)

    This is going to cause the query to run slow since it has to run this query for every row of data in the FROM clause. Best to...

    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

    February 3, 2009 at 9:54 am

    #937280

  • RE: Changed to a StarWars Avatar...am I part of the Club now?

    Grant Fritchey (2/3/2009)

    Any Babylon 5 fans?

    Entil'zha Veni. In Valen's Name!

    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

    February 3, 2009 at 9:51 am

    #937275

  • RE: Changed to a StarWars Avatar...am I part of the Club now?

    Christopher Stobbs (2/3/2009)

    wow I got so confused on a thread earlier today when someone was posting a thanks to Gail, and I was thinking to myself, well I don't see...

    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

    February 3, 2009 at 9:14 am

    #937237

Viewing 15 posts - 41,221 through 41,235 (of 49,552 total)