My girlfriend really loves the Amazing Race Show, which of course means that I have to “love” it too. It’s a reality TV show where teams compete in contests all over the world with a one million dollar prize at the end. Anyway, in one episode of last season the contestants were in Dubai. The [...]
|
||||||
|
|
Total Badass We may have never saved the world with a paper clip, chewing gum, and duct tape, but many of us are MacGyvers in our daily lives. Perhaps we’re stuck with SQL Server 6 or running on ridiculously old equipment, for whatever reason we’ve had to make something out of junk. I was reminded [...] In the past couple of weeks, I have discussed the problems of orphaned records in the M2M Database and promised to provide a script to find them. So, I’ve decided to turn it into a game. If you’d like to play, paste the following script into your Query Analyzer or SQL Server Management Studio and [...] A Made2Manage customer called me with a serious performance problem with one of his custom reports. After I looked at it, I realized that the inventory changes in M2M Version 6.0 were the culprit. To give you some idea of his problem, the query in question ran took a few seconds before the migration and [...] Brief Summary – M2M orphans records in the Quote Master and Quote Items tables when the quotes are in the Cancelled status. As I mentioned last week, I came across a problem with orphaned records in my addressing tables. Rather than address my orphaned record problems piecemeal, I decided to create a script to check [...] Recently I got a call from another M2M Consultant who was attempting to install M2M on Windows 7. He simply could not get VBA to work. I asked him to run through the steps and I found his problem right away. He had made a mistake early in the process; I have made similar mistakes [...]
The Princess Bride The other day I found myself in a meeting regarding a CRM package we are implementing. The implementation company had brought two project managers, a sales lady, and a geek who will actually assist in the implementation. I sat in on this meeting with some of our executives and sales people. I [...] I found more orphaned records recently when querying a M2M table with an order by clause. Once again, this occurs because in my opinion the M2M database is not properly designed. Here’s a quick walk-through on how I found it. Incidentally, the screen shots are from TOAD using M2M’s practice database. A manager tasked me with [...] Listen folks, I have been a computer geek a long time. I started with the early versions of DOS and have been using Microsoft operating systems for nearly 20 years. I used to know how to configure extended memory, expanded memory, etc in order to get various PC games to work in less than 1mb [...] |
|||||
|
Copyright © 2010 Made2Mentor - All Rights Reserved |
||||||
Popular Articles