I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.
SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.
How to Copy Files in SQL Server? – Interview Question of the Week #257
Question: How to Copy Files in SQL Server?
Answer: SQL Server 2019 has very interesting features that can make a life of DBA’s and Developers very easy.
5 Learning Paths to Learn Technology Online
This entire week we have discussed various technology and different learning path where we can learn new technology online.
Learn SQL – New Technology Week
This is the last week of the year and this is the last post in the new technology week. Today we will discuss where we can learn SQL Server online.
Learn Blogging – New Technology Week
This is the last week of the year and most places it is a holiday. Today we will discuss where we can learn Blogging online.
Learn MySQL – New Technology Week
This is the last week of the year and most places it is a holiday. Today we will discuss about where we can learn MySQL online.
Learn PostgreSQL – New Technology Week
This is the last week of the year and most places it is a holiday. Today we will discuss where we can learn PostgreSQL. PostgreSQL Learning Path
Learn MariaDB – New Technology Week
This is the last week of the year and most places it is a holiday. Today we will discuss where we can learn MariaDB.
Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256
Question: Can Admin Rename SA Account in SQL Server?
Answer: Yes, of course. The syntax for to rename SA account is very simple: