If you have read release notes of SQL Server 2019, Microsoft has finally made an enhancement to error 8152 – String or binary data would be truncated.
SQL SERVER – ISNUMERIC Function and Interesting Result
Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.
SQL SERVER – PRINT Statement and Format of Date Datatype
we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.
SQL SERVER – Building Date and Time with DATETIMEFROMPARTS()
Today we will have very simple learning about Building Date and Time with DATETIMEFROMPARTS(). We will build the DateTime using a function.
How to Write in Text File from T-SQL in SQL Server? – Interview Question of the Week #236
Question: How to Write in Text File from T-SQL in SQL Server?
The question above was actually asked in an interview and also was not asked in the same word.
How to Remove Quotes of QUOTENAME? – Interview Question of the Week #235
Question: How to Remove Quotes of QUOTENAME? I received based on my yesterday’s blog post SQL SERVER – QUOTENAME Function and Custom Quote Character.
SQL SERVER – QUOTENAME Function and Custom Quote Character
The question was really not related to SQL Server Performance Tuning but DBA wanted to know if they can use any custom Quote Character for their string.