Have to admit that I don't understand why you have to move the files from E to F and then back when you want to enlarge disk C.  If I...

Change you where clause to use like and wild cards instead of an equal sign.  Also use and instead of or in the where clause:

WHERE [Cars Club]...

As far as I know, you can not config the division of memory between plan cache and data cache.  This is done by the server.

SQL server decided which memory page...

Each index has a price in storage and in the amount of time that insert will take (some of them can save us time for delete and updates but some...

Included columns are very helpful for avoiding lookups, but it is up to you to decide if you should avoid lookups.  This depends on few factors.  For example how much...

You can create a DDL trigger that logs this information into a table.

A while ago I was looking for a new job.  A friend of mine connected me with a company that he worked at their DBA team at the past.  After...

I would BCP the data out and then BCP it in to the test database.  Another option is to use SSIS to import the selected tables.  There is also an...

Since I don't have your table, I couldn't check it, but I think that even if it doesn't work, it can point you to the direction that you need

            
June 24, 2021 at 2:44 pm
            
#3900108

            
            
                                                
        

You don't have to update statistics after rebuilding indexes.  When you rebuild an index SQL server also rebuilds it's statistics.  Since it reads all the records in the table, the...

When I worked also as production DBA, I did set autogrowth for databases's files, but I also had a job which ran every night and checked all databases, and if...

The fact that the 2 queries are the same doesn't guarantee that you'll have the same query plan.  The query plan depends on the data in the tables and the...

I’ve added the option within the function itself and it’s working now. Everything I read online said I could not do that ??

sometimes You just have to try things...

You tried to add it in the middle of your SQL Statement.  Do it after the order by clause

Use sand
Drop table if exists #testfunction;
Select b.*
into #testfunction
From (...

You can use the option (maxrecursion 0) at the SQL statement that uses your table valued function.  Here is an example:

CREATE or alter FUNCTION  Demo
(
 ...