I don't think that the server is creating new column to an existing table as sparse columns.     Creating column as sparse columns has a big effect on the storage...

One more option is to use Audit.  I have to admit that I didn't use it for a very long time (few years).  The advantage that it has is that...

Can you write a small script that creates your table, insert some data and show us the results that you expect to get?  It would help us make sure that...

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...