Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 1,518 total)

  • RE: Error running perfmon counters for Analysis Services

    Mani Singh (7/3/2008)

    did you Login using Administrator Authentication, before running the Memory Counters.

    Thanks for the response.

    Yes, I'm connecting as an admin.

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

    July 4, 2008 at 2:13 pm

    #838440

  • RE: How do I throw custom errors from SQLCLR code back to calling T-SQL?

    Thank you, I 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]

    July 2, 2008 at 8:44 pm

    #837578

  • RE: Analysis Services - Enterprise vs. Standard Edition

    Mani Singh (6/29/2008)

    Well, you can check your Cube(s) (Analysis Services Database) Complexity against Performance.

    If you have Many Dimensions and Fact Tables and Millions of Rows and it is a performance...

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

    June 30, 2008 at 10:26 am

    #836250

  • RE: sql assemblies in .net

    Jonathan Kehayias (6/28/2008)

    More thn anything else, UDT's and UDF's are easily used out side of SQL. This is of great benefit for things like geocoding where the UDT 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]

    June 28, 2008 at 11:55 am

    #835789

  • RE: sql assemblies in .net

    For the purposes of this debate, what is the point of invoking SQLCLR code outside a SQL context?

    I'm wondering if this is even necessary.

    What are the possible scenarios for this?...

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

    June 28, 2008 at 7:10 am

    #835751

  • RE: Which db objects need to be re-created when the SQLCLR dll is modified?

    Jonathan Kehayias (6/27/2008)

    (1) Create a new schema that will hold the SQLCLR objects

    (2) Create an asymmetric key from the assembly dll

    (3) Create a login from the asymmetric key

    (4) Grant EXTERNAL-ACCESS-ASSEMBLY...

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

    June 28, 2008 at 7:05 am

    #835749

  • RE: Analysis Services - Enterprise vs. Standard Edition

    Dan English (6/27/2008)

    First of all you won't be limited to the number of processors you can utilize on the server. SSAS Enterprise will provide parallel processing capabilities, partitioning your...

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

    June 27, 2008 at 4:00 pm

    #835657

  • RE: sql assemblies in .net

    The purpose of a SQLCLR assembly is for it to be invoked from within SQL code.

    You don't need to call it from .NET code.

    What is your assembly doing?

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

    June 26, 2008 at 10:26 am

    #834831

  • RE: Linked-Server error: unable to begin distributed transaction

    Federico del Blanco (6/25/2008)

    LinkedServer properties:

    ServerOption -> RCP = True?

    Yes, that was already in place.

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

    June 25, 2008 at 2:03 pm

    #834271

  • RE: Linked-Server error: unable to begin distributed transaction

    We figured it out.

    The server name of the server on which the query was running was added to the hosts file of the target server (the server pointed 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]

    June 25, 2008 at 10:39 am

    #834139

  • RE: Is Integration Services Faster than a Linked Server for Importing Data?

    Thank you for the response.

    The queries we are using for inserting/updating data (thousands of rows) through a linked server are very slow at the moment, that's why I thought 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]

    June 24, 2008 at 9:35 am

    #833390

  • RE: Analysis Services 2005 - any good books out there?

    dan griffin (6/23/2008)

    I use WROX - Professional SQL Server Analysis Service with MDX. I've only started to design cubes, but the fundamental concepts in this book seem good. I still...

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

    June 23, 2008 at 9:35 am

    #832812

  • RE: What kind of monitoring does Mom\Scom can do for sqlserver

    A good starting point is reading through this link:

    Microsoft SQL Server Management Pack:

    http://technet.microsoft.com/en-us/library/cc511079(TechNet.10).aspx

    Out of the box SCOM monitors a limited subset of things, such as service and database availability 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]

    June 19, 2008 at 7:57 am

    #831113

  • RE: AWE enabled yes or no?

    The sticky point with all this is that because of all the potential issues surrounding a move to 64-bit, many companies will hesitate to go ahead with it.

    Sure, one...

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

    June 18, 2008 at 11:01 am

    #830646

  • RE: SCOM question: I cannot get blocking alerts to work

    Grant Fritchey (6/18/2008)

    There's not a good source for this information. Experimentation is how I'm getting by.

    I can recommend three sources that can help, in addition to posting here (althouth...

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

    June 18, 2008 at 8:21 am

    #830484

Viewing 15 posts - 1,081 through 1,095 (of 1,518 total)