225 reputation
19
bio website careers.stackoverflow.com/…
location
age 37
visits member for 2 years, 8 months
seen Nov 6 at 4:48

My Professional Profile.

My email: cmljYXJkb2phdmllcnNhbmNoZXpAZ21haWwuY29t - Come on, you should be able to recognize the encoding ;)

profile for Icarus on Stack Exchange, a network of free, community-driven Q&A sites


Oct
19
awarded  Curious
Oct
14
awarded  Yearling
Sep
24
awarded  Autobiographer
Jan
16
awarded  Commentator
Jan
16
accepted Raise error from Stored PROC in SQL Server PDW
Jan
16
comment Raise error from Stored PROC in SQL Server PDW
This is an awesome hack and I am prepared to live with it. I will accept your answer. Thanks!
Jan
16
asked Raise error from Stored PROC in SQL Server PDW
Sep
12
accepted Constructing datetime from 2 fields: one integer and a datetime
Sep
12
comment Constructing datetime from 2 fields: one integer and a datetime
thank you for your answer.
Sep
12
comment Constructing datetime from 2 fields: one integer and a datetime
@JonSeigel Getting rid of TryParseExact and using ParseExact only reduced the execution time by 1 sec (5 secs). Still slower than the T-SQL approach.
Sep
12
comment Constructing datetime from 2 fields: one integer and a datetime
@JonSeigel I created a SQL CLR Function to test on my DEV environment (used DateTime.TryParseExact) and on 100K rows sample, performs twice slower than my T-SQL version (3s Vs 6 secs).
Sep
12
comment Constructing datetime from 2 fields: one integer and a datetime
@JonSeigel CLR integration is not enabled, unfortunately. I thought about that possibility too.
Sep
12
comment Constructing datetime from 2 fields: one integer and a datetime
@AaronBertrand Refund? That person(s) needs to pay for damages... Seriously though, the saddest part is that it was likely a decision made by either the "chief software architect" or worse, a group of senior developers. In any case, I don't want to know... :-/
Sep
12
revised Constructing datetime from 2 fields: one integer and a datetime
added 2 characters in body
Sep
12
comment Constructing datetime from 2 fields: one integer and a datetime
@AaronBertrand That is not a possibility. The database has billions of rows of trading data and several apps (matching and routing engines) write to the database using an int to represent the time of the day :-/
Sep
12
asked Constructing datetime from 2 fields: one integer and a datetime
Aug
14
accepted Extract time portion of Datetime2(7) in hhmmssfff format
Aug
14
asked Extract time portion of Datetime2(7) in hhmmssfff format
Aug
12
revised Updating a big replicated Dimension (SQL Server PDW)
added 245 characters in body
Aug
12
asked Updating a big replicated Dimension (SQL Server PDW)