I solved it yesterday yet, i deattached DB and then attached and recovery.. thx for link, on night shift I will read.

thx for response

Hi Gila, please can you help me? I have test server, and I...

hello,

please can you help me or is not possible ?

thank you for response

Good morning

thank you both for response , it was very good explanation, i understand now,

because i knew before ,how the partition works , but i didnt know about performance...

i think if you copy and paste to "Edit" table, it will appear in table no?

i copy data like this without insert .

Or how can i do...

this ? or you mean the different format of cell in excel ?

i think that you dont need to use this data because from this table we use just...

INSERT INTO [dbo].[TB_WORK_ORDER_AGVEN]

([ORDER_DATE]

,[COMMIT_NO]

...

hello, so programmer solved this frozen with thread, but he said me it will be temporary solution if I tune the query, if its possile

so in attachment i add files...

OK sorry, tommorow i will send direct this query, this is what i wrote second, because i founded after that we need the second.

Now i am not at work,...

anthony.green Here is TB_REINPUT, so i think that not will be problem in second table . If you check the image with sqlplan, there is 77% with seek in TB_REINPUT....

thanks for response

i think that here is nolock needed, because this data are live, you know, this select will be every second and i work in Car company, data...

Hello I have

on the server 1.1.1.2

i think

SELECT * FROM [1.1.1.1].DATABASE.dbo.TABLE

and try

DROP TABLE table_name [1.1.1.1].DATABASE.dbo.TABLE;

IF EXISTS (SELECT COUNT(*) FROM sys.object WHERE OBJECT_ID = OBJECT_ID(N'TABLE'))

DROP TABLE IF...

so i have good reason 🙂

thank you for your cooperation and your patient with me

yes i checked this and understood.

so last question.

is good idea change to detail level and rebuild the next level of index, for example where page count is higher than 50?...

So If it doesn't matter, i don't understand why I get different value ... and how can i see leaf level ( just for learning ) , because i thought...