Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 1,518 total)

  • RE: clustered index and pK

    Another very good reason for not setting the PK as a clustered index: some other column may be a better candidate for the clustered index, based on the type 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]

    July 15, 2008 at 5:57 pm

    #843463

  • RE: restoring T-logs in single shot

    rinu philip (7/15/2008)

    WITH NORECOVERY to WITH RECOVERY

    For the above can some one explain what is their difference?

    As for the last trans log to be restored we specify with recovery...

    __________________________________________________________________________________
    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 15, 2008 at 2:09 pm

    #843396

  • RE: how to find no. of instances installed on single sql sever 2005

    It's possible to write a powershell script to enumerate through all services available on the server and pick only those pertaining to SQL (2000, 2005).

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

    #843361

  • RE: Need to exclude Local Admins from admin access to Analysis Services

    Gift Peddie (7/15/2008)

    Hi,

    I have very good news for you because your second post explains the problem in detail and it was not easy to find but Microsoft Isreal posted 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]

    July 15, 2008 at 10:27 am

    #843233

  • RE: estimate memory requirement

    shahab (7/15/2008)

    Well avg life expectancy has been going down steadily. at this point its near 800. my db's are fully indexed. so again back to same question. how to estimate...

    __________________________________________________________________________________
    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 15, 2008 at 10:07 am

    #843221

  • RE: Need to exclude Local Admins from admin access to Analysis Services

    Gift Peddie (7/14/2008)

    I really don't understand your question but if you want to exclude anybody in SSAS you can do with DENY permissions because SSAS service permissions are more granular...

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

    #843090

  • RE: SQL Server Integration Services missing from services

    Patricia Johnson (7/14/2008)

    Just to update this post, Here is the message that is received from the job history:

    Message

    Executed as user: TUSCDC\ATSAdmin. Microsoft (R) SQL Server Execute Package Utility Version...

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

    #842762

  • RE: Problems collecting SSAS 2005 perfmon counters

    I found the problem. The startup account for the Performance Logs and Alerts service has to be Local System. After doing that, the problem is gone!

    __________________________________________________________________________________
    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 10, 2008 at 8:51 am

    #840886

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

    Jeff Moden (7/7/2008)

    I don't know why folks say that CLR's perform better and are more scalable... it's absolutely not true in about 99% of the cases and several of us...

    __________________________________________________________________________________
    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 7, 2008 at 9:23 am

    #838989

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

    Jeff Moden (7/7/2008)

    Marios Philippopoulos (7/7/2008)

    2) Are you allowed to use sp_OA* procedures?

    I don't know much about sp_OA* procedures, but I think they come with their own baggage of problems, 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]

    July 7, 2008 at 8:36 am

    #838946

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

    Matt Miller (7/7/2008)

    Marios Philippopoulos (7/7/2008)

    Matt Miller (7/7/2008)

    I hate to say it - but you CAN change the errors if you so desire. Just don't have the CLR code "throw"...

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

    #838933

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

    Jeff Moden (7/7/2008)

    Thanks,

    Just a couple more questions...

    1) Which date are you listing... Create, Modified, or Last Accessed?

    2) Are you allowed to use sp_OA* procedures?

    3) Do you really need 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]

    July 7, 2008 at 8:16 am

    #838922

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

    Matt Miller (7/7/2008)

    I hate to say it - but you CAN change the errors if you so desire. Just don't have the CLR code "throw" the error again: instead...

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

    #838914

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

    Jeff Moden (7/6/2008)

    Marios Philippopoulos (5/30/2008)

    I have a SQL CLR sproc that lists the contents of a folder.

    Just curious... what columns are you returning fo this?

    Here is some sample output:

    Date ...

    __________________________________________________________________________________
    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 7, 2008 at 7:39 am

    #838881

  • RE: Looking for SCOM 2007 training in Toronto Ontario

    Vivien Xing (7/6/2008)

    Just read this post today. Are you still looking for the course?

    http://www.cmstraining.ca/CourseDetails.aspx?CourseId=56&Product=SCOM

    Implementing Operations Manager (SCOM 2007)

    July 16 - 18

    September 03 - 05

    I heard that the instructor 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]

    July 6, 2008 at 7:22 am

    #838589

Viewing 15 posts - 1,066 through 1,080 (of 1,518 total)