Forum Replies Created

Viewing 15 posts - 601 through 615 (of 1,518 total)

  • RE: How current is the data contained in a full database backup?

    GilaMonster (5/30/2009)

    The data pages are backed up as the backup process reads them, so pages early in the file may be as they were at the beginning of the backup,...

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

    May 30, 2009 at 4:34 am

    #1002382

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

    marc.schmieder (5/28/2009)

    Marios,

    We tried to run the script form the command line and he get an error. Are we supposed to use the computer name as a parameter on 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]

    May 28, 2009 at 1:34 pm

    #1001712

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

    marc.schmieder (5/27/2009)

    When does data get added to the central DB? We have this setup and we saw data get added once, but it hasn't worked since then. 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]

    May 28, 2009 at 7:29 am

    #1001393

  • RE: A Simple Approach to SQL Server 2005 Encryption

    nagendrareddy.kolli (5/24/2009)

    Hi,

    Can some one send me the article which was talking about in the below.

    "Found this article useful as a newbie to encryption methods. A dept in our company has...

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

    May 27, 2009 at 6:18 pm

    #1001150

  • RE: Need CLR replacements for OLE Automation procedures

    RBarryYoung (5/22/2009)

    Marios Philippopoulos (5/20/2009)

    Hi,

    Anyone have CLR code for replacing the functionality offered by the following procedures?

    sp_OACreate

    sp_OADestroy

    sp_OAGetErrorInfo

    sp_OAGetProperty

    sp_OAMethod

    sp_OASetProperty

    sp_OAStop

    Also, currently on our SQL-2000 instance, these procedures are being used for making web-service calls....

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

    May 22, 2009 at 3:06 pm

    #999208

  • RE: Need CLR replacements for OLE Automation procedures

    Jonathan Kehayias (5/22/2009)

    What kind of service are you trying to call? There are generally 2 types, standard .NET webservices that have a ASMX that you can reference as a...

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

    May 22, 2009 at 3:01 pm

    #999203

  • RE: Need CLR replacements for OLE Automation procedures

    Jonathan Kehayias (5/21/2009)

    These call into COM which is UNSAFE in SQLCLR. Usually you can get away from COM completely and into a managed provider for what you want to...

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

    May 21, 2009 at 10:49 am

    #998400

  • RE: Security risks of turning on OLE Automation Procedures?

    EdVassie (5/21/2009)

    I think in SQL 2005 and above the OA procs can only be accessed by folks with Sysadmin authority. This means that anything monitoring your server has very...

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

    May 21, 2009 at 9:05 am

    #998325

  • RE: Security risks of turning on OLE Automation Procedures?

    Steve Jones - Editor (5/20/2009)

    To me the risk is instability in the OLE item, or perhaps a misundertanding of how it can be used by the admin. What if 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]

    May 20, 2009 at 9:00 am

    #997670

  • RE: Security risks of turning on OLE Automation Procedures?

    FNS (4/8/2009)

    There's a push to get some sort of enterprise wide SQL monitoring software running which doesn't touch the "live" servers but runs entirely on it's own server, monitoring from...

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

    May 20, 2009 at 8:30 am

    #997637

  • RE: Obtaining accurate SQL Server performance metrics in a virtual environment

    Andrew Hatfield (5/17/2009)

    Virtualisation is a great tool - however you still need to test your particular environment. Also, not all solutions meet the requirements of every problem - eg,...

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

    May 19, 2009 at 8:31 am

    #997031

  • RE: Obtaining accurate SQL Server performance metrics in a virtual environment

    Here is what caught my attention:

    Traditional SQL Server performance monitoring uses the Microsoft Windows performance monitor tool PerfMon to collect statistics. SQL Server integrates with PerfMon to provide familiar counters...

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

    May 14, 2009 at 9:07 am

    #994611

  • RE: Obtaining accurate SQL Server performance metrics in a virtual environment

    David Benoit (5/14/2009)

    Interestingly enough, I am working with MS to assess that right now. I have been assured that the DMV's should be accurate in the Virtual environment as they...

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

    May 14, 2009 at 8:47 am

    #994594

  • RE: Obtaining accurate SQL Server performance metrics in a virtual environment

    Thank you for the useful input.

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

    May 14, 2009 at 8:42 am

    #994591

  • RE: Server becomes very slow [RESOURCE_SEMAPHORE] waittype.

    noeld (5/13/2009)

    Marios Philippopoulos (5/13/2009)

    TheSQLGuru (10/24/2008)

    Can you please tell us which bug it was in CU9 that was causing the problem? I checked and cannot find any FIX from 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]

    May 13, 2009 at 1:42 pm

    #994044

Viewing 15 posts - 601 through 615 (of 1,518 total)