Home > Uncategorized > daily 07/29/2015

daily 07/29/2015

    • ith an OLEDB connection we can now run our own MDX and DAX queries against SSAS data sources! I assume this will be coming in Power Query in Excel soon too.
    • Unlike SOQL, which can only query one object at a time, SOSL enables  you to search text, email, and phone fields for multiple objects  simultaneously.
    • Total number of records retrieved by a single SOSL query 200
    • FIND {Joe Smith} IN Name Fields RETURNING lead(name, phone)
    • You want to count the number of records that meet specified criteria.
    • When a given search can use either language, SOSL is  generally faster than SOQL if the search expression uses leading  wildcards or a CONTAINS term.

Posted from Diigo. The rest of my favorite links are here.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: