Thanks for that Rob.

So would you agree that it would be best practice to do this via SSIS and then call it from the VB app?

Thanks again

Hi Andy

Well, the system is a sales record from 2003, split into year+week.

most queries run only on the current and last week, but we also have queries that run year...

thanks for the input Kevin.

The table design is from an old legacy system before I started working here, looking at some ways to improve performance.

Will probably redo the design in...

ok, so the year partition is up and running, working good so far.

Now I want to include the weeks, not sure how to do it only for 2011, but...

Thanks Andy, did it my way in the meantime, worked a treat, but will keep your way in mind when I do it on the production server.

Already seeing an improvement,...

Hi Andy

Sorry to bother again, but I have run into a little problem. I have created a new file group and the scheme/partition function:

ALTER DATABASE bs

ADD FILEGROUP FG1

GO

ALTER DATABASE bs

ADD...

Thanks Andy, you have been a great help and you have given me a lot of info to work with.

Will start with the partitioning shortly.

Andy, just a quick question.

If these partitions are all going to be on the same disk, is it necessary to create a file group for each partition or can I...

Hi

Thanks a lot for your input, really appreciate it.

Put this on the back burner for a couple of days, but going to get into it ASAP.

You understood my second question...

well, you have 4 options that I am aware of:

SQL Import/Export Wizard

BCP

OpenRowSet

Writing a .Net/C application that will create the txt file and dump the data into a txt file.

BCP...

well, bcp is a bit of overkill with so little records (150 000)?

but you can export data from a table to a txt file using the bcp command:

BCP "SELECT columns...

How many is 1 lack?

If its not millions and millions of records, the SQL Import and Export Wizard will do the trick.

thanks, they are not really clear on the performance improvements on having the FG on a single disk.

will go read some more online.

Thanks Howard, very good link.

Seems I will be able to achieve what is necessary using the Web Edition.

Thanks again

Hi, I have created a test procedure with the CASE statements, I am getting a divide by 0 error, this is happening because the rows are not returned properly. Is...