I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.
SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?
Some of the learnings can lead to another exploration when someone does stump you with something you didn’t know. To understand the basics of batch mode and row mode, read the blog SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode where I have explained the concepts. This…
Read MoreInterview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?
Question: How do you convert ASCII to DECIMAL or DECIMAL to ASCII? Answer: ASCII – Returns the ASCII code value of the leftmost character of a character expression. CHAR – Fixed-length non-Unicode character data with length of n bytes. Examples: --Decimal to ASCII SELECT CHAR(80)+CHAR(73)+CHAR(78)+CHAR(65)+CHAR(76) ASSQLAuthorityAuthor GO --ASCII to Decimal…
Read More