SQL Performance Archives - Page 53 of 100 - SQL Authority with Pinal Dave

SQL SERVER – 28 Links for Learning SQL Wait Stats from Beginning

February 28, 2014

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

It has been exact two years since I have written series on SQL Wait Statistics and Queues. I often received quite a few questions related to this subject. Here are my answers to the questions. Q: The series which you have written two years ago, is it still relevant to…

SQL SERVER – SafePeak SQL Server Acceleration Software Gets an Upgrade

February 12, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SafePeak, the SQL Server application acceleration software, gets a new version upgrade and launches on Amazon Cloud Marketplace. SafePeak’s idea in a nutshell is simple. SafePeak is a query-level automated caching middleware for SQL Server-based operational applications. SafePeak accelerates apps by caching SQL queries while keeping a 100% ACID compliance…

Big Data – Real-Time Analytics Performance with ClustrixDB

January 14, 2014

Pinal Dave

Big Data, SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Note: The product used in comparison is ClustrixDB. It is available to download for FREE. NewSQL databases provide scale-out of NoSQL without giving up on SQL or ACID transactions. While most NewSQL databases focus only on transactions, ClustrixDB also provides fast real-time analytics that are becoming increasing important to many…

MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses

January 3, 2014

Pinal Dave

SQL Performance

MySQL, Pluralsight, SQL Server, SQL Training

In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning. I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.

SQL SERVER – Monitor Database via a Heatmap, Alarms List and Realtime Diagnostics for FREE

December 16, 2013

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Dell, SQL Utility

Note: This review is based on the performance monitoring and tuning free product Spotlight on SQL Server Freemium. If you think of a DBA’s life, it has one very simple goal – their server should never go down and all the queries should always perform excellently. However, just like any…

SQL SERVER – Detecting Potential Bottlenecks with the help of Profiler

September 17, 2013

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Probably, everyone who writes SQL code has used INSERT statement, which alongside SELECT, UPDATE and DELETE, is a part of a basic operations’ set for data manipulation. At the first sight syntax of the INSERT statement may seem very trivial , especially when inserting one record – INSERT INTO ……

SQLAuthority News – Learn MySQL Indexing in 99 Minutes – MySQL Indexing for Performance – Video Course

September 3, 2013

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

MySQL, SQL Index

Every year around September 1st, I have decided to do something cool. This is because September 1st is my daughter Shaivi’s birthday. In previous years, I have released my new books as well new courses on this day. This year I have done something similar for her. I like to…