Forum Replies Created

Viewing 15 posts - 916 through 930 (of 1,518 total)

  • RE: Which index needs the maintenance more?

    From http://msdn.microsoft.com/en-us/magazine/cc135978.aspx:

    Identifying the Most Costly Indexes

    -- Create required table structure only.

    -- Note: this SQL must be the same as in the Database loop given in the following step.

    SELECT TOP...

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

    September 17, 2008 at 1:29 pm

    #873236

  • RE: Missing Indexes in SQL Server 2005

    charles.gary (9/17/2008)

    Isnt this an incorrect filter?

    where d.database_id = d.database_id and d.object_id = d.object_id

    Also you can get more info on this from

    http://msdn.microsoft.com/en-us/library/ms345405(SQL.90).aspx

    This article will show you...

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

    September 17, 2008 at 9:41 am

    #873099

  • RE: High amounts of memory paging

    jsheldon (9/16/2008)

    We have a SQL server that has a hodgepodge of applications. One of the biggest application is SharePoint and as we continue to use our SharePoint server we...

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

    September 16, 2008 at 2:46 pm

    #872712

  • RE: Missing Indexes in SQL Server 2005

    See this great link on the same topic:

    Uncover Hidden Data to Optimize Application Performance:

    http://msdn.microsoft.com/en-us/magazine/cc135978.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]

    September 16, 2008 at 9:05 am

    #872454

  • RE: Missing Indexes in SQL Server 2005

    Gail already mentioned some of the caveats of the missing-index DMVs.

    Here are a couple more:

    (1) Because the data in the DMVs are kept in memory, they are at risk 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]

    September 16, 2008 at 8:27 am

    #872413

  • RE: Developers' access to dev SQL Server

    Jeff Moden (9/14/2008)

    Depends on what type of DBA you have (see previous post). And, again, it doesn't matter if you limit the people on the Dev box or 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]

    September 14, 2008 at 1:27 pm

    #871570

  • RE: Developers' access to dev SQL Server

    rian67 (9/12/2008)

    I understand being a gate keeper is a tough job. But no one has still being able to answer my main question?

    Who handles the creation of Integration Packages, Replication...

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

    September 14, 2008 at 4:49 am

    #871526

  • RE: Where is the value for the max number of ERRORLOG files stored?

    Adam Bean (9/11/2008)

    Yes, or travel directly to the registry ... easiest way is to just use SSMS though.

    I'm looking into automating this, so using the xp is the way 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]

    September 11, 2008 at 12:01 pm

    #870548

  • RE: Where is the value for the max number of ERRORLOG files stored?

    Adam Bean (9/11/2008)

    You can right click SQL Server Logs and go to configure.

    But here is the command:

    EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, X

    Where X is the amount of error logs...

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

    September 11, 2008 at 10:59 am

    #870488

  • RE: Where is the value for the max number of ERRORLOG files stored?

    GilaMonster (9/11/2008)

    It's not stored anywhere in SQL. It's in the registry.

    I can't remember offhand where, easiest way to find where is to run profiler and filter the trace based on...

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

    September 11, 2008 at 9:57 am

    #870437

  • RE: Need help re-organizing query - if possible - so it is more efficient

    Peso (9/9/2008)

    Then you were wrong this time, I am sorry to say.

    Read the query.

    I've been able to convince myself your query is right, based on test samples I've run.

    However, my...

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

    September 9, 2008 at 3:17 pm

    #869323

  • RE: Need help re-organizing query - if possible - so it is more efficient

    Peso (9/9/2008)

    Because you want to filter out ALL records for same coID group if ANY of the records has an mCT = 'Y' value.

    Is that what the original query with...

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

    September 9, 2008 at 8:15 am

    #869071

  • RE: Need help re-organizing query - if possible - so it is more efficient

    Jeff Moden (9/7/2008)

    Can't tell from your last post if your serious or not so I'll assume you're serious. 🙂

    It's a clever bit of code that Peso wrote....

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

    September 7, 2008 at 3:25 pm

    #868259

  • RE: How do I determine Free & Total Space for disk drives, using T-SQL?

    Jason Wisdom (9/5/2008)

    I set the ODBC connection up.

    I went to run it and got an error.

    Need to run; will try it later.

    Thanks a lot for helping.

    If you want to enable...

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

    September 7, 2008 at 8:24 am

    #868223

  • RE: Not able to start SQL agent,getting Error insuffient Memory

    Are there other SQL instances, other SQL services (SSIS, SSAS, SSRS etc) running on this machine?

    Are other applications, beside SQL server, running on the machine?

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

    September 7, 2008 at 8:14 am

    #868222

Viewing 15 posts - 916 through 930 (of 1,518 total)