Tag Archives: other

SQL Server creates a histogram on the leading key but not on the other columns

the leading key should be the most selective column—number in our case. Allegedly (according to the recommendation), SQL Server creates a histogram on the leading key but not on the other columns; so if you follow the recommendation, the optimizer … Continue reading

Posted in SQL Server | Tagged , , , , , | Comments Off on SQL Server creates a histogram on the leading key but not on the other columns

ADP can link to other sources?

I have used this information hundreds of times.. in order to connect to remote databases using Access Data Projects. I’ll bet that 90% of the Access MVPs don’t know how to do this! http://office.microsoft.com/en-us/access-help/linking-to-external-data-sources-in-an-access-project-HA001056337.aspx

Posted in Uncategorized | Tagged , | Comments Off on ADP can link to other sources?