In today’s blog we are going to talk about the SQL Server feature which actually exists for a quite a while but interestingly enough it is not known much. Let us have a quick introduction to startup procedures.
SQL SERVER – Execution Plan Ignores Tabs, Spaces and Comments
Just another day I was delivering my training SQL Server Performance Tuning Practical Workshop, I noticed that organizations had many stored procedures but none of the SP had any comments. When I asked them why their Stored Procedures does not have comments, their point was that they believed because of the comments, the size of the execution plan increases. Not True, when SQL Server builds an execution plan, it ignores tabs, spaces, and all the comments.
SQL SERVER – Unable to Start SQL Resource in Cluster – HUGE Master Database!
One of my clients contacted me and informed that SQL in cluster failed over from Node 01 to Node 02. It failed to come online on Node 02, failed back to Node 01, and it failed to come online there either. They contacted me to know why they are not able to start SQL Server in the cluster. Let us learn how to start the SQL Resource in Cluster when there is a huge master database.
SQL SERVER – Alternate Rows Color in Table Background in HTML
Have you ever felt when you get hired to do a job and your customers ask you question, which you would have not imagined in your wildest dream? Well, just happened to me yesterday where I was asked how to write T-SQL to show alternate rows color in table background in HTML.
SQL SERVER – Save Auto Recover Information – SSMS
Though, I have many complaints about SQL Server Management Studio (SSMS) (read the latest one here), I also like some of the features for sure. In this blog post, we will take about Auto Recover feature of SQL Server Management Studio.
SQL SERVER – Adding Values WITH OVER and PARTITION BY
Once in a while, I get questions where users have indeed explained the question well enough that I can easily understand their question. If I understand question quickly, I am always able to answer it efficiently as well. In this blog post, we will see one such question which I answered with keywords WITH OVER and PARTITION BY.
SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?
Question: How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?