Fwd: Very slow query on Persisted Column with Function call

2018-03-13 Thread Corneliu I. Tusnea
Hi, I have a table with a persisted column that is build using a function call: This is the function: CREATE FUNCTION os.RemoveNonAlphaNumericCharacters( @Temp NVARCHAR(2048) ) RETURNS VARCHAR(2048) WITH SCHEMABINDING AS BEGIN DECLARE @KeepValues AS NVARCHAR(100) SET @KeepValues =

Re: Log filter / display dashboard - Looking for recommendation [Slightly off topic]

2018-03-13 Thread Corneliu I. Tusnea
Greg, I've been looking into this as well and I'm not sure if there is a one-size-fits all. We've been using Seq in our app and we ingest ~1-6gb logs a day. Found seq ok but if you search ... well, anything past 24-48h is very very slow. We did various optimizations and move lots of the logs out

RE: Surface Hub

2018-03-13 Thread Chris Walsh
It is really only an SMB/Enterprise Only device, heavily tied to SfB/Teams for proper collab. From: ozdotnet-boun...@ozdotnet.com On Behalf Of David Connors Sent: Tuesday, 13 March 2018 9:39 PM To: ozDotNet Subject: Re: Surface Hub I'd

Re: Surface Hub

2018-03-13 Thread David Connors
I'd like 1 for us and 1 for a customer. The fact these things are still in the enterprise sales model is a bit of a fail. On Tue, 13 Mar 2018 at 20:35 Chris Walsh wrote: > Bought them (25x55” & 10x84”) via Telstra, depends on how many you want to > buy really. If you buy 10

RE: Surface Hub

2018-03-13 Thread Chris Walsh
Bought them (25x55” & 10x84”) via Telstra, depends on how many you want to buy really. If you buy 10 you get a good price, they (Microsoft) do end of quarter deals etc. From: ozdotnet-boun...@ozdotnet.com On Behalf Of David Connors Sent: Monday, 12 March 2018