Forum Replies Created

Viewing 15 posts - 361 through 375 (of 1,518 total)

  • RE: SQL CLR error caused by memory pressure(?) - need help to troubleshoot

    Thank you!

    __________________________________________________________________________________
    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 25, 2011 at 12:31 pm

    #1278106

  • RE: DMV query to get at data stored in tempdb tables, as well as metadata information on currently active tempdb tables

    Thank you all for your replies.

    __________________________________________________________________________________
    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 21, 2011 at 6:37 am

    #1276507

  • RE: DMV query to get at data stored in tempdb tables, as well as metadata information on currently active tempdb tables

    Thank you, will try that.

    __________________________________________________________________________________
    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 19, 2011 at 12:46 pm

    #1275526

  • RE: Sorted UPDATE statement with hierarchical self-join

    What's wrong with the DDL I posted?

    __________________________________________________________________________________
    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 14, 2010 at 11:48 am

    #1262396

  • RE: Sorted UPDATE statement with hierarchical self-join

    andrewd.smith (12/13/2010)

    How do you identify top-level nodes, that is rows where the PrevID column does not reference any other parent row? Is the PrevID column NULL valued in this 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]

    December 13, 2010 at 2:32 pm

    #1261941

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

    Keith Mescha (12/9/2010)

    I have this solution partly implemented. I have recently upgraded quite a few servers to Windows 2008 R2 and SQL 2008 R2 and just found out that 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]

    December 9, 2010 at 9:34 am

    #1260634

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

    Srinivas-490730 (11/5/2010)

    Marios.

    Thanks for posting the MP and the relevant scripts.. It helped me a lot.

    I also want to know if we can modify these scripts to alert on long running...

    __________________________________________________________________________________
    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 9, 2010 at 9:20 am

    #1260622

  • RE: Should DBAs allow UNSAFE SQLCLR Assemblies in production environment?

    GSquared (12/8/2010)

    On the subject of what's in the DLLs, you may not be able to verify it yourself, but you can insist on a level of code-review and sign-off by...

    __________________________________________________________________________________
    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 8, 2010 at 2:32 pm

    #1260326

  • RE: Should DBAs allow UNSAFE SQLCLR Assemblies in production environment?

    Geoff A (12/8/2010)

    i have run into these type of issues before. COTS products and 3rd party vendors are always the culprits.

    the only thing i ever demanded was that for those...

    __________________________________________________________________________________
    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 8, 2010 at 1:50 pm

    #1260309

  • RE: Should DBAs allow UNSAFE SQLCLR Assemblies in production environment?

    GSquared (12/8/2010)

    It's kind of a big subject.

    The security issues come from a couple of factors. First, have you verified the contents of the DLLs that you're loading as assemblies?...

    __________________________________________________________________________________
    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 8, 2010 at 11:51 am

    #1260253

  • RE: Error when configuring SQL job step to execute powershell script

    It turned out the ps1 file was readonly; as soon as I made it read-write, issue was fixed.

    Silly eh? 🙂

    __________________________________________________________________________________
    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 8, 2010 at 9:51 am

    #1260189

  • RE: Checking whether a new snapshot can be created from a mirror before dropping old snapshot

    Thank you!

    __________________________________________________________________________________
    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 2, 2010 at 4:53 pm

    #1258166

  • RE: Which process and memory

    OK, 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]

    November 23, 2010 at 11:26 am

    #1254640

  • RE: Which process and memory

    swjohnson (3/19/2007)

    RAM,

    Since this is a SQL 2005 forum, I assume you are using SQL 2k5. As such, you can use some of the Dynamic Management Views (DMV) to tell you...

    __________________________________________________________________________________
    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]

    November 23, 2010 at 11:07 am

    #1254621

  • RE: Full-Text Search Upgrade from SQL 2005 to SQL 2008

    Thank you, that's what I had gathered from reading BOL, I just wanted to make sure I understood correctly.

    It seemed too good to be true... 🙂

    __________________________________________________________________________________
    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]

    November 22, 2010 at 12:58 pm

    #1253980

Viewing 15 posts - 361 through 375 (of 1,518 total)