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.
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.
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.
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.
How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.
I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?
Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.
One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.