You are currently browsing the tag archive for the ‘Database’ tag.

As it turns out, database performance issues can easily be created by overdoing the forms. As such, I was just reviewing the SQL Server recommendations, and I found the following interesting fact: with CRM you have roughly 8060 bytes available to store custom fields before theoretically degrading performance.

The following list of data types and size should help in determining if you go over or not. As a note, usually SQL will handle gracefully the overflow.

Data Type Size (bytes)
Lookup 16 bytes
Single Line Text (x length) 2x bytes
Multi Line Text (x length) 2x bytes
Date and Time 8 bytes
Decimal Number 13 bytes
Floating Point Number 8 bytes
Currency 8 bytes
Option Set 4 bytes
Whole Number 4 bytes
Two Options (T/F) 1 byte

 

As you can see from the table above, the most taxing fields are indeed the Single Line Text and Multi Line Text.

There was an issue with field lengths over 4000 characters sync-ing to Outlook (due to SQL Express limitations, as described in the KB938065), but it’s supposed to be fixed now.

Enjoy!

Advertisements
MVP Reconnect

Check out my course [Video]

Dynamics 365 Customer Engagement Administration

Dynamics 365 Customer Engagement Administration

Check out my course [Video]

Configuring and Extending Dynamics 365 Customer Engagement

Configuring and Extending Dynamics 365 Customer Engagement

Check out my course [Video]

Getting Started with Dynamics 365 Customer Engagement

Reviewed Book

Implementing Microsoft Dynamics 365 for Finance and Operations

Implementing Microsoft Dynamics 365 for Finance and Operations

Reviewed Book

Microsoft Dynamics 365 Extensions Cookbook

Microsoft Dynamics 365 Extensions Cookbook

Check out my Book

Microsoft Dynamics CRM 2016 Customization - Second Edition

Microsoft Dynamics CRM 2016 Customization - Second Edition

Check out my Book

Microsoft Dynamics CRM Customization Essentials

Microsoft Dynamics CRM Customization Essentials

Check out my Book

Microsoft Dynamics CRM 2011 Scripting Cookbook

Microsoft Dynamics CRM 2011 Scripting Cookbook

Reviewed Book

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 608 other followers

Follow Dynamics 365 Wizardry on WordPress.com