DECLARE @TimeChar CHAR(4) = '0545';

SELECT REPLACE(LEFT(CONVERT(VARCHAR(20),DATEADD(MINUTE,15,CONVERT(TIME,LEFT(@TimeChar,2) + ':' + RIGHT(@TimeChar,2) + ':' + '00')),114),5),':','')

The private jet doesn't pay for itself, right 😀

To be honest, I wouldn't like to manage 2TB of data with standard edition (and possible 16GB of RAM).

Subtle. :Whistling: 😀

I'm afraid you need to create the temp table first, and then use the regular INSERT ... SELECT syntax.

If you want table partitioning, you need Enterprise edition.

Also, table partitioning in itself is not a performance solution. It's more a maintenance solution for big tables. The possible performance benefit...

I'm not 100% sure what happens, but I think the error is a bit misleading.

SQL Server will parse the SQL statement and validate it before it actually executes it. Maybe...

Nice question, thanks Steve!

Without breaking any NDA, I don't think spatial aggregates should be high on your list.

There are more important topics to cover, such as window functions and XML.

I don't remember having...

No, the data flow cannot be dynamic. It needs fixed metadata.

There are commercial components out there that can handle changing metadata.

Easy one!

Great question, thanks.

Awesome question Tom, well done.

djj (3/5/2015)

---

Iwas Bornready (3/5/2015)

---

Typo or not, it is still an error and will not work. So the answer is only f). I understand it can be difficult to come up...

First of all, which version of SSIS?

With procedure, do you mean stored procedure?

1. yes. Depending on the version of SSIS this is easy or rather complicated.

2. yes. Depending on the...