MySQL Archives - Page 12 of 17 - SQL Authority with Pinal Dave

MySQL – Reset Row Number for Each Group – Partition By Row Number

March 9, 2014

In earlier post, we have learnt how to generate row number for each row using a variable as MySQL does not have any system function like SQLServer’s row_number() to generate the row number. In this post we will see how to reset row number for each group (Alternate method for…

MySQL – Generating Row Number for Each Row Using Variable

March 8, 2014

Pinal Dave

SQL

MySQL, Ranking Functions, SQL Scripts

MySQL does not have any system function like SQL Server’s row_number () to generate the row number for each row. However, it can be generated using the variable in the SELECT statement. Let us see how MySQL Generating Row Number.

SQL SERVER – Images and media file management in SQL Server and MySQL – Coding Media Management Tools is Never Easy

March 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

A core element to both web and mobile app development is rich media management. How you approach the control of images in particular can be tricky. In most cases you have two avenues: You either save it as a database BLOB or simply link to it as a file. Going…

MySQL – Profiler : A Simple and Convenient Tool for Profiling SQL Queries

February 25, 2014

Pinal Dave

SQL

Devart, MySQL, SQL Utility

In terms of working with highly loaded databases, any badly-designed request can cause significant performance degradation. Depending on the used DBMS features, various methods are used for query optimization. However, a general rule can be pointed out for all types of DBMS: the fewer server resources are expended when executing…

MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 3

February 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MongoDB, MySQL, ScaleBase

Note: This blog post part 3 of the series and you can download 30-day trial of ScaleBase to practice the concepts. In this article comparing MongoDB and MySQL scalability, I want to focus on query models. We’ve previously discussed how MongoDB and ScaleBase are both highly scalable distributed databases, where…

MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 2

February 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MongoDB, MySQL, ScaleBase

Note: This blog post part 2 of the series and you can download 30-day trial of ScaleBase to practice the concepts. In a previous article comparing MongoDB and MySQL, we saw how MongoDB and MySQL with ScaleBase execute auto-sharding, a key technique to deliver database scalability. In MongoDB, any joins…

MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 1

February 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MongoDB, MySQL, ScaleBase

Note: This blog post part 1 of the series and you can download 30-day trial of ScaleBase to practice the concepts. Introduction Whether it is for extremely large data volumes, high transaction throughput or a massive number of concurrent users, today’s internet and mobile applications require the ability to respond…