greggyb

108 ms·

931.
by greggyb 10y ago
Memory-optimized transactional engine (since 2014). Native compilation of stored procedures. In-memory tables that can optionally be persisted to disk. https://msdn.microsoft.com/en-us/library/dn133186.aspx In-mem
932.
by greggyb 10y ago
Power BI can connect directly to many database engines. Queries are generated on the fly by the reporting engine in a proprietary language called DAX, and DirectQuery is a technology that translated DAX into SQL queries. This is a mode of o
933.
by greggyb 10y ago
See my sibling. There is no Microsoft offering for on-prem Power BI. You can get close to it with sibling products on SharePoint. There is a third party offering an on-prem solution.
934.
by greggyb 10y ago
It also offers an optimized in-memory transactional engine that is lockless and compiles stored procedures to native code.
935.
by greggyb 10y ago
Microsoft is cloud-first in development now. There is a Power BI Desktop program that is 100% free as in beer available, which runs a private instance of an in-memory columnstore OLAP engine, Power Pivot (same internals as SSAS). It also in
936.
by greggyb 10y ago
Ah, but what RDBMS should that sqlfmt utility target? There are large differences. Here's one for TSQL. I find it very useful when spelunking through customers' almost invariably awful SQL. http://poorsql.com/
937.
by greggyb 10y ago
Or use a code formatter?
938.
by greggyb 10y ago
Even the executable is still lync.exe for Skype for Business.
939.
by greggyb 10y ago
Talk to a Microsoft rep. There are several categories of Microsoft customers. One category is enterprises using Microsoft products internally. Another is software/SaaS companies using Microsoft products to develop or deliver a product.
940.
by greggyb 10y ago
Your "ferry" would have to be a minimum of several miles long. It would be a motorized section of road.
941.
by greggyb 10y ago
Thanks, this and your other response are very useful!
942.
by greggyb 10y ago
I love this strategy. One thing that I like about it is that the volume of vegetables you'd reasonably use makes it very difficult to over-eat on. This would be a difficult meal plan to use to gain significant weight.
943.
by greggyb 10y ago
Would you be willing to re-run that with SQL Server 2016? A Dev license is free, and there's been a lot of relational engine optimization since 2012. I'd be curious to see what the latest release can do compared to Postgres'
944.
by greggyb 10y ago
No one has tested a query that got more than 32x faster, so they don't want to promise something they can't prove.
945.
by greggyb 10y ago
> I've been meaning to do an analysis of inflation based on hours worked. It;s hard to redefine hours but I'm sure politicians will find a way! The cynic in me says that they simply record fractional portions of FTE and FTE tak
946.
by greggyb 10y ago
I've tried this and I don't get any expansion on tab. Is this a Bash or Zsh feature?
947.
by greggyb 10y ago
SQL Server also comes with SSAS, if we're talking analytics. There's the very mature MDX-based Multidimensional mode, and a heavily optimized columnstore engine with the DAX-based Tabular mode. For analytical workloads, SQL is oft
948.
by greggyb 10y ago
You know how when you try to implement a function to compute Fibonacci numbers naively with recursion you end up with a minor performance problem? In Python: def fib(n): if n < 2: return n else:
949.
by greggyb 10y ago
And I see people every day using exactly these pieces of functionality to do nontrivial summarization of data, a thriving blog and forum ecosystem, and Microsoft knocking down my door because their own sales teams can't keep up with th
950.
by greggyb 10y ago
> > Solberg was one of a string of Norwegian politicians who shared the iconic image after Facebook deleted a post from Tom Egeland..., > > > shared the iconic image ....
951.
by greggyb 10y ago
The PM's post included the photo. > Erna Solberg, the Conservative prime minister, called on Facebook to “review its editing policy” after it deleted her post voicing support for a Norwegian newspaper that had fallen foul of the soc
952.
by greggyb 10y ago
Ah gotcha. Yeah, for that I just had an implicit mental model of R1C1 without realizing it was physically implemented. I interpreted you (wrongly it seems) as saying that the relative offsets were confusing and I responded to that. You were
953.
by greggyb 10y ago
Check Power Pivot if you just want an Excel interface to lots of data. I posted elsewhere in this thread about it, but the fun demo is to load up a dataset with a largest table of several hundred million rows. This is still quite snappy on
954.
by greggyb 10y ago
This is not a judgment on you, but I've seen this echoed in a couple places in this thread and yours is a top-level comment that starts with it. I really grokked the concept illustrated with R1C1 notation within a day or two of being e
955.
by greggyb 10y ago
There are two major improvements to Excel that came in 2010 and 2013. These are Power Pivot and Power Query (Power Query is now backported to 2010 as well). Power Pivot straight up is SQL Server Analysis Services. It's a heavily opti
956.
by greggyb 10y ago
You can use array formulas to achieve the same result in Excel.
957.
by greggyb 10y ago
Excel formulas are a spreadsheet DSL, and one with massive adoption.
958.
by greggyb 10y ago
There is another snippet near that section which evaluates the following. >>> float > float('infinity') True
959.
by greggyb 10y ago
How long does it take Dwarf Fortress to create a new world?
960.
by greggyb 10y ago
Is that second discussion just a performance thing, or are there filesystem implications for one or the other?

More ›