Viewing 7 posts - 46 through 52 (of 52 total)
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...
May 15, 2003 at 4:57 pm
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...
May 15, 2003 at 4:47 pm
If the following thread doesn't answer your questions, please provide more information as to what you are trying to achieve.
May 15, 2003 at 4:44 pm
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...
May 15, 2003 at 4:41 pm
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...
May 15, 2003 at 4:36 pm
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...
May 15, 2003 at 4:32 pm
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.
May 15, 2003 at 4:26 pm
Viewing 7 posts - 46 through 52 (of 52 total)