(Joseph.Pilov) SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans.
Community
SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time
(Pinal Dave) I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server.
How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3
(Walter Garcia) In this post I’ll give to you the steps to compile Percona Server for MySQL 5.7.22 in Raspberry Pi 3. Why? Well because in general this little computer is cheap, has low power consumption, and is great to use as a test machine for developers.
SQL UNION overview, usage and examples
(Prashanth Jayaram) This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some common questions like the differences between UNION vs UNION ALL.
Windows Server Is Still a Thing and SQL Server Still Runs on Top of It
(Allan Hirt) If you’ve been in hibernation, today you woke up to a world where Microsoft has embraced open source and Linux. What was once unthinkable is now happening. What is going on? Why am I even talking about this?
Db2 12 SQL Pagination
(Meg Bernal) Db2 12 for z/OS became generally available in October 2016. Last summer, Chris Crone and I wrote a two-part blog on two highly requested SQL enhancements.
Micronaut Tutorial: How to Build Microservices with This JVM-Based Framework
(Sergio del Amo Caballero) Unlike applications built using traditional JVM frameworks, Micronaut has 100% compile-time, reflection free, dependency injection and AOP.
Adding Ordinal Indicators with .NET
(Hannes DuPreez) If you know me or have read some of my articles, you would know that I am very inquisitive. I also love languages. I have always wanted to study further, something like drama or writing; sadly, I never had the chance.
Updating Entity Framework Objects with Changed Data
(Peter Vogel) Assuming you’re using the latest version of Entity Framework, the easiest way to update your database is to use DbContext’s Entry class: It’s just two lines of code no matter how many properties your object has.
Troubleshooting missing projects while using VSTS continuous deployment for Azure App Service
(Gaurav Patole) This article shows you how to troubleshoot a specific symptom that you may encounter when configuring continuous deployment for Azure App Service.