Monitoring Table Size Growth in SQL Server

  • March 31, 2011
  • 0 Comments

During my vacation I came across a older, but interesting article that shows you how you can monitor table size growth in SQL-server. With a bit of creativity you can create interesting report based on this information or you can just use the examples on the second page.

Index vs Index hint

  • October 1, 2010
  • 4 Comments

This is a discussion I had with several colleagues. What is the difference between index and index hint and what do we use in our code?

The Ax Infolog

  • May 7, 2010
  • 0 Comments

Wel all know the small dialog that gives the user usefull information about what is happening in Ax. In this post I will tell u some more about this. You can add information to the Infolog by calling: Infolog.add(…) info(…) warning(…) or checkfailed(…) error(…) You can add some structure in it by using setPrefix(…) Using […]

Batch job performance boost

  • April 22, 2010
  • 0 Comments

Did you ever have trouble with the performance of your batch-job? Well maybe this small trick can shorten the time your batch runs. The big idea: Try to split up your gigantic batch in smaller pieces. Launch a batchjob that produces many smaller batchjobs (tasks) that can handle a subset of the data you need to […]

Counting the number of records in a QueryRun

  • March 9, 2010
  • 0 Comments

When you want to count the number of records that are currently displayed on a form, and you have only one data source, just call the static method countTotal() from the SysQuery-class. public void executeQuery() { ; super(); info(int2str(SysQuery::countTotal(EmplTable_ds.queryRun()))); }public void executeQuery() { ; super(); info(int2str(SysQuery::countTotal(EmplTable_ds.queryRun()))); } But when you want to do the same […]