Just because I want to see DBTIMEWARP get used:

The number line is not a line, it's a circle, proven by the Divide by 0 asymptote. You just have to...

Q1 is simple enough and is simple join techniques, I wouldn't expect to see any issues there.

Q2 requires people to know about SARGability. While a definite skill I'd like...

The procedure is triggering the trigger. You need to figure out which table it's on. Insert/Update/Delete will cause it.

However, you don't want to randomly drop a trigger, you...

venkat5677 (6/4/2014)

---

It's only a copy command inside this cmd file.

" Error: 0xC0029151 at ReportsToUsers, Execute Process Task: In Executing "C:\NewFolder\AAA.cmd" "E20070815" at "", The process exit code was "1" while...

Koen Verbeeck (6/3/2014)

---

That is fine during design time, but I'd like the full error at runtime. I've had cases where the actual error was cropped off because the error message...

The data flow doesn't work like a query, or like typical programming logic.

Don't think 'steps', think 'places in a stream'.

The data flow streams data from the source, through all the...

Koen Verbeeck (6/3/2014)

---

Regarding the alternate error logging: before SSIS 2012, the standard error logging was inadequate in my opinion. It was hard to retrieve the number of rows transferred, sometimes...

Sorry, ;WITH is ingrained into my head at this point. You're stuck with it if you chase me in my code.

I agree with a decent amount of what's been...

Glad you found it Tom, good luck. 🙂

nivedita talukdar (6/2/2014)

---

The one which I attached above is an individual report. I did have installed VS 2010 shell and able to view the datasets and upon trying to view...

I'd heard he's a bit scary. ...

Luis Cazares (6/2/2014)

---

On another server, where we have the permission, I've found a lot of issues that can be improved. However, I wouldn't mention that as it's not part...

You'll need to get some hands on experience at this point with SSRS and the VS2008 studio (you need the right version of VS or BIDS for each version of...

Without seeing the data? Nearly impossible to troubleshoot directly.

What's the rowcount in VES?

What's the rowcount in EHR?

What's the DISTINCT SSN Count in both?

When you join the tables (instead of...

ramana3327 (6/2/2014)

---

Please correct me if I am wrong

Usually it is better to include the columns in the index that are in where clause, select list and join.

I am thinking that...