Forum Replies Created

Viewing 15 posts - 766 through 780 (of 1,518 total)

  • RE: Error when running "get-wmiobject"

    Jeffrey Williams (1/8/2009)

    Can you try the following and see what happens?

    $computer = 'name of computer';

    Get-WmiObject -ComputerName $computer Win32_Service | Where-Object {$_.Name -like 'MSSQL$*'} | Select Name, StartMode, State, Status;

    That ran...

    __________________________________________________________________________________
    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 8, 2009 at 9:59 am

    #923483

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

    TheSQLGuru (1/8/2009)

    It is my belief that even if you rewrite the trigger to only do the audit update on rows where something is different between inserted and deleted the trigger...

    __________________________________________________________________________________
    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 8, 2009 at 9:18 am

    #923441

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    jesse.roberts (1/8/2009)

    Great thank you so much Marios. This would be a big help I've been trying to modify it myself but am a novice with sql.

    Jesse

    No problem.

    The SQL 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 8, 2009 at 9:06 am

    #923420

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    jesse.roberts (1/8/2009)

    Hey Marios

    Thanks for the reply. I can get operations manager to supress the alert creation using alert suppression. When creating an alert generating rule against an NT event log...

    __________________________________________________________________________________
    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 8, 2009 at 8:57 am

    #923406

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    jesse.roberts (1/7/2009)

    Hey Marios

    I've been looking for something like this for a while. We don't really want to store the data for future analysis on a seperate db. Is there anyway...

    __________________________________________________________________________________
    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 8, 2009 at 3:33 am

    #923169

  • RE: SQL Server Profiler: Help needed monitoring one specific store procedure

    sweetpea_3007 (1/7/2009)

    hai all..

    i want to know, how to make sql profiler running daily?

    thanks

    You just need to script out your profiler session with all your chosen events, columns, filters and other...

    __________________________________________________________________________________
    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 8, 2009 at 3:13 am

    #923166

  • RE: Error when running "get-wmiobject"

    Jeffrey Williams (1/7/2009)

    The only thing I can suggest is remote into that system and verify that you can access WMI. I have seen things like this when WMI was...

    __________________________________________________________________________________
    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 7, 2009 at 6:42 pm

    #923027

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

    noeld (1/6/2009)

    Don't forget to post back with the results ... 😉

    Will do.

    __________________________________________________________________________________
    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 7, 2009 at 4:04 am

    #922406

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

    matt stockham (1/6/2009)

    Having seen your post that lead to this one, is your real problem with the performance or in the space taken in tempdb? If it is just...

    __________________________________________________________________________________
    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 3:41 pm

    #922236

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

    GSquared (1/6/2009)

    To clarify, the decision as to whether to include it in a trigger or not is based on coding needs, not on performance.

    If the table will ever be updated...

    __________________________________________________________________________________
    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 2:52 pm

    #922206

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

    GSquared (1/6/2009)

    Just had another thought. You could accomplish much the same thing as the complex join statement by using an Except query between inserted and deleted and then joining...

    __________________________________________________________________________________
    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 2:38 pm

    #922190

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

    GSquared (1/6/2009)[hr

    This is a trigger-only structure, since it uses the inserted and deleted columns in the Where clause, so that's not the issue here.

    Mea culpa, I don't know 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]

    January 6, 2009 at 2:36 pm

    #922185

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

    noeld (1/6/2009)

    By the way if the columns are "nullable" you need three way comparison like:

    (

    i.col1 <> d.col1

    or (i.col1 is null and d.col1 is not null)

    or (i.col1 is not null and...

    __________________________________________________________________________________
    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 2:21 pm

    #922170

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

    GSquared (1/6/2009)

    On the point of making sure the inserted and deleted tables are different, a trigger can look like this:

    update MyTable

    set LastUpdate = getdate(), LastUpdateBy = user

    from dbo.MyTable

    inner join...

    __________________________________________________________________________________
    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 2:11 pm

    #922165

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

    GSquared (1/6/2009)

    On the point of halving the row versions:

    Let's say you have a table with people's names in it, and LastUpdate (datetime) and LastUpdateBy (varchar) columns.

    So, you issue a command...

    __________________________________________________________________________________
    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:39 pm

    #922138

Viewing 15 posts - 766 through 780 (of 1,518 total)