Forum Replies Created

Viewing 15 posts - 481 through 495 (of 1,518 total)

  • RE: How can I find out whether XACT_ABORT is ON or OFF at instance level?

    Thank you, that worked!

    Why so complicated to get a simple setting back?? :w00t:

    __________________________________________________________________________________
    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 3, 2010 at 2:27 pm

    #1176192

  • RE: IDERA SQL Virtual Database - too good to be true?

    Lowell (5/26/2010)

    is there a downloadable demo of this, even crippleware for using only the Adventureworks db or something?

    this sounds too good to be true, so I'd like to see 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]

    May 26, 2010 at 8:47 am

    #1172787

  • RE: IDERA SQL Virtual Database - too good to be true?

    Steve Jones - Editor (5/25/2010)

    Hyperbac, owned by Red Gate now, does something similar. You can work with a backup file as though it were a real database. The Hyperbac demo...

    __________________________________________________________________________________
    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 25, 2010 at 2:29 pm

    #1172348

  • RE: Monitoring Your Servers : Data Collection vs. Performance Advisor

    Thank you for all the information;

    I will certainly keep an eye out for upcoming news and documentation of the SQL Sentry Performance Advisor and will be visiting your blog.

    __________________________________________________________________________________
    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, 2010 at 2:35 pm

    #1169749

  • RE: Retrieving Dimension-Data Access Permissions with AMO

    This seems like a good starting point:

    http://msftasprodsamples.codeplex.com/wikipage?title=SS2008!Readme_AMOAdventureWorks&referringTitle=Home

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

    April 28, 2010 at 9:14 am

    #1159037

  • RE: Retrieving Dimension-Data Access Permissions with AMO

    Thanks, I'll look around on the web.

    It's frustrating that BOL has barely no code samples in the sections that describe the Analysis Services classes.

    I find links like the one below...

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

    April 28, 2010 at 7:57 am

    #1158932

  • RE: Retrieving Dimension-Data Access Permissions with AMO

    stevefromOZ (4/26/2010)

    Let's start with what is shown in SSMS. I right-click on one of my custom roles, select Properties and click on Dimension Data.

    I don't think I understand what 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]

    April 27, 2010 at 2:57 pm

    #1158531

  • RE: Retrieving Dimension-Data Access Permissions with AMO

    stevefromOZ (4/26/2010)

    Any hints on the discrepancies? (ie something is there in SSMS but not in the output of your insert; or perhaps the permissions themselves differ slightly) Not...

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

    April 26, 2010 at 2:45 pm

    #1157900

  • RE: Cube partition not refreshing when proactive caching enabled and cache set to be updated when data changes in datasource

    That's correct, I have opened a case with MS on this issue, still no resolution.

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

    April 20, 2010 at 11:00 am

    #1154789

  • RE: Need to find out which of the SSIS packages stored in msdb reference a specific shared datasource

    Elliott W (4/15/2010)

    You could build a VB or C# app to open the packages one-by-one and examine the connections collection. I *think* you can read them directly from 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]

    April 16, 2010 at 8:51 am

    #1152895

  • RE: Need to find out which of the SSIS packages stored in msdb reference a specific shared datasource

    Marios Philippopoulos (4/15/2010)

    I need to find out which of the SSIS packages stored in msdb reference a specific shared datasource, dtsrc1.

    System view sysssispackages does not seem to be the way...

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

    April 15, 2010 at 12:00 pm

    #1152343

  • RE: How do I map SQL-authentication logins to a database snapshot?

    Thanks both for the insightful answers.

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

    April 10, 2010 at 9:14 am

    #1149570

  • RE: How do I map SQL-authentication logins to a database snapshot?

    Jeffrey Williams-493691 (4/9/2010)

    First, you have to create the login on the secondary server with the same SID that exists on the primary server. Lookup CREATE LOGIN in BOL for...

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

    April 10, 2010 at 5:56 am

    #1149548

  • RE: Frequently fragmented indexes

    Another consideration:

    Lowering the fillfactors will reduce READ performance on index scans.

    I guess nothing is for free... 🙂

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

    April 9, 2010 at 10:05 am

    #1149245

  • RE: Increase in backup Log size during rebuild index.

    Also look into lowering the fill factors of your indexes so that they do not get fragmented as often.

    See discussion in http://www.sqlservercentral.com/Forums/Topic892938-1550-2.aspx#bm898207.

    I use this query to find the usage statistics...

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

    April 9, 2010 at 12:15 am

    #1148836

Viewing 15 posts - 481 through 495 (of 1,518 total)