But there is a question: how do I check the recompilation time? because in profiler I don't have an option for duration for this. I verified until now the duration...

Unfortunately I don't really know the logic of the sp.It's the first time I see most of the big ones, and this is one.

About the recompiling the problem is that...

I found an article that says : : The KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent tables

Should I...

Another question. If the information in one of the table in the sp is updated pretty often, like few hundreds in an hour, is this a possible cause for recompilation?...

I tried what you said and I get the same error.It means that is over.. :-), unfortunately.Any other "methods"? even if they are more destructive.

Thanks for the response

Ok

I really didn't know how to deal with this, and I'm glad I know the answer

Thanks a lot

aha...ok...

So, it's there a way to make them look alike?because I want them to be the same structurally, when I compare them with Apex Sql to see no difference.Is this...

Yes, it's right what you say, but my field is not mandatory, it only shows me that some persons have or not have a certain attribution. I also have persons...

i did the "isnull" solution and it is working

the question now is : is this the best...the most professional solution?

or to verify separate : value and null value?

and if the space is reused, at the first transaction the size of the log will be minimal or it will be constant the size before the backup.And if I...

So

The initial database was prety big. It contained persons and information for this persons.

In 2 tables we had lots of information, so these two tables and the sp that use...

I'll read Gail's article and see some things because my lack of knowledge is making me ask some silly questions. I think I didn't understand some things...so I will read...

the table looks like this:

CREATE TABLE [Mt_Anag]

(

[Anag_Id] [uniqueidentifier] NOT NULL,

[Cedacri] [bigint] NOT NULL,

[Ruo_Id] [uniqueidentifier] NOT NULL,

[Niu_Id] [uniqueidentifier] NOT NULL,

[Data_Censimento_Host] [datetime] NULL,

[Stato_Censimento_Host] [tinyint]...

So....

The table contains person information and it looks like this

column1 uniqueidentifier,

column 2 bigint,

column 3 varchar(30),

...

column 12 decimal(18,2)

from column 3 to 12 there are columns that contain data, int,decimal or char

column2...

As I sad I haven't worked with logs, so if I make a backup to a log....is it the same as working with a database....I will have to restore it,...