Today is India’s Republic Day – Happy Republic Day to all the fellow Indians.
SQL SERVER – Query Analyzer Shortcuts
In year 2007 I had written a one of the very first downloadable PDF. This is something I had created for me as a production DBA, whole day I was working on SSMS.
Fix : Remote Desktop Copy Paste Stop Working
Though not a SQL Solution, this has to be one of the most annoying issues I faced in my career when working on Windows Server. After posting this blog post, I realized that I was not the first one who faced this issue and there are many others who have faced similar issues.
Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
Database partitioning is a very important concept and very useful. Many a times DBA partition database for performance and many times to handle large volume. As this operation is usually done when there are huge amount of data exists this is quite a critical task to be performed by the DBA. In this blog post, I have explained step by step how to create horizontal partition which provides optimal performance.
Rules for Optimizining Any Query – Best Practices for Query Optimization
In this article I have not focused on depth but listed something of the simple tricks which DBA can apply to gain immediate performance gain. Though the tricks are very simple, if we notice carefully in our product server, we will find many of those not followed.
SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2
This is simple to the point blog post where I have demonstrated a script to find the longest running query from the database.
Shrinking NDF and MDF Files – A Safe Operation
First of all – Shinking database is very bad stuff thing – it reduces the performance as well does not help much. However, the question is different here. Is Shrinking NDF and MDF files is safe for data? I described the same in the blog post.
Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
During the SQL Server Optimization training, I enjoy teaching Execution Plans Following are some common questions related to costs:
Q: What is the estimated I/O cost?
Q: What is the estimated CPU cost?
Q: Why there is no unit of measurement for estimated costs?
In this blog post, I tried to answer above questions.
Find Statistics Update Date – Update Statistics
Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). Quite often I have heard the suggestion to update the statistics if query is not optimal. If you want to know when your statistics was last updated, you can run the query specified in the blog.
Shrinking Database is Bad – Increases Fragmentation – Reduces Performance
No matter how many times we talk that database shrinking is bad – I see in industry multiple times that this is being practiced. The common question I receive back is that if this is bad why is it allowed or how can I regain my space back. Well, in this blog post I demonstrate how Shrinking is bad and it does not achieve the issue with space. Additionally, it also reduces the performance by increasing fragmentation.
SQL Server 2012 SSMS Tricks
I wrote two quick articles where I demonstrate two enhencements of SQL Server Management Studio 2012. Here they are:
Jan 2012 was a quiz month and we had a great time asking interesting questions and have received fantastic responses. Do you know the answers of the questions – if yes, fantastic if no, you still have time to go over them and refresh your memory.
- SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31
- SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31
- SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31
- SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31
- SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31
- SQL SERVER – Correct Value for Fillfactor – Quiz – Puzzle – 24 of 31
- SQL SERVER – Different Aspect of Policy Based Management – Quiz – Puzzle – 25 of 31
Reference: Pinal Dave (https://blog.sqlauthority.com)