Thanks,

The parameters are of the same data type

Funny thing, if instead of the parameter I use the values directly it will provide a correct exec plan, that is why I...

It is also the primary key, so yes, it is unique

Hi

Not a single open transaction, and the objects at tempdb were tiny

I am trying with this approach, blaming the service broker:

SELECT@@SERVERNAME SvrName, P.spid, P.cmd, P.lastwaittype,

InternalPageCount= internal_objects_alloc_page_count - internal_objects_dealloc_page_count,

InternalUsageMB= (internal_objects_alloc_page_count...

Thanks you!!!

It was a system table related to service broker

sysxmitqueue...

yes I am keeping that one as a last option

now I am more curious about what happened?, what is corrupted? and how to fix it?

CU 10 🙂

I already rebuilded all the indexes, even decompressed them, no blobs in there

I am running a checkdb now

Hi this is the exact error

Execution of filter stored procedure 319272188 failed. See the SQL Server errorlog for more information. (Source: MSSQLServer, Error number: 18764)

Get help: http://help/18764

The said...

have you tried using the pivot function?

Thanks everyone, really good stuff, I will need to add a few things, will post the results back when I am done

yes the autogrowth will be my choice too, you can just set it to grow to something that is not a percentage ( I found that like a bad...

Sure

this should work

Declare

@Newsize int,

@sql nvarchar(500),

@filename nvarchar(100)

SELECT @Newsize=((size*8)/1024)*1.5,@filename=name

FROM sys.master_files

where DB_Name (database_id) = 'COSTDB'

and type=0

set @sql=N'ALTER Database COSTDB

MODIFY FILE (name=''' +@filename+''', SIZE = '+cast(@newsize as nvarchar(10))+' mb)'

execute...

Hi, first question, why do you want to do that?

I dont see why you are stuck in there, have you tried something like

Declare

@sql nvarchar(500)

set @sql=N'alter...

That is what I suspect, but what I do not understand is why the management studio says that the query ended succesfully...

that got me this message:

Msg 5057, Level 16, State 3, Line 1

Cannot add, remove, or modify file 'offline_data' because it is offline.

the state is 7: Defunct