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.
SQL SERVER – Difference Between Count and Count_Big
Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.
What is N in nvarchar? – Interview Question of the Week #301
Question: What is N in nvarchar?
Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.
Solve Puzzle about Data type – SQL in Sixty Seconds #108
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.
SQL SERVER – Stored Procedure sp_datatype_info to Get Supported Data Types
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.
How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214
Question:Â How to Extract Alphanumeric Only From A String?
SQL SERVER – Identify Datatype Using SQL_VARIANT_PROPERTY Function
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.Â