I love talking about performance tuning and I love teaching about performance tuning. If you are in the USA, this is your opportunity to join me to discuss about SQL Server Performance. I’ll be speaking at Live! 360, November 12 – 17 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info:
SQL SERVER – How to Abort Index Rebuilding After Specific Time?
My favorite part of the SQL Server Performance Tuning Practical Workshop is the last part where we open up the floor for questions. Here is one question I received from a DBA last week about index rebuilding.
SQL SERVER – Automatic Startup Not Working for SQL Server Service
Sometimes some behaviors in SQL Server are unexpected and that’s the right time when an expert need to be engaged. In this blog post we will learn about how automatic startup sometimes does not work in SQL Server Services.
SQL SERVER – Find Out Column Name Using COL_NAME() Function
In SQL Server, there are many methods to find out the column names in a table. If you want to find out the column names based on the ordinal position you can do it querying system view size. Columns. Do you know that you can also do this by using COL_NAME() system function?
How is Oracle Temporary Table Different from SQL Server? – Interview Question of the Week #133
Question: How is Oracle Temporary Table Different from SQL Server?
SQL SERVER – How to Check if a Column Exists in SQL Server Table?
Question: How to check if a column exists in SQL Server table?
SQL SERVER – How to Identify Columns Used In A View?
The views are very tricky. Sometimes they help performance and sometimes they negatively impact performance. Recently, during Comprehensive Database Performance Health Check, I realized that one of the view was the real performance killer. The challenge was to identify column used in a view. We decided to open the view and list all the columns but that was very cumbersome tasks. Finally, we decided to write a script which can help identify columns used in a view.