(Chris Webb) At the end of the Power Query Formula Library Specification (which can be downloaded here) are sections on Comparer, Combiner, Replacer and Splitter functions.
Other News
Looking At Nested Event Timing And DOM Structure In AngularJS
(Ben Nadel) In AngularJS, the DOM (Document Object Model) responds, so to speak, to changes in the view-model (VM) as defined by the Controllers. But, the Controllers don’t directly control the DOM; in fact, the Controller aren’t supposed to know about the DOM.
Thoughts on Angular’s Controller As Syntax
(K. Scott Allen) I’ve been a bit late to the Angular controller as syntax. I was skeptical of the feature at first, and with an Angular project already in flight, I felt it wasn’t the type of change to make with a significant amount of code already committed.
SQL SERVER – SSMS: Memory Usage By Memory Optimized Objects Report
(Pinal Dave) At conferences and at speaking engagements at the local UG, there is one question that keeps on coming which I wish were never asked. The question around, “Why is SQL Server using up all the memory and not releasing even when idle?”
Code Optimization – How Much is Enough?
Today I want to talk about a time when I had to optimize some dot net code. I started using Linq. But the code didn’t perform fast enough (probably because I was a novice at Linq). I needed the fastest performance when joining data from two collections? I’m not sure Linq is the fastest…but generally it is good enough. One […]
Tips for using SQL Server 2014 cursors
Tips for using SQL Server 2014 cursors Try to avoid using insensitive, static and keyset cursors, whenever possible. These types of cursor produce the largest amount of overhead on SQL Server 2014, because they cause a temporary table to be created in TEMPDB, which results in some performance degradation. Use FAST_FORWARD cursors, whenever possible. The FAST_FORWARD cursors produce the least...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
SharePoint Search *Quirks: Query Variables
(bspender) In several forums, emails, and discussions, I keep seeing this recurring question, "How can I limit results to a specific library [in this site collection]?" Turns out, this was more difficult than I originally thought …until I found mention of the escape character "" (essentially as a s
Gridview Selected Row Value Pass to JavaScript Function On Hyperlink Click in Asp.net Using C#.Net
(Pranav Singh) This article will show you how you can pass the gridview selected row value to a JavaScript function when user click on hyperlink placed in a gridview control. So in this article I have used GridView, c#.net, Asp.Net, Hyperlink, JavaScript.
Using of Android XML drawables – Part 1: LevelListDrawable
(Khoi Nguyen) In this post series, I will share some cases I used Android drawable by more efficient methods. They can help your code looks cleaner, separating Java vs. XML, or can even reduce the complexity of your View hierachy.
SQL Server Performance Tuning with Hypothetical Indexes
(Daniel Farina) You are tuning a query and need to check the performance impact of a new index. But the table has millions of rows and it will take a lot of time to create an index. Keep reading and you will see how to create and test hypothetical indexes with the undocumented DBCC AUTOPILOT command