Browse By Tags
Home
»
All Tags
»
ASP
»
.NET API
»
SQL
COM
custom_tables
Data Model
eWareQuery Object
Indexes
Performance
Query
Record Object
System Administration
Blog Post:
Discovering Data Relationships in Code
Jeff Richards
You may have a business requirement to cascade a change through the child records of a company. I have discussed previously how a table level script can be used to update all opportunities if the company is reassigned to a new account manager. See the article " A Table Level Script to update Opportunities...
on
13 Sep 2010
Blog Post:
MSSQL Index analysis and creation from Sage CRM (Part 1 of 2)
Jeff Richards
This article has come from a very experienced colleague in Australia. Introduction Microsoft SQL Server 2005 added new system tables to assist in the system reporting. Three of these tables in particular are written to every time a query is run. Microsoft SQL Server 2005 processes each query, determines...
on
5 Mar 2009