Just a Day in the Office
Stuff about applications and databases
Menu Close
  • Home
  • Vertica Kit
  • About Me
  • Dilbert

MySQL

0

application vs database side filter efficiency

Posted on September 3, 2013 by Norbert Krupa

Built-in database functions allow for efficient filtering. This post will demonstrate that a simple date filter on the database side is almost twice as fast as filtering the result set on the application side.

Efficiency, MySQL, mysqli, PDO, PHP
0

You have an error in your SQL syntax

Posted on June 30, 2013 by Norbert Krupa

One of the most common problems I come across is users not being able to resolve a basic SQL syntax error thrown in MySQL. You have an error in your SQL syntax; check the manual that corresponds to your MySQL… Continue Reading →

MySQL
0

Sorting software versions

Posted on March 12, 2013 by Norbert Krupa

There may be a time where a software version is stored as a string. In order to sort it, it will need to be broken up into its individual parts (major, minor, patch and build) and then sorted.

MySQL, SQL
0

MySQL backups in batch with folders and 7-Zip compression

Posted on April 9, 2012 by Norbert Krupa

I needed a way to do a daily backup of tables individually from a database. I accomplished this with a Windows batch script.

7-Zip, backup, MySQL, shell

Connect

Official Seal

Official Seal

Recent Posts

  • Installing Gitblit on CentOS
  • Windows Authentication for SQL Server Connection
  • Canceling FreedomPop Premier Service
  • Bootable Windows 8 USB Drive
  • Resolving javaw.exe is not recognized With Squirrel SQL Client

Resources

  • Succint data structures
  • Large collection of free Microsoft eBooks
  • EXPLAIN Extended
  • Guide to forms based website authentication
  • Fundamental differences between hashing and encryption algorithms

SQL Server

  • Why sum of nothing is null
  • 13 things you should know about statistics and the query optimizer
  • Best way to remove time from datetime
  • Understanding how SQL Server Executes a Query
  • COUNT(*) vs. COUNT(1) vs. COUNT(pk)
  • NULL Comparison Search Conditions
  • Precise or fuzzy matching with CONTAINSTABLE
  • Stored procedure template using TRY CATCH
  • T-SQL: COALESCE vs. ISNULL vs. IS NULL OR
  • SQL grouping ranges
  • NOEXPAND hint to use indexed views
  • SQL Performance

Links

  • MySQL at Facebook: What is the query plan for a running query?
  • W3Schools Intervention
  • When the nerds go marching in
  • Junior DBA Interview Questions
  • Prey project
  • Are databases and programming at odds?
  • Twitter fights government subpoena
  • Code is not physical property
  • USB chargers, Apple is not the best
  • How I became a Password Cracker
  • Netherlands first country in Europe with net neutrality

News

  • Does your job create real value?
  • Google goes back to the future with SQL F1 database
  • Man's $600,000 Facebook Disaster Is A Warning For All Small Businesses

Humor

  • Maslow's hierarchy of needs
  • Google Fiber vs. Broadband
  • Exploits of a mom
  • What a crappy evening in 1998 looked like
  • FunnyJunk tries to sue The Oatmeal
  • Programming skill vs blood alcohol concentration

Archives

  • February 2016 (2)
  • July 2014 (1)
  • December 2013 (1)
  • November 2013 (1)
  • September 2013 (3)
  • August 2013 (1)
  • July 2013 (2)
  • June 2013 (1)
  • May 2013 (1)
  • March 2013 (1)
  • January 2013 (1)
  • August 2012 (4)
  • July 2012 (4)
  • June 2012 (7)
  • May 2012 (3)
  • April 2012 (6)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tags

7-Zip Apple backup bulk insert common table expressions cookie cURL Date Document Scanner Efficiency Epson Excel function Galaxy S3 Google Voice GT-S50 HTTP Header Java JIRA MacBook MySQL openrowset Oracle Parsing PDF percent change PHP PHPExcel PostgreSQL RSS Samsung SharePoint shell SQL sql-case sql-coalesce sql-isnull SQL Server String T-Mobile T-SQL VirtualBox Virtual Machine Windows XML
© 2021 Just a Day in the Office. All rights reserved.
Hiero by aThemes