Forum Replies Created

Viewing 15 posts - 21,376 through 21,390 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/4/2012)

    Great, so you'll be done by friday 4PM?

    L8rs :hehe:

    Should be easily possible. Friday 28th December 2012, 4pm PST.

    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

    January 4, 2012 at 9:07 am

    #1428405

  • RE: Doing inserts within a select statement?

    erikpoker (1/4/2012)

    Yes i know its not the "vanilla" way to go. But unfortunalty i am left with no other option as far as i can see... 🙁

    It's far more than...

    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

    January 4, 2012 at 7:48 am

    #1428317

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/4/2012)

    On a slightly different note, I was looking into some linked server issues and found a comment in this Microsoft article http://msdn.microsoft.com/en-us/library/ms188279.aspx that MS doesn't recommend the use...

    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

    January 4, 2012 at 7:36 am

    #1428311

  • RE: Are the posted questions getting worse?

    Dev (1/4/2012)

    Brandie Tarvin (1/4/2012)

    ...

    On a slightly different note, I was looking into some linked server issues and found a comment in this Microsoft article http://msdn.microsoft.com/en-us/library/ms188279.aspx that MS doesn't...

    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

    January 4, 2012 at 7:34 am

    #1428305

  • RE: Protecting data from administrators

    Short of encrypting the data in the application layer and keeping the encryption keys somewhere away from the database, there's no way to do this.

    Column encryption (with the exception of...

    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

    January 4, 2012 at 7:32 am

    #1428302

  • RE: Doing inserts within a select statement?

    Potentially resulting in duplicate key errors, DTC transaction problems, inconsistent behaviour and other such fun.

    If you want to go that way, it's your database and your application, but that 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

    January 4, 2012 at 7:26 am

    #1428292

  • RE: In Log shipping ,primary database log file is full....

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    January 4, 2012 at 7:16 am

    #1428289

  • RE: Doing inserts within a select statement?

    erikpoker (1/4/2012)

    So if the foreign key is null, well then i would just like to insert a.col2 and a.col3 into the parent-table and get an autogenerated primarykey back.

    That part 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

    January 4, 2012 at 7:06 am

    #1428278

  • RE: Doing inserts within a select statement?

    You can't insert within a select. You can have a select within an insert (INSERT ... SELECT), or select the output of an insert (via the OUTPUT clause), but 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

    January 4, 2012 at 3:56 am

    #1428162

  • RE: How to protect my Database.

    If the customer is putting the database onto a server that they control, they will have full control over that database and there is no way you can prevent that.

    This...

    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

    January 4, 2012 at 3:54 am

    #1428161

  • RE: Managing Transaction Logs

    DBCC ShrinkFile(<name of log file>,<size log file was before abnormal growth>)

    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

    January 4, 2012 at 2:29 am

    #1428138

  • RE: Back-up strategy

    Providing the latest backup is undamaged at the time it's restored, yes. If it is damaged, then you'd have to go back to the previous one, meaning 2 or so...

    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

    January 4, 2012 at 2:25 am

    #1428135

  • RE: Deadlock Issues

    atchristian (1/3/2012)

    I created a clustered index per your suggestion. A side question before I dive into this more. With a table of ten million entries and growing by about 60,000...

    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

    January 4, 2012 at 2:22 am

    #1428134

  • RE: How to protect my Database.

    amitsingh308 (1/4/2012)

    Now I want to protect my database from unauthorized used of database. No one can take back up of my database or restore it or can’t attach mdf file...

    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

    January 4, 2012 at 2:17 am

    #1428133

  • RE: Are the posted questions getting worse?

    Henrico Bekker (1/3/2012)

    How can I convince my manager, and company that its a great idea to send me to SQL 2012 Launch?/quote]

    I'm not even trying. I have a very expensive...

    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

    January 4, 2012 at 2:10 am

    #1428130

Viewing 15 posts - 21,376 through 21,390 (of 49,552 total)