Advertisement
- 1. tbsgadi3,000
- 2. tedbilly1,464
- 3. chwong671,400
- 4. zephyr_hex1,336
- 5. gnurl1,000
- 6. Vaibhav_...600
- 1. rama_kri...19,930
- 2. tbsgadi13,700
- 3. DennisL10,478
- 4. minichicken8,500
- 5. nav_kum_v7,575
- 6. sendow6,500
- 7. mlmcc5,750
- 8. jonvaughan5,500
- 8. MOA815,500
- 10. chwong675,400
- 11. mass26125,000
- 11. GLCompu...5,000
- 11. Ritesh_G...5,000
- 14. Twisteddk4,900
- 15. rolutola4,250
- 16. crm_info4,000
- 17. BillBach3,500
- 17. AndersHe...3,500
- 17. ajames9...3,500
- 20. zephyr_hex3,336
- 21. stephenm...3,000
- 21. mhci3,000
- 21. hilay3,000
- 24. cvvood2,814
- 25. sinoj2,572
| ERP Zone |
ERP
Software ZONE
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article.
SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries.
Incidentally – SARGable is short for Search ARGument Able.
...
SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries.
Incidentally – SARGable is short for Search ARGument Able.
...
by Patrick G. Matthews
Introduction
Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance (StDev, StDevP, Var, and VarP), and average (Avg). In addition to these typical aggregate functions, Access also offers the so-called "domain aggregate" counterparts for each of the aggregates already mentioned.
...
Introduction
Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance (StDev, StDevP, Var, and VarP), and average (Avg). In addition to these typical aggregate functions, Access also offers the so-called "domain aggregate" counterparts for each of the aggregates already mentioned.
...
by Patrick G. Matthews
All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception. As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns the number of records pertaining to a grouped result set and meeting the criteria specified in the query (in the case of Count()) or in DCount() in the third argument of the function.
...
All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception. As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns the number of records pertaining to a grouped result set and meeting the criteria specified in the query (in the case of Count()) or in DCount() in the third argument of the function.
...
by Patrick G. Matthews
A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query. For example:
I have a table that currently holds student subject enrolments with the following fields
Student_ID, Subject_ID
...
A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query. For example:
I have a table that currently holds student subject enrolments with the following fields
Student_ID, Subject_ID
...
Zone Advisors
Having problems asking a question? Have a general question about Experts Exchange? Let us know!
Follow Us!
Did you know that Experts Exchange is on Facebook and Twitter? Follow us on Twitter at @ExpertsExchange or become a fan of EE on Facebook!
|
[x]
Neglected Question
|
||
| Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details). | ||
| Date | Points | Title | Comments | |
|---|---|---|---|---|
1 |
03/08/10 02:03 PM | 125 | Learning SAP ERP | 2 |
2 |
03/08/10 01:43 PM | 500 | FB client is frozen.. | 1 |
3 |
03/07/10 11:33 AM | 500 | ERP implementation methodology | 4 |
4 |
03/04/10 01:55 AM | 500 | Calling Features in Sage CRM | 5 |
5 |
02/15/10 07:03 PM | 500 | Great Plains Upgrade / Migration | 4 |
6 |
02/15/10 06:35 PM | 500 | Has anyone ever used Appian's cloud BPM serice? | 1 |
7 |
02/15/10 08:51 AM | 500 | Are Opensource solutions used by Big Companies? Big IT Consulting Companies? | 6 |
8 |
02/15/10 08:07 AM | 500 | What big consulting companies *like* to implement open source solutions? | 2 |
9 |
02/14/10 01:11 PM | 500 | ProcessMaker for BPM | 1 |
10 |
02/03/10 11:12 PM | 500 | Unable to open invoice in Sage CRM over Internet | 6 |
