Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
Question: What is EDGE in SQL Server Execution Plan?
Answer: It is the arrow or the line which goes from one operator to another operator.
Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.
Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
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.
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.