Category: SQL

How To Get A List Of All Your Custom Fields

Posted on by Karam Mohammed

Have you ever wanted to know how many Custom fields you have in your system, when they were created or what is the data type of each one? You can get a full list of all the Custom fields that you have in the system using a simple query as shown below. The query will call Read more about How To Get A List Of All Your Custom Fields[…]

How Can I Speed up my Project Costs Reports?

Posted on by Karam Mohammed

If you’re a Microsoft Project Server report developer, you’ve no doubt come across the issue of long running reports that look to output time-phased cost data. Things are just fine until you go and add the costs to the query; then your 3 second query turns into a minute and a half. Sure the OLAP Read more about How Can I Speed up my Project Costs Reports?[…]