You have...

Thanks, Peter... Those are the basic formulas we ended up with in the article.  They're just "DRY"ed out a bit in...

As far as I see it, there are two points here: how much of an expert on the topic in question the presenter is and to what extent is...

Steve, I appreciate you not ending a sentence proposition with.

Seriously though, we wouldn't have so many great events if it weren't for the vendors.  I've been to a number...

Personally I almost exclusively watch talks online, which has the added benefit of being able to skip the first and last 20% of it.

I couldn't care less about who...

I think Imposter Syndrome is a good driver, and has been for me.

However, it can be crippling, it can lead people to shy away from and avoid taking chances...

Install QGIS and use ogr2ogr utility to load the SHAPE file to SQL server:

ogr2ogr --debug ON -f "MSSQLSpatial" "MSSQL:server=.;database=GovilLoad;trusted_connection=yes" "PARCEL_ALL\PARCEL_ALL.shp" -a_srs "EPSG:2039" -overwrite -unsetFieldWidth -progress --config MSSQLSPATIAL_USE_BCP FALSE

for me...

Thanks, Jason.  I'm currently working my "dream job" and so I wasn't asking for me.  I was asking hoping that you'd answer just as you did to give the job...

Sidebar/Errata:

It doesn't affect any of the outcomes in this article, but I said the following in the article...

Since the numbers above are BIGINTs and the “magic number”...

Which DB engine are they using, Jason?

Welcome back and good to "meet" you.

Following up on this, we gave up trying to pinpoint what query/queries were causing the issues.  Threw 64 GB of RAM at it which resolved the issue.  We spotted...

Thanks all for your replies.

Some of you are asking for full DDL and/or execution plan. Unfortunately, I cannot do that. At our place we have very strict rules about...

Look at the first line in the query you're using...

SELECT TOP 1000000 dbo.IMS_APT.ID_vard,

What makes you think that even a columnstore index is going to change the amount...

Jeff,

oh sorry I mistakenly took that link out when I edited it for the error message.  Which makes this thread no longer makes sense.  And I should have created...