[dba-SQLServer] Short term consultant

Right now is the busiest time of the year (its a lighting company) so until Jan everything is on hold.

I did find out that its the VBA code that causes the most pain or so they tell me.

just a quick example;

 if a job starts on 1st of the month, and ends on the 2nd (2 day job)  the forms load quicker because its checking/calculating to see (among many other things) how many jobs  are utilizing a particular inventory item in the 2 days this job is scheduled;

and the inverse applies as well, if a job starts on the 1st and ends on the 20th, now its checking how many jobs are utilizing the inventory item over a span of 20 days, thus the "calculating" takes 10 times as long.

I will be back after the holidays, and thanks




> From: darryl at whittleconsulting.com.au
> To: dba-sqlserver at databaseadvisors.com
> Date: Sun, 14 Dec 2014 22:44:53 +0000
> Subject: Re: [dba-SQLServer] Short term consultant
> 
> Yep, that would be where I would start.
> 
> Try to post the SQL code or Sproc.  Ideally with a small sample (a few rows) of the data if possible.
> 
> 
> 
> 
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of fhtapia at gmail.com
> Sent: Saturday, 13 December 2014 2:27 AM
> To: Discussion concerning MS SQL Server
> Subject: Re: [dba-SQLServer] Short term consultant
> 
> JP,
>   I don't know if you received any bites on your offer, but I wanted to extend that you can receive help on this email forum too if you post examples of what the queries look like.  I'm sure someone here will be able to help.
> 
> On Tue Dec 02 2014 at 8:57:56 AM J- P <jnatola at hotmail.com> wrote:
> 
> > Hi all,
> > Please accept my apologies if this request not permitted in this forum
> >
> >
> > as per my previous post, I have upgraded to sql 2008 and 2014 (in 
> > labs) and the database worked fine (barring a few errors that were 
> > sorted out quickly).
> > As far as the post; I'm looking for someone to review a couple of 
> > queries (that IMO) seem to be poorly written, the reason i say this is 
> > because 6-10 seconds seems rather long to pull up a job spec that 
> > doesn't hold all that much data (maybe a page or 2 of info).
> > Again , please accept my apologies if this etiquette is not 
> > permissible in this forum.
> >
> > And ping me off list if you are interested.
> >
> >
> >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>