Andrew Brobston abrobston
abrobston
/ last-two-sql-slides.html
Created
April 27, 2019 16:47
The two slides we didn't get to in "Optimizing SQL Server :What Developers Can Do."
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <section id="resources" data-timing="60"> | |
| <h3>Resources</h3> | |
| <ul> | |
| <li>Brent Ozar's resources: | |
| <ul> |
abrobston
/ minnebar-session-stats-bookmarklet.js
Created
April 25, 2019 15:47
Minnebar Session Stats
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| javascript:var $sessionLinks = $("a[href^='/sessions/']").filter((i,e) => /^\/sessions\/\d+$/.test($(e).attr("href"))); var count = $sessionLinks.length; const sessionCount = count; var allCounts = []; $sessionLinks.each((i,e) => $.ajax({url: $(e).attr("href"), method: "GET", dataType: "html"}) .done(d => { const pc = $(d).has("#participants").find("#participants li").length; $(e).text(`(${pc}) ${$(e).text()}`).closest("li").data("pc", pc); allCounts.push(pc); count--; })); function afterCount() { if (count > 0) { setTimeout(afterCount, 5000); return; }; let listArray = $(".sessionsList li").toArray(); listArray.sort((a, b) => parseInt($(b).data("pc")) - parseInt($(a).data("pc"))); const $parent = $("ul.sessionsList").parent(); const $newList = $("<ol class=\"sessionsList\"></ol>").append(listArray); $parent.prepend($newList); $("ul.sessionsList").detach(); const voteCount = allCounts.reduce((a, b) => a + b); const allCountsLength = allCounts.length; const mean = voteCount / allCountsLength; const variances = |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [Test] | |
| public void SourceTypeWhenOfTypeAppliedToSelectIsCorrect() | |
| { | |
| using (ISession session = OpenSession()) | |
| using (session.BeginTransaction()) | |
| { | |
| var entityQuery = session.Query<IMainEntity>(); | |
| var result = | |
| entityQuery.Where( | |
| m => |