mburbea (5/9/2014)

---

Have you tried switching the memory optimized tally table durability to just schema? I read that a table will perform best in this mode and its pretty easy to...

Nice tips, but be careful with statements like this:

In a case sensitive installation/database, it most certainly can change the logic as you must be consistent...

can you connect to the reportserver webservices?

e.g. http://<server>/ReportServer_<instance>/ReportService2005.asmx

It's interesting that you used fetch first N instead of TOP(N).

Was there a performance improvement or just personal preference?

Another way....

select datediff(second,0,cast(replace(replace(replace(fix.duration,' hrs ',':'),' min ',':'),' sec','') as datetime))

from #tmp t

cross apply (

select

case

when len(t.duration)<8 then '0 hrs 0 min '

when...

Or I have a crappy 2012 install?

I get the same crappy performance on 2012 as 2014 for these...I haven't got a 2008 to test on right now.

Eirikur Eiriksson (4/30/2014)

---

FYI: ran the test on the CLR Split, mm's memory optimized version and the lead window function version. Hardly any benefit of using the window function, 0.001 on...

Glad to help, and I hope your debugging goes well!

SQL 2014 is kinda cool...

I just tried out using a memory optimized table for the Tally / Numbers table in DelimitedSplit8K and two things stand out.

1. It seems to be...

It sounds like you don't have asp.net enabled.

Try reading this to see if it helps : http://www.iis.net/learn/get-started/whats-new-in-iis-8/iis-80-using-aspnet-35-and-aspnet-45

Except that will be a Command Timeout, not a...

You could also try the /resetsettings switch or /setup

See here http://msdn.microsoft.com/en-us/library/xee0c8y7(v=vs.90).aspx

From mssqltips: http://www.mssqltips.com/sqlservertip/1840/sql-server-integration-services-ssis-best-practices/%5B/url%5D

Keep Identity - By default this setting is unchecked which means the destination table (if it has an identity column) will create identity values on its own. If...

I use this tool http://smtp4dev.codeplex.com/releases/view/71614

It acts like an SMTP server, but does not forward the emails on, they just sit there for you to view.