Forum Replies Created

Viewing 15 posts - 541 through 555 (of 1,518 total)

  • RE: Reporting Services Performance Counters

    David-Leibowitz (12/1/2009)

    It's out...

    Check the links.

    Excellent, thanks again!

    __________________________________________________________________________________
    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 1, 2009 at 9:42 am

    #1085923

  • RE: Reporting Services Performance Counters

    David 62010 (12/1/2009)

    Check out the SQLScrubs project. First release targets SSRS 2008. Extracts execution log data into a DW, and provides a set of reports so you can track slow...

    __________________________________________________________________________________
    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 1, 2009 at 9:38 am

    #1085919

  • RE: Error Loading Type Library/DLL

    amy26 (11/30/2009)

    Wow, that post is so old! I can't remember what the problem was originally related to...but I believe I had to reinstall it. 🙂

    Then I'm on the right...

    __________________________________________________________________________________
    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 30, 2009 at 10:50 am

    #1085566

  • RE: Error Loading Type Library/DLL

    I'm having the same issue with SSIS, BIDS 2008.

    I'm at the point where I'm thinking to uninstall and re-install BIDS...

    __________________________________________________________________________________
    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 30, 2009 at 10:37 am

    #1085549

  • RE: Is AWE needed in 64-bit SQL?

    george sibbald-364359 (11/9/2009)

    I don't have 64 bit systems to check what actually happens, but that is definitely what the CSS blog says.

    Here is another link that is also quite relevant...

    __________________________________________________________________________________
    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 12, 2009 at 12:02 pm

    #1078520

  • RE: Getting non-sensical values of free MemToLeave Space in Virtual SQL-2008 environment

    I realize now that this is because this query is measuring VIRTUAL memory, which in 64-bit is enormous.

    What I'm actually after is the largest chunk of PHYSICAL memory available 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]

    November 12, 2009 at 11:08 am

    #1078497

  • RE: Is AWE needed in 64-bit SQL?

    george sibbald-364359 (11/9/2009)

    I don't think you actually enable AWE, that sp_configure option has no effect on a 64 bit system. It is used behind the scenes in 64 bit 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]

    November 9, 2009 at 10:08 am

    #1076759

  • RE: Is AWE needed in 64-bit SQL?

    Silverfox (11/9/2009)

    Marios Philippopoulos (11/9/2009)

    Can someone explain to me, in simple terms, why enabling AWE is a good idea in 64-bit SQL?

    The following msdn link supports this idea, although, with due...

    __________________________________________________________________________________
    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 9, 2009 at 9:55 am

    #1076751

  • RE: 3rd-party enterprise-level backup tools - Should DBAs still be in charge of backups/restores?

    There has to be a compelling reason for choosing a 3rd-party tool over SQL backups.

    If a process isn't broken, what are we fixing?

    The trouble is, oftentimes the decision 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]

    November 6, 2009 at 7:39 am

    #1075899

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

    Paul Hayes-294329 (10/29/2009)

    a resource semaphore wait type is typically waiting on a memory grant, check pending/outstanding memory grants in perfmon. That's normally because a query plan has compiled in 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]

    October 30, 2009 at 12:36 pm

    #1073326

  • RE: 3rd-party enterprise-level backup tools - Should DBAs still be in charge of backups/restores?

    Here is an interesting link on a COMMVAULT bug:

    http://www.siusic.com/wphchen/a-commvault-galaxy-qinetix-bug-experienced-in-restoring-sql-server-database-186.html

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

    October 27, 2009 at 9:37 am

    #1071296

  • RE: SQL CLR code needed to replace fn_regex_split

    Thanks all for the lively debate, I have followed it with interest.

    Well, here is the snippet of C# code I am going with; I'm parsing a (mostly NULL) table column...

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

    October 20, 2009 at 11:13 am

    #1068360

  • RE: SQL CLR code needed to replace fn_regex_split

    Thanks guys, I will take a look at that thread.

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

    October 14, 2009 at 9:08 am

    #1065756

  • RE: SQL CLR code needed to replace fn_regex_split

    Jeff Moden (10/10/2009)

    You don't need a CLR for this...

    http://www.sqlservercentral.com/articles/T-SQL/63003/

    Thanks, I will certainly take a close look; I just took a quick glance at your article, and it looks very interesting.

    I...

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

    October 13, 2009 at 3:28 am

    #1065104

  • RE: Operations Manager Custom Collection

    Try this:

    http://technet.microsoft.com/en-us/library/dd767418.aspx

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

    October 6, 2009 at 10:04 am

    #1062368

Viewing 15 posts - 541 through 555 (of 1,518 total)