Forum Replies Created

Viewing 15 posts - 781 through 795 (of 1,518 total)

  • RE: Is using triggers the only way of auditing updates of table rows?

    noeld (1/6/2009)

    In addition your trigger should only perform the update IF the columns on the "deleted" and "inserted" tables have different values. That way you will be minimizing the impact...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 6, 2009 at 1:12 pm

    #922107

  • RE: Is using triggers the only way of auditing updates of table rows?

    GilaMonster (1/6/2009)

    Marios Philippopoulos (1/6/2009)

    DECLARE @ActionType char(1)

    SELECT @ActionType = CASE

    ...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 6, 2009 at 12:57 pm

    #922088

  • RE: Is using triggers the only way of auditing updates of table rows?

    Regarding my earlier posting:

    Having the trigger takes the onus away from the developers of remembering to include the right code in all their sproc code. The trigger is part of...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 6, 2009 at 12:45 pm

    #922067

  • RE: Is using triggers the only way of auditing updates of table rows?

    GSquared (1/6/2009)

    If you can guarantee that the only way for this data to be updated is by procs, then including the update date and user in the procswould be better,...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 6, 2009 at 12:31 pm

    #922050

  • RE: Is using triggers the only way of auditing updates of table rows?

    GilaMonster (1/6/2009)

    Marios Philippopoulos (1/6/2009)

    Is there a more efficient way of doing this than using a trigger?

    The only other way requires that all access to the table is via known stored...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 6, 2009 at 12:19 pm

    #922041

  • RE: Is using triggers the only way of auditing updates of table rows?

    GilaMonster (1/6/2009)

    Marios Philippopoulos (1/6/2009)

    DECLARE @ActionType char(1)

    SELECT @ActionType = CASE

    ...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 6, 2009 at 10:28 am

    #921953

  • RE: High count of version-store pages in tempdb

    Using the method in my previous posting, I found the culprit: it is an UPDATE trigger on a large table.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 6, 2009 at 8:02 am

    #921807

  • RE: High count of version-store pages in tempdb

    Thank you all for your input.

    According to this link - http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx#E4CAC - the features generating version-store records in tempdb are:

    • Snapshot isolation

    • Read committed snapshot isolation (RCSI)

    • Online...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 4, 2009 at 8:04 am

    #920856

  • RE: High count of version-store pages in tempdb

    Piotr Rodak (1/3/2009)

    Have you tried to select from sys.dm_tran_version_store?

    Regards

    Piotr

    I took a look at http://msdn.microsoft.com/en-us/library/ms186328(SQL.90).aspx. I need to get session and task-level info on the process that gives rise to the...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 3, 2009 at 9:13 pm

    #920819

  • RE: High count of version-store pages in tempdb

    Thank you both, I'll have a look at your suggestions.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 3, 2009 at 9:03 pm

    #920818

  • RE: Sourcesafe-related Error when opening project in BIDS - VSS bindings are lost

    Luke L (12/31/2008)

    Sounds like perhaps your VSS database has been corrupted. Do you have admin rights to your VSS database? Can you log into it with the VSS...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 31, 2008 at 11:04 am

    #919763

  • RE: Sourcesafe-related Error when opening project in BIDS - VSS bindings are lost

    I found the problem.

    I was somehow missing the following 2 registry entries. After adding, the VSS bindings are restored.

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SourceSafe\SCCServerName - value: Microsoft Visual SourceSafe

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SourceSafe\SCCServerPath - value: path for file ssscc.dll

    See...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 31, 2008 at 11:03 am

    #919762

  • RE: SQL Server Agent failure - service restarted on its own!

    DBADave (12/29/2008)

    Is the server you had a problem with also on the SAN?

    Yup, but it's not clustered.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 29, 2008 at 1:48 pm

    #918606

  • RE: SQL Server Agent failure - service restarted on its own!

    DBADave (12/29/2008)

    Since it's clustered the data is on a SAN. I'm guessing there is an equivelant tool to chkdsk, but I'm not sure I understand the connection. What...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 29, 2008 at 1:43 pm

    #918601

  • RE: SQL Server Agent failure - service restarted on its own!

    DBADave (12/29/2008)

    I no longer have the exact log messages since the log has wrapped, but it essentially stated the SQL Server Agent had a problem and needed to be restarted....

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 29, 2008 at 1:33 pm

    #918593

Viewing 15 posts - 781 through 795 (of 1,518 total)