and thanks for the Selfie Steve..

Grant Fritchey (7/14/2014)

---

rodjkidd (7/14/2014)

---

quackhandle1975 (7/14/2014)

---

Going to this also (Friday & Saturday), so looking forward to meeting fellow DBAs and learning a bunch of stuff.

Be nice to meet Steve Jones, (and...

Gail,

Any update on plans for arriving/departing at BHX. The offer of a lift is still on, subject to timings (I have extended my contract at work so not always...

I haven't checked out the screen grab. Are you using the correct Excel extension.

Pre XL2007 files were .xls. Post 2007 they are .xlsx and .xlsm if the file contains...

Run your SQL query in an SQL task and store the results to an object variable.

Now create a ForEach loop that takes the object variable as its enumerator and...

Rollback (Topical :-D)

Rollback (Topical 😀 )

@Phil, @sean

You were spot on guys. Parameter sniffing was the culprit. I have 'fixed' it by assigning the parameters to local variables. This will work for...

Consider it a date!

:kiss:

Aaron

PM me if you want to discuss the details.

Andy is correct but the explanation is a bit light on content 😉

The problem occurs with the database constraint and is not an error in the SSIS dataflow, therefore you...

@Gail, are you flying in to BHX. If so, do you want picking up. - that goes for any other speakers, organisers or attendees flying in for the conference.

Aaron

@ Steve J. I see you are speaking as well - it will be like a sermon from the mount 🙂

How many fields are you pulling into the cache? You only need to cache the fields you need to match on and the fields you need to output, anything...

unless you crate ##temptables which are global and can be shared by different connections.

RentalFeeAmount is a fully additive measure.

The fact table would be consumed within a view to provide the most recent record version at the reporting date and it is the view...