Forum Replies Created

Viewing 15 posts - 20,026 through 20,040 (of 49,552 total)

  • RE: Transaction id sql server profiler trace

    Not much unless you have explicit transactions. It is, as its name implies, an ID for the transaction

    So

    BEGIN TRAN

    insert ...

    update ...

    update...

    delete ...

    COMMIT

    will all get the same transactionID, however without the...

    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 29, 2012 at 12:46 am

    #1452937

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/28/2012)

    I didn't pile on, I just tried to explain what that one particular question he was asking regarding updatation and insertion.

    Which, btw, I could interpret just fine, was...

    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 29, 2012 at 12:44 am

    #1452935

  • RE: Protecting Stored Procedures and Where to Put Processing

    Obfuscate yes, but that's all and it won't stop someone who wants your code, and don't think for a second that your app layer is safe if it's also running...

    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 28, 2012 at 4:02 pm

    #1452859

  • RE: Table Optimization for fast retrival

    It's the rules of minimal logging, doesn't matter what table it is, it's syntactical rules.

    See 'Operations that can be minimally logged' and 'Insert' in BoL. Neither is unlogged, but both...

    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 28, 2012 at 3:25 pm

    #1452852

  • RE: Protecting Stored Procedures and Where to Put Processing

    If you distribute the app to some other company, there is nothing you can do to keep them out of the code. You can make it harder, but that's all,...

    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 28, 2012 at 3:08 pm

    #1452843

  • RE: Table Optimization for fast retrival

    Eric M Russell (2/28/2012)

    Also, keep in mind the following when selecting a large interim result into a temp table. If you SELECT INTO the temp table, thus creating it dynamically,...

    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 28, 2012 at 2:52 pm

    #1452832

  • RE: Table fragementation

    Why would you need a cursor for that? If you omit the ObjectID parameter from the index_physical_stats, it runs for the entire DB anyway.

    This is equivalent to the innards 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

    February 28, 2012 at 2:45 pm

    #1452826

  • RE: Can we run log backups during the full backup?

    Yes, you can run log backups during a full backup. As for documentation, try Books Online. Should be in there

    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 28, 2012 at 12:34 pm

    #1452779

  • RE: Protecting Stored Procedures and Where to Put Processing

    Well if it's a web application then you are hosting the database, so you can lock the security down to only your internal staff who, I assume, you trust (if...

    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 28, 2012 at 11:52 am

    #1452760

  • RE: Need help Detachingh DB and Moving files

    If you're just moving files to another drive you don't need to detach. Use ALTER DABASE to set the new location, then take the DB offline, move the files and...

    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 28, 2012 at 11:01 am

    #1452741

  • RE: Suggestion for a good book on SQL Security?

    Denny Cherry. Securing SQL Server.

    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 28, 2012 at 11:00 am

    #1452739

  • RE: 70-461 - SQL Server 2012 Querying a Datbase

    I doubt you'll find any resources until the exams are released. I think June/July has been mentioned.

    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 28, 2012 at 8:12 am

    #1452624

  • RE: Effect in LOG file when procedure is executed

    Joy Smith San (2/28/2012)

    It's a simple proceure. It checks for the data that's passed as Params in the base table.

    If a record allready exists for that GUID, then 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 28, 2012 at 8:11 am

    #1452621

  • RE: Central Management Server with Policy Based Management

    Moved to:http://www.sqlservercentral.com/Forums/Topic1258835-391-1.aspx

    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 28, 2012 at 7:15 am

    #1452583

  • RE: Are the posted questions getting worse?

    Anyone for some interview questions, looks like the same ones from DBA.Stackexchange

    http://www.sqlservercentral.com/Forums/Topic1258844-146-1.aspx

    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 28, 2012 at 7:13 am

    #1452580

Viewing 15 posts - 20,026 through 20,040 (of 49,552 total)