Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
Pluralsight – Storing and Managing Data with Postgres on Heroku
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.
Performance Comparison – IN vs BETWEEN – SQL in Sixty Seconds #127
Yesterday I blogged about SQL SERVER – Performance Comparison – BETWEEN, IN, and Operators. Following that, I got many emails about the topic.
SQL SERVER – Performance Comparison – BETWEEN, IN and Operators
In today’s blog post let us discuss Performance Comparison – BETWEEN, IN, and Operators. I recently discussed this during the Health Check.Â
SQL SERVER – Datatype Storing Unicode Character Strings
I explained how Unicode datatype works, you can read that blog here SQL SERVER – Storing a Non-English String in Table – Unicode character strings.
Varchar vs Nvarchar – Storing Non-English Characters – SQL in Sixty Seconds #126
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.
SQL SERVER – Storing a Non-English String in Table – Unicode Strings
Yesterday I had a meeting with my client Performance Health Check, and they wanted to know how to store a non-English string in a table.Â