Viewing 15 posts - 16 through 30 (of 38 total)
The problem with the SSIS solution is that I need to import lots (100+) of differently named files. I even bought an application that supposedly joined multiple csv files so...
June 23, 2011 at 10:08 am
This is what I tried from other postings on this subject from the forums:-
I setup a format file (XML as advised by MSDN) and tried the OPENROWSET (BULK...... posted...
June 23, 2011 at 9:37 am
Using windows7 and IE 8.0, was unable to add an attachment:w00t: Have had to go onto win xp machine to add attachment?
The attachment is the first 10,000 records of the...
June 23, 2011 at 6:52 am
For anyone remotely interested!!
I bought a new laptop recently, intel i7 quadcore, 4gb ram. Loaded SQL 2008 R2 attached my db featured in this thread and ran this query.
Return 1,500,000...
June 6, 2011 at 10:00 am
Sorry for bringing an old thread back to the top but this is a really useful thread. The information gleaned from reading is most helpful. Many thanks.
May 23, 2011 at 4:50 am
Thanks for all the help on this problem to everyone who has posted. It has been a massive learning curve, and a very useful one.
One idea I have thought about...
March 24, 2011 at 11:46 pm
Craig, Thanks for the reply again, I am going to go through the execution plan and try and hook up your points with what is included in the plan. Before...
March 24, 2011 at 5:32 pm
Craig, many thanks for your input. I must apologise, as I have since tidied up the source of the original view to at least get it working to an extent,...
March 24, 2011 at 4:11 pm
Thanks again for your input.
The new execution plan is attached.
March 24, 2011 at 2:53 pm
The db is production to the extent I rely on it to make my living. I have a vb.net written front end for using the whole data set with gui's....
March 24, 2011 at 1:45 pm
Your help is much appreciated. I am learning a lot along the way into the bargain.
The new execution plan is attached, took 59 seconds, that's 50 seconds quicker without all...
March 24, 2011 at 12:42 pm
One Race has many runners (average 10 runners per race).
Another point I missed; each MstRun row does not always have a previous MstRace and MstRun, hence my outer join to...
March 24, 2011 at 12:08 pm
ahhh just posted long reply and lost it!
Overview:
The db is an operational one containing data for all horse races in europe over the past 10 years. Minute details for each...
March 24, 2011 at 5:24 am
Again, thanks for your reply. Apologies for my ill considered plea for help. I will try and do some cleaning up first. You are in fact correct, I did have...
March 23, 2011 at 1:55 pm
OK, will read the article first and try and make the question clearer. I did read some posts on views and performance so at least attempted to help myself.
Apologies, as...
March 23, 2011 at 12:47 pm
Viewing 15 posts - 16 through 30 (of 38 total)