Forum Replies Created

Viewing 15 posts - 826 through 840 (of 1,518 total)

  • RE: Service Broker as a better alternative to linked servers?

    SQLBOT (11/19/2008)

    I've dabbled a bit with SB from a custom maintenance job perspective and might have some insight.

    What you can do is set up a queue on each server 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]

    November 19, 2008 at 4:48 pm

    #900792

  • RE: An Introduction to the Service Broker

    Here are the steps that worked (finally) for me:

    Login as 'sa' on your local sql 2005 server.

    Create a new database

    In a new query window, run this script: ALTER DATABASE...

    __________________________________________________________________________________
    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 18, 2008 at 12:59 pm

    #900150

  • RE: An Introduction to the Service Broker

    Here are the steps that worked (finally) for me:

    Login as 'sa' on your local sql 2005 server.

    Create a new database

    In a new query window, run this script: ALTER DATABASE...

    __________________________________________________________________________________
    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 18, 2008 at 12:56 pm

    #900149

  • RE: Service Broker as a better alternative to linked servers?

    Steve Jones - Editor (11/17/2008)

    Marios,

    What are you trying to do? They usually perform separate actions, but if you are looking to just update another server, I might recommend looking at...

    __________________________________________________________________________________
    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 18, 2008 at 8:15 am

    #899953

  • RE: SQL Server Newbie Needs Advice on Setup and Backup

    I'm not an expert on RAID configurations, but RAID 5 is the bare minimum and should be avoided if you can help it.

    Here is my 0.2 c on the file...

    __________________________________________________________________________________
    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 16, 2008 at 4:42 am

    #899062

  • RE: DR Strategy with virtual machines?

    I have heard that Microsoft does not officially support virtualized SQL Server installations. This might be a huge problem if one requires support for an emergency in the production environment.

    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]

    November 16, 2008 at 4:33 am

    #899061

  • RE: why sql jobs are still running even if I disabled the jobs

    How do you disable the jobs, through the SSMS UI or through script?

    If through script, you must use the msdb proc sp_update_job:

    EXEC msdb.dbo.sp_update_job @job_name = @jobName, @enabled = 0;

    __________________________________________________________________________________
    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 16, 2008 at 4:00 am

    #899060

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

    HarryH (11/14/2008)

    I appreciate the detailed reply, Marios. You certainly seem to understand the position I am in - looking at SCOM with a view to using it for some useful...

    __________________________________________________________________________________
    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 15, 2008 at 8:24 am

    #898981

  • RE: SSIS package failed run in a job to recognize the CSV file location

    Loner (11/13/2008)

    It is a network account and it can access the file when I sign on using that account. But when I put it in the job and it...

    __________________________________________________________________________________
    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 14, 2008 at 1:24 pm

    #898861

  • RE: Does my SQLCLR code contain a memory leak?

    Jonathan Kehayias (11/13/2008)

    Post the value of SELECT @@VERSION, as well as the output of DBCC MEMORYSTATUS into this thread. Also what is the physical hardware configuration of the server...

    __________________________________________________________________________________
    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 14, 2008 at 1:11 pm

    #898850

  • RE: Does my SQLCLR code contain a memory leak?

    Sorry guys, wasn't able to get back to this sooner.

    The full error is the following:

    Msg 10314, Level 16, State 11, Line 3

    An error occurred in the Microsoft .NET Framework while...

    __________________________________________________________________________________
    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 14, 2008 at 1:04 pm

    #898845

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

    HarryH (11/13/2008)

    I'm not convinced how truly practical or useful this really is...

    I haven't used SCOM in anger yet, but have been thrown it by my manager to take 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]

    November 14, 2008 at 8:18 am

    #898634

  • RE: SSIS package failed run in a job to recognize the CSV file location

    Loner (11/13/2008)

    I created a SSIS package to import data from a CSV file from a different server and when I ran it in SSIS, it was fine.

    The file location is...

    __________________________________________________________________________________
    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 13, 2008 at 10:52 am

    #898211

  • RE: upgrade only Analysis Services...

    schep021 (11/13/2008)

    Good morning. We have a request from a user to upgrade ONLY Analysis Services from sql server 2000 to 2005 and leave the rest running in 2000. ...

    __________________________________________________________________________________
    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 13, 2008 at 10:46 am

    #898208

  • RE: Benefits of dbcmptlevel=80 vs 90 ?

    Would moving a database from a SQL 2000 to a SQL 2005 instance, while keeping it at comp. level 80, incur a performance hit (relative to its performance in 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]

    November 13, 2008 at 9:00 am

    #898156

Viewing 15 posts - 826 through 840 (of 1,518 total)