This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.
Question: What is N in nvarchar?
Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback.
I get to work with various different versions and environment when I am busy with my clients with Comprehensive Database Performance Health Check. While I work with different customers often I forget what data type is supported by which version of SQL Server. Here is a small quick trick, I use all the time when I need to know what are the different data types supported by the version I am working with.
Question: How to Extract Alphanumeric Only From A String?
One of my client of Comprehensive Database Performance Health Check sent me the following email about SQL_VARIANT_PROPERTY Function. I really love my job as SQL Server consultant as I get to learn most of the new stuff or discover the hidden knowledge nuggets which I have discovered. Today’s problem is one such problem which I had never come across till I was asked this question by my client.