MySQL Archives - Page 4 of 15 - SQL Authority with Pinal Dave

SQL SERVER – Script: Finding Cumulative IO Per Database File

January 2, 2016

Sharing SQL Server related scripts is something I tend to do from time to time. At the SQLPass one of the attendees for my session around 42 tips asked, if I have any script that is handy to find the IO utilization per database file because they had couple of…

MySQL – Date and Time Related System Functions

December 19, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports lot of functions to get current date and time. The following are some of the system functions. There are two functions to get current date SELECT curdate(),current_date(); There are two functions to get current time SELECT curtime(),current_time(); There are two functions to get current date along with time…

SQL SERVER 2016 – Comparing Execution Plans

November 28, 2015

Pinal Dave

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

Execution Plan, MySQL

New tools bring new capabilities and sometimes these are ingrained deep into the product that we can easily miss them out. And SQL Server 2016 is no different. After installing the CTP, I was pleasantly surprised to see this addition to help our DBA’s who are doing performance tuning and…

MySQL – Get Latest Identity Value by Inserts

November 16, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In SQL Server, whenever you add data to a table that has an identity column, you can get the lastly generated identity value using @@identity or scope_identity(). Similarly, in MySQL you can make use of LAST_INSERT_ID () function Let us create the following dataset Create table test(id int AUTO_INCREMENT NOT…

MySQL – Different Methods to Know MySQL Version

November 5, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In SQL Server, to know the current version of the server, you can use system variable @@VERSION How many of you know that the same can be used in mysql to know the version? Also there are many ways to know the version of MySQL Method 1: Select @@version as…

SQL SERVER – Trick – Running SSMS With Different Windows Account

October 10, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Server Management Studio

Recently in one of my interaction with a DBA inside a big financial organization, I was surprised to see that the administrator was logging into a desktop / server using a different credential. What baffled me was the fact that he was logging off. I immediately asked, why are you…

SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1

June 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Error Messages

I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved. It becomes easier and quicker for an administrator if they ever encounter such errors. This blog…