I am working with clients on helping them tune their SQL Server Performance. Let us learn how we can use SET STATISTICS IO to check the query’s performance.
How to Change Database File Size? – Interview Question of the Week #296
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.Â
How to Get Volume Mount Point for SQL Server Files? – Interview Question of the Week #295
Question: How to Get Volume Mount Point for SQL Server Files?Â
Answer: I was asked this question by my client during the recent Health Check.
Heroku – How to Deploy Postgres Add-Ons?
Recently I was helping one of my clients on Performance Health Check, they asked me if I know how to Deploy Postgres Add-Ons on Heroku.