Forum Replies Created

Viewing 7 posts - 46 through 53 (of 53 total)

  • RE: Distribution Statistics

    Statistics DO count toward the limit of indexes allowed on a table. The Query Optimizer will utilize the distribution information from both index statistics blob and the non-index statistics...


    David R Buckingham, MCDBA,MCSA,MCP

  • RE: Config Sql Mail..

    One more tidbit I remembered. Keep your profile name short. There is a known bug regarding long profile names. I believe it rears it's ugly head when...


    David R Buckingham, MCDBA,MCSA,MCP

  • RE: SQL Mail Configuration & Usage

    If the following thread doesn't answer your questions, please provide more information as to what you are trying to achieve.

    http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12236&FORUM_ID=5&CAT_ID=1&Topic_Title=Config+Sql+Mail%2E%2E&Forum_Title=Administration


    David R Buckingham, MCDBA,MCSA,MCP

  • RE: Rebuilding Indexes on System Tables

    Are you wanting to rebuild the indexes on the system tables due to corruption or are you trying to defrag the indexes?

    I routinely use DBCC INDEXDEFRAG on every table in...


    David R Buckingham, MCDBA,MCSA,MCP

  • RE: Enterprise Ed. Migration questions

    There are no issues with backing up/restoring databases between the different editions of SQL Server that I have experienced. We routinely perform exactly that between Developer Edition, Standard Edition...


    David R Buckingham, MCDBA,MCSA,MCP

  • RE: Config Sql Mail..

    To clarify DavidB's answer:

    Both the SQL Server service and SQL Agent service must be running under a named account (not LocalSystem). It may be the same account for both...


    David R Buckingham, MCDBA,MCSA,MCP

  • RE: enterprise manager

    Whether you need a CAL or not depends on the licensing mode of your SQL Servers. If you use per-processor licensing, CALs are not used.


    David R Buckingham, MCDBA,MCSA,MCP

Viewing 7 posts - 46 through 53 (of 53 total)