I have it installed on SQL Server, we are noticing weird Lazywrites/issue not sure if it is because of this. Can you please elaborate a little bit on what...

Thanks.  That's helpful.  That means that MS is aware of the issue and addressing it via a CU.

The modern analytical platforms which I referred to do not need denormalizaion, they actually work much much better on a normalized set which means that there is hardly any...

Many developers find it easier to drop everything denormalized in XML, JSON or CSV and will complain because the query is taking a lot of time when trying to...

Data Warehouses aren't denormalized.  They have a different set of design rules which gives them...

When I import from Excel, I create a table with all the columns as nvarchar(255) NULL.  This is the same data type as the cells.  Once I have the data,...

"How you say something is often more important than what you are saying."  Don't know who said that, but very true.  I worked with a consultant who didn't think that...

I knew that only two rows met the criteria. But the case statement was so convoluted an answer of returning an error seemed possible.  Oh well.

I've had similar experiences coming from non-SQL server sources.  What exactly is "snowflake"?  Not sure that's enough to look it up given that it is an actual word and a...

As I already said, knowing the version would be helpful.  If it's 2012+ I would ask why you need to use proxy accounts rather than the managed service accounts.  It's...

More information is needed.  If you're using SQL 2012+, you may be able to use the manage service accounts.  Or if the job is reading from a database, the SQL...

I gave up trying to be so formal about the nature of data. ISBN numbers are unique, so while a fully normalized table would contain pointers to...

ID of '1234' (call this employee field).

Is this sufficient to ID an individual employee?  Are you trying to preserve the recordset from the original...