(Grant Fritchey) I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t remember the specifics, but I said it actually didn’t matter. However, that answer has bugged me, so I set up a quick test.
Community
Calling The Power BI REST API From Microsoft Flow, Part 3: Finding All Data Sources Used In A Power BI Tenant
(Chris Webb) The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are there hundreds of Excel files being used as data sources for reports that you don’t know about?
Db2 for z/OS Buffer Pools: Clearing the Air Regarding PREFETCH DISABLED – NO READ ENGINE
(Robert Catterall) Has this ever happened to you? You’re looking at the output of a Db2 for z/OS -DISPLAY BUFFERPOOL(ACTIVE) DETAIL command, or maybe at a statistics report produced by your Db2 monitor, or maybe your Db2 monitor’s online display of a subsystem’s buffer pool activity, and you see for
Write a purely functional Bubble Sort application
(Jeff Friesen) Neal Ford coined the term functional thinking to describe the mental shift required from developers trained primarily in object-oriented programming, who want to integrate functional programming concepts and techniques into their practice.
Implement Text, Mathematical Captcha in ASP.Net MVC With Example
(Kannadasan) In this tutorial i am going to explain about how to Implement Text, Mathematical Captcha in ASP.Net MVC With Example.
Dependency Injection in ASP.NET Core
(Jignesh Trivedi) Dependency Injection is the design pattern that help us to create application which loosely coupled.
SQL SERVER – Parallelism for Heap Scan
(Pinal Dave) Every consulting engagement is different and I enjoy interacting with different people while I am working with different experts. Earlier this week, here is what I heard during one of the Comprehensive Database Performance Health Check engagement about Parallelism for Heap Scan.
Visual Studio Toolbox Unit Testing: Existing Code
(Robert Green) This is the fourth of a four part series, recorded this summer, where I am joined by Phil Japikse to discuss unit testing. T
Prepared Statements for MySQL: PDO, MySQLi, and X DevAPI
(Dave Stokes) Recently I ran across a prominent PHP Developer who incorrectly claimed that only PDO allows binding values to variables for prepared statements.
LOBs vs Data – when compression occurs
(Connor McDonald) Just a quick tip for SECUREFILE lobs.