In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion and recompiling sps and views
Helping businesses improve reliability and efficiency of SQL Server
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion and recompiling sps and views
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a new query execution plan, and it can be necessary when the existing execution plan is no longer suitable.
Last week, in the post Common Mistakes in SQL Server - Part 4 I explained about the Auto Growth configuration in SQL Server and how it can adversely impact. This week, I am going to explain a very important thing that is often skipped. It is a common mistake that can indeed lead to performance problems. Implicit Conversion can cause unexpected performance issues and hinder query optimization. This week in Common Mistakes in SQL Server - Part 5 let's speak about the Implicit Conversion.
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your attention to a database configuration that is often missed. If this value is not configured with care, it can cause I/O and CPU spike, and can also cause physical fragmentation.
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I will discuss the Null Value and how it can cause an issue!!
The Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary key – an identifier column. This is the Common Mistakes in SQL Server Part 2
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is the Common Mistakes in SQL Server - Part 1.
In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can be used as SQL Server Security Best Practice Checklist as well
Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. In this article I share some of the pointers that can help you understand How to Secure SQL Server. At times when applications are run in geographically restricted areas, there is less chance of their exploitation. However, […]
I have seen this question many a time that people have asked “The Cloud or On-Premise – is it a go or no go?”. This is something that has been discussed and debated, in detail for a longer period of time. Let’s see what it is and if it is a go or no go? […]
This weekend I was working, as usual, holding the on-call and listening to my favorite singer Kishor Kumar. And, my friend Rakesh call me in jeopardy. One of his clients has reported that one of their Cluster Service failed to bring clustered role online or offline. And, that the cluster is failing back to the […]
Last year, September 2020 we had organized 1st yearly event and we named it Surat Tech Talk. That event was a great success. This year, we are organizing this event again and the call for speaker Surat Tech Talks 2022 is now open. The event is being organized with the help of Surat User Group […]