Hi Steve,

We also almost never run CHECKDB.

This is because it takes tooooooo long.

I'm taking something above 50 hours.

When we restore a backup onto our test system, the normal procedure is...

I use the scripts provided by Ola Hallengren.

It can be found at http://ola.hallengren.com/

It knocks the socks off any other attempt...

Best regards,

Henrik Staun Poulsen

http://www.stovi.com

hi Spin,

I would look at Sommarskogs homepage for a detailed description of the problem.

Best regards,

Henrik

Hi Muthukkumaran,

Did you look at http://ola.hallengren.com/

IMHO it works better on larger databases.

Best regards,

Henrik Staun Poulsen

Stovi Software

Hi Wayne,

nice comparison, but I cannot find what you compare the DateAddDateDiff method to.

Could you show the code, please?

Best regards,

Henrik Staun Poulsen

http://www.stovi.com

Hi nemerko,

If you have some objects with SCHEMA BINDING, such as UDFs, index views and properly other stuff too, then you need to script those out separately.

It is, as others...

Thank you all, for the nice words.

A special "thank you" goes to Hugo, for the suggestion for formatting the fields in 3 columns, or how-ever many columns that fit onto...

well, it was a bug...

In my own code!

I know; I created it myself.

Easy for me to fix, as soon as I noticed that column order was important.

It is a bit...

Well, since I wrote it up as a QotD, you may not need three guesses as to who went into this "trap" big time.

I've spent a few hours, before I...

hi JustOffal,

I'm glad it helped you. I've found so much help here on sqlservercentral.com, so it is nice to do a little pay back.

Best regards,

Henrik

Hi,

You could also make it a NVarchar(max) field.

When the data is short or null, all data are stored "on row", otherwise it will be moved to a separate page.

So...

Hi Jeff,

It is not question of doing either this or that; I need to both fix the code so that it does not crash, then when I know what signal...

hi Peter,

That was a smart use of NULLIF.

NULLIF(xx, 255) is just what is needed.

Best regards,

Henrik

Hi Jeff,

Well, yes that might be true. But my meta data says that it is a float. So my transform job crashed.

With my improvement, the code continues to run on...

I've started using your function, but...

SELECT utl.fnBinaryReal2Real(0x43F8E354) -- 497,776

SELECT utl.fnBinaryReal2Real(0xFFFFF2D7) -- overflows

Yes, I think it is my source that is sending rubbish, but I would like the function to survive.

Here...