As a regular reader, you may know that I now a days work with MySQL and SQL Server both at the same time. Working with two different products have changed quite a few things in how I write code. Here is an example of that – I changed myself about how I CONCAT strings.
SQL SERVER – What Permissions I have on Database I am Connected to?
Here is the first thing I do when I get access to any new server – I check what are different permissions I have with respect to the database I am connected with. The matter of the fact is that most of the database consultants and administrator want to know…
Read MoreMySQL – How to Create Stored Procedure
If you are beginner with MySQL, you will face this particular issue while creating Stored Procedure. When I started with MySQL I had faced the similar situation as well. In MySQL we end every statement with semicolon. However, when we try to create stored procedure we face dilemmas that how…
Read More
SQL SERVER – Working with Business Days in SQL Server – A Different Approach
I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.
SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only
Earlier last week I wrote a blog post about Statistics for Read-Only Database are in TempDB, I received a very interesting comment from Ayman El-Ghazali on the same blog post. Let me reproduce the same comment over here. “Nice post. What if you create a database, create some statistics in…
Read More
SQL SERVER – Statistics for Read-Only Database are in TempDB
Here is the question I received when I was explaining about Statistics in SQLLive360 event in Orlando. “As we use database tables and run various queries on SQL Server, it automatically creates statistics and the statistics helps eventually queries to execute efficiently. I also understand that statistics are stored in…
Read More
SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer
Here is a very interesting question I received, which is based on my MySQL courses. The same script works on SQL Server as well as MySQL. Let us understand how to Order Column by Nearest Value for Any Integer.