As far as I know, you can set yourself up with an EC2 instance (Windows Server only) and then install whatever you like.

Can you post the actual execution plans? (One for a poorly performing version and one for the faster version.)

I was only trying to help.

Perhaps you could use Profiler to find out what the app is doing?

yb751 (3/22/2016)

---

Jacob Wilkins (3/22/2016)

---

Steve Jones - SSC Editor (3/22/2016)

---

Alan.B (3/21/2016)

---

Quick question: I got the standard email saying that someone replied to a comment on one of the forum threads but...

Koen Verbeeck (3/22/2016)

---

Grant Fritchey (3/22/2016)

---

Koen Verbeeck (3/22/2016)

---

Grant Fritchey (3/22/2016)

---

Koen Verbeeck (3/22/2016)

---

In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all of the...

SQL!$@w$0ME (3/21/2016)

---

Is it a good practice to move SSISDB to a data drive. By default this is created on directory where system db location.

Can the SSISDB database files moved to...

Take a quick look here and see whether it may be relevant.

Those cakes sound tempting:-)

What I suspect is that the TRY_PARSE is merely hiding a more fundamental problem. The fact that you were getting errors before means (I think) that the...

What is CRL?

Instead of

set @START_DATE = @START_YEAR + '-' + @START_MONTH + '- 01 00:00:00'

set @END_DATE = @END_YEAR + '-' + @END_MONTH + '- 01 00:00:00'

Try this:

set @START_DATE = try_Parse(@START_YEAR...

Please post the full text of the error message.

Igor Micev (3/18/2016)

---

The catalogs databases are small and don't keep...

I agree with all of John's comments. Lots of memory and speed of connection to data sources would be high on the list.

Actually, no.

1/0.0033 = 303.03030303......

hardly a round number.

300 ticks per second = 3.3 recurring milliseconds