This is the first part of the series Incremental Statistics. Here is the index of the complete series. Let us learn it together in the blog.
SQL SERVER – SELECT INTO with FileGroup or Partitionis Not Possible
The other day, I received an email from user and after a long time before I answer the question, I had to check the answer online. Here is the question – I want to create a new table based from old table, but when I execute following script it gives…
Read MoreMySQL – Grouping by Multiple Columns to Single Column as A String
In this post titled SQL SERVER – Grouping by Multiple Columns to Single Column as A String we have seen how to group multiple column data in comma separate values in a single row grouping by another column by using FOR XML clause. In this post we will see how…
Read MoreSQLAuthority News – Great Time Spent at Great Indian Developers Summit 2014
The Great Indian Developer Conference (GIDS) is one of the most popular annual event held in Bangalore. This year GIDS is scheduled on April 22, 25. I will be presented total four sessions at this event and each session is very different from each other. Here are the details of…
Read MoreDeveloper’s Life – Attitude and Communication – They Can Cause Problems – Notes from the Field #027
Sometimes there are incidents when our attitude creates confusion in the communication and we end up creating a situation which is absolutely not warranted.
SQL SERVER – What is SSAS Tabular Data Model and Why to Use It – Part 2
In my last article, I talked about the basics of tabular data model and why use it. Then I demonstrated step by step creation of a basic tabular model project. In this part I’m going to throw some light on how to create measures and analyses in excel. Let us learn about the SSAS Tabular Data Model.
SQL SERVER – How to Change Compatibility of Database to SQL Server 2014
Yesterday I wrote about how we can install SQL Server 2014. Right after the blog post was live, I received a question from the developer that he has installed SQL Server 2014 and attached a database file from previous version of SQL Server. Right after attaching database, he was not…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.