When doing performance analyzes you often would want to see 95
percentile, 99 percentile and similar values. The "average" is the evil
of performance...
0 replies - 2869 views - 12/03/08 by PeterZaitsev in News
One of the biggest mistakes of
today's fledgling MySQL programmers is their field type definitions,
also known as data type or column type. Many are too quick...
1 replies - 5228 views - 12/02/08 by Mike Bernat in News
When installing and using production web applications, backup is always a must. I have written about SQL Server Backup
before and this post would expend on...
0 replies - 3243 views - 11/07/08 by Boyan Kostadinov in News
Following up on my Previous Post I decided to do little test to see how accurate stats we can get for for Index Stats created by ANALYZE TABLE for MyISAM and...
0 replies - 2898 views - 09/11/08 by Schalk Neethling in News
Have you ever seen the replication stopped with message like this:
Last_Error: Could not parse relay log event entry. The
possible reasons are: the master's...
0 replies - 4100 views - 09/09/08 by Schalk Neethling in News
This session will introduce the basics of the Lua language, with particular
emphasis on the features of immediate use with MySQL Proxy.
The lecture will...
0 replies - 2352 views - 09/08/08 by Schalk Neethling in News
The below given query will fetch the duplicate rows in MSSQL with number of occurance of each row.SELECT <all column names - comma seperated>,...
0 replies - 2298 views - 09/01/08 by arunbiji in Tips and Tricks
Early this week I encountered the post "Why the Database as a Service is a Bad Idea" written by Arnon Rotem-Gal-Oz in DZone. The title caught my eye...
0 replies - 1790 views - 08/21/08 by gilf in News
Hi there back again. Hope everyone is already exploiting the power of
LINQ on a fairly regular basis. Okay, everyone knows by now how simple
LINQ queries with...
0 replies - 4675 views - 08/20/08 by bdesmet in News
JOINs are expensive and it most typical the fewer tables (for the
same database) you join the better performance you will get. As for any
rules there are...
1 replies - 3642 views - 08/14/08 by Schalk Neethling in News
