Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
You might have heard that SELECT * is bad for queries performance. Let us learn in today’s video how we can replace STAR (*) by column name.
Yesterday I blogged about SQL SERVER – Performance Comparison – BETWEEN, IN, and Operators. Following that, I got many emails about the topic.
Let us learn how to store non-English Characters in SQL Server tables. You will learn in this video the major difference between VARCHAR and NVARCHAR.
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.