Or a Synonym https://technet.microsoft.com/en-us/library/ms190626(v=sql.105).aspx

I can't test because I don't have your tmpaccthist_2013_2014_report_2 table or fn_split

BUT don't you have to declare @crpt_NotaPenyataKewangan_12_Vertical_1 as being a SearchTableType e.g.

Declare @crpt_NotaPenyataKewangan_12_Vertical_1 SearchTableType

You've declared it...

I suppose you have 3 approaches

1. Continue with your current solution. Write the table out manually (It's 100 views so, yes, it's boring and liable to mistakes but...

The reason you get three tables with the same name is that the cursor loops 3 times and overwrites the change from the previous loop.

You can fix that by putting...

This is ePolicy Orchestrator, right? If you have a support contract, I think you should make a call.

If your database is out of space through normal day-to-day usage,...

Post the query plan (Actual) please. We don't know what your data looks like so we don't know what indexes will be used.

Also I notice there's no 'ORDER BY'...

Shouldn't be happening.

Are you using the same database?

I notice that you use schema [dbo] for one table and not for the other - is that a factor?

FREETEXT searches are all about meaning, so SQL Server looks in the thesaurus to find matching words. If you edit the thesaurus so that 'Projectnummer' is a synonym for...

Was it the sp_RebuildIndexes script? That's posted on a few places on the net.

Many people use this

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

You'll have to access the Extended File Properties of the file but I don't think you can do it with TSQL. The Extended Properties vary according to the type...

I hope this doesn't come over as rude but how is your sql? Most of the logic is there and I pointed you at the condition which was stopping...

That seems over-complicated.

Have you tried

ALTER TABLE tablename REBUILD ?

ok, thanks for the additional info.

Can you tell me a little bit about your tables, are they heaps? Do you have clustered and/or non-clustered indexes on your tables?

Can you...

Look at the condition 'AND s.freq_type in (4, 8) --- means Daily'.

If [freq_type] in msdb.dbo.sysschedules is 1, the [active_start_date]

and [active_start_time] give the details.

Taking a step back, what problem are you trying to solve? You say you have fragmentation caused by deleting rows so are your indexes performing poorly? or is it...