Here are few of the best practices one should follow for SQL Server Health Check.
SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability
Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here. Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the…
Read MoreSQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT
Few of the questions I receive very frequently. I have collect them in spreadsheet and try to answer them frequently. How to convert text to integer in SQL? If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or…
Read MoreSQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
Yesterday I posted small note about SQL SERVER – 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have…
Read MoreSQL SERVER – 2005 Best Practices Analyzer (July BPA)
The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. DOWNLOAD HERE Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause
In recent interview sessions in hiring process I asked this question to every prospect who said they know basic SQL. Surprisingly, none answered me correct. They knew lots of things in details but not this simple one. One prospect said he does not know cause it is not on this…
Read MoreSQL SERVER – Recompile All The Stored Procedure on Specific Table
I have noticed that after inserting many rows in one table many times the stored procedure on that table executes slower or degrades. This happens quite often after BCP or DTS. I prefer to recompile all the stored procedure on the table, which has faced mass insert or update. sp_recompiles…
Read More