It is totally possible to Insert Multiple Values into Multiple Tables in a Single Statement. Let us learn how we can do that in today’s video.
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.
Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
I have recently released a new course at Pluralsight on Storing and Managing Data with Postgres on Heroku. Let us learn more about it today.
Yesterday I blogged about SQL SERVER – Performance Comparison – BETWEEN, IN, and Operators. Following that, I got many emails about the topic.
In today’s blog post let us discuss Performance Comparison – BETWEEN, IN, and Operators. I recently discussed this during the Health Check.
I explained how Unicode datatype works, you can read that blog here SQL SERVER – Storing a Non-English String in Table – Unicode character strings.