For a 400GB heap table, the safest approach is usually a side by side migration rather than creating a clustered index directly on the existing table.

Create a new table with...

You can run following script before schema owner change. Save the Output. Rerun the output after the schema owner change.

SELECT dp.class,c.name,
    'GRANT ' +...

Low memory may cause the delay but you would see the evidence such as memory grant waits(Resource_Semaphore), compile memory pressure(Resource_Semaphore_Query_Compile). You can look at sys.dm_exec_query_memory_grants dmv to check if memory...

If possible, you can create the indexed view on top the table and add Pk to the indexed view and replicate the view.

Or you can exclude tables without Pk keys.

Change Tracking or Change Data Capture is good option for on-going monitoring.

I will try to give couple of scenarios:

1. Try disabling log backups. This will force the logs until the disk is full. Now Database cannot write transactions.
2. Fill up the...

Microsoft's Official Recommendation

1. For single NUMA node, <= 8 logical CPUs then se number of logical CPUs
2. For single NUMA node, > 8 logical CPUs then set to 8
3. For...

Hello,

I have updated the file. There are tables and functions in it and also the requirement is specified in requirement sheet. Can u help me out?

I have also provided the ddl statements

Hello,

Using the table EmpHistory, it is not satisfying all the rules. So I want to use this function as it satisfies all the rules. This is what I want:

I have...

Hello Luis,

Actually, there is table valued function which gives the same data as the emphistory table. I want to use that tabel instead of CTE. I have also provided the...

Hello,

When I print it its correct. But when I see the report online that column doesn't show up. Can you help me with this?

Hello Rob,

Can u also tell how to covert if the data type is varchar.

Thanks in advance.

This too doesn't work. Is there any other way to do this.

With Format(), I am getting some thing like this:

OctAber

SetAmber

etc

Hello,

Originally, that column has Date as Data type. So, now what to do? IS there any other procedure to do this?