Forum Replies Created

Viewing 15 posts - 27,616 through 27,630 (of 49,552 total)

  • RE: temp table (#) Vs Dynamic Table (@)

    Andreas Goldman (2/23/2011)

    operations on table variables are not logged

    Myth, not true

    http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/

    stored procedures using them could be precompiled (while sps with temp tables cannot) etc.

    Stored procedures are never pre-compiled....

    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 23, 2011 at 9:52 pm

    #1290724

  • RE: Possible to have ALTER TRACE permission without being in sysadmin role???

    Alter trace does not mean sa privileges. It's a permission like any other and can be assigned to anyone.

    However, since it's shared hosting I can understand the concern, just not...

    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 23, 2011 at 9:49 pm

    #1290722

  • RE: "Truncate table" and transaction logs

    Truncate table is logged. All data modifications are logged. That said, truncate will not appear as a delete because it's not.

    If only some of the records disappeared, it could not...

    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 23, 2011 at 9:43 pm

    #1290720

  • RE: Why is my transaction log full?

    Chet Xemoka (2/23/2011)

    Can you elaborate on why long-running backups can result in significant transaction log growth?

    Or at least point to an explanation and example.

    From the article:

    The active portions of 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 23, 2011 at 9:40 pm

    #1290719

  • RE: Why is my transaction log full?

    Abi Chapagai (2/22/2011)

    We can also get the specific database with sys.databases with where condition.

    select * from sys.databases

    where name = 'DBName'

    I always use with this condition so that i...

    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 22, 2011 at 1:22 pm

    #1290083

  • RE: Are the posted questions getting worse?

    GSquared (2/22/2011)

    Not sure what you mean by "protecting with CLR", unless you mean "hiding it in a DLL and hoping nobody gets the dev files".

    Protecting as in 'preventing...

    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 22, 2011 at 1:16 pm

    #1290078

  • RE: Preventing thiefs from reverse enginnering stored procedures

    Steve Jones - SSC Editor (2/22/2011)

    Again, you would know better than us what your system does, but I can tell you that many companies out there, thousands of them, make...

    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 22, 2011 at 1:14 pm

    #1290074

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/22/2011)

    On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting? Not...

    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 22, 2011 at 1:13 pm

    #1290072

  • RE: Preventing thiefs from reverse enginnering stored procedures

    sdffdfad faadffad (2/22/2011)

    And what would you advise to us? To serve to all the competitors de-facto source code on golden plate and share with them results of years of research...

    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 22, 2011 at 1:09 pm

    #1290069

  • RE: Why is my transaction log full?

    Robert Davis (2/22/2011)

    GilaMonster (2/22/2011)

    Maybe you should read my other article on transaction logs Managing Transaction Logs[/url]

    Just read everything Gail has written, and you'll be a better DBA for it.

    😀 Thanks....

    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 22, 2011 at 1:07 pm

    #1290067

  • RE: tasks for dba in developer enviroments

    Koen Verbeeck (2/22/2011)

    I'd argue to give the ETL team read rights in production.

    Disagree. But then my main experience is in a financial environment. The data in those tables is highly...

    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 22, 2011 at 1:06 pm

    #1290063

  • RE: Recovery Model Switching Often

    I'd start by looking at whatever job does your backups...

    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 22, 2011 at 5:56 am

    #1289812

  • RE: 'allow updates' is ON

    Turn it off. It doesn't need to be on for anything, all having it on will do is throw an error when a RECONFIGURE is run.

    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 22, 2011 at 4:34 am

    #1289765

  • RE: Why is my transaction log full?

    Robert Davis (2/21/2011)

    david.howell (2/21/2011)

    Thanks for the very informative article.

    Running the first query I see Simple Recovery model and 'ACTIVE_TRANSACTION'

    However, running DBCC OPENTRAN report "No active open transactions."

    This doesn't seem 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 22, 2011 at 12:57 am

    #1289722

  • RE: Why is my transaction log full?

    ceso (2/21/2011)

    Are you saying that when one issue the command backup log db_name with truncate_only it backs up the active portion and releases the space for re-use ? so 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 22, 2011 at 12:54 am

    #1289720

Viewing 15 posts - 27,616 through 27,630 (of 49,552 total)