Forum Replies Created

Viewing 15 posts - 496 through 510 (of 1,518 total)

  • RE: Frequently fragmented indexes

    Jeff Moden (4/8/2010)

    JDixon-385826 (4/8/2010)

    fill factor 80 seems a little low - I would review the fill factor you are most likely cauing more page splits than needed

    A low fill factor...

    __________________________________________________________________________________
    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 8, 2010 at 8:19 pm

    #1148755

  • RE: Frequently fragmented indexes

    Nadrek (4/8/2010)

    What's the Fill Factor on the indexes with the fragmentation issues?

    If you're doing updates or inserts throughout the values of the index, I would recommend trying a value lower...

    __________________________________________________________________________________
    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 8, 2010 at 10:30 am

    #1148459

  • RE: Frequently fragmented indexes

    JDixon-385826 (4/7/2010)

    if you have enough resources and enterprise edition you should be able to do the operation online and only rebuild if you need to. I would start with looking...

    __________________________________________________________________________________
    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 7, 2010 at 3:16 am

    #1147151

  • RE: Error in System Log: "The SQL Server Analysis Services (xxxxxx) service terminated unexpectedly. It has done this x time(s)."

    Here is what's on the SQLDUMPER_ERRORLOG.log file:

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1908

    (1158:1718) 04/06/10 09:05:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0

    (1158:1718) 04/06/10...

    __________________________________________________________________________________
    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 6, 2010 at 11:58 am

    #1146689

  • RE: NOLOCK hint and Read Committed Snapshot Isolation Level (RCSI)

    Paul White NZ (4/4/2010)

    Marios Philippopoulos (4/4/2010)

    The database code in our system is littered with NOLOCK hints, and we are considering switching to Read Committed Snapshot Isolation (RCSI) in the near...

    __________________________________________________________________________________
    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 4, 2010 at 11:23 am

    #1145481

  • RE: DTEXEC thorws error saying Argument "Excel" for option "connection" is not valid.

    sneugebauer (11/19/2008)

    I had same problem, but I got it working by adding two \" inside the quotes of "Excel Connection Manager", that it works. So it looks like 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]

    April 1, 2010 at 10:26 am

    #1144209

  • RE: Frequently fragmented indexes

    Jeff Moden (3/31/2010)

    Marios Philippopoulos (3/30/2010)

    I'm on SQL 2008 SP1, Enterprise Ed.

    Since you have the Enterprise Edition, I'd consider partitioning the table and the indexes so they can be more easily...

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

    March 31, 2010 at 2:23 pm

    #1143471

  • RE: Frequently fragmented indexes

    CirquedeSQLeil (3/30/2010)

    10% fragmentation seems like an awfully low threshold. I've been in environments where we didn't touch it unless it was 50% (1TB plus databases). Then we would...

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

    March 31, 2010 at 5:50 am

    #1142988

  • RE: Frequently fragmented indexes

    I'm on SQL 2008 SP1, Enterprise Ed.

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

    March 30, 2010 at 1:15 pm

    #1142611

  • RE: Frequently fragmented indexes

    GSquared (3/30/2010)

    Are the indexes used for range scans, or for selecting single rows?

    Good question; I guess it points to a 2nd strategy, finding out which of these "problem" indexes are...

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

    March 30, 2010 at 9:44 am

    #1142374

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

    Thank you for the article.

    I have been struggling to figure out what each of the metrics means in the SQL Sentry Performance Advisor dashboard, and I must admit I am...

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

    March 26, 2010 at 3:46 pm

    #1140804

  • RE: SQLAgentReaderRole can create its own jobs! What is MS thinking??

    Toby White (3/26/2010)

    One further note - for the step type T-SQL the step is actually executed under the context of the owner. You can test this out easily enough by...

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

    March 26, 2010 at 9:59 am

    #1140480

  • RE: SQLAgentReaderRole can create its own jobs! What is MS thinking??

    Toby White (3/26/2010)

    It doesn't matter that much because they would be the owner o the job, and could not do anything inside the job for which they do not have...

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

    March 26, 2010 at 7:34 am

    #1140331

  • RE: Unable to view reports in report designer, BIDS - they appear as XML

    Problem solved; we had to upgrade SSRS to SQL 2008 SP1; there was a version incompatibility with the other SQL components installed on the user's machine (SP1 was already installed...

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

    March 22, 2010 at 11:48 am

    #1137726

  • RE: Being alerted when a certain stored procedure is blocked

    dmoldovan (3/22/2010)

    You're welcome.

    Please share your solution with us, if you have time...

    Will do, 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]

    March 22, 2010 at 5:36 am

    #1137504

Viewing 15 posts - 496 through 510 (of 1,518 total)