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.
They found out that they have a full backup running for one of the largest servers and at the same time they are running a log backup on the same server.