I was a little lucky on that question because i didn't remember the limit of a float was 1,79E+308 (so 309 length), i thought of a very shortener length !

309/310,...

The DBCC will not raise an exception but only messages ("informative"), so the TRY/CATCH will not prevent anything (and so the 'return' statement will not be reach).

The Backup not fully...

Hi.

3 years after its last publication, this article still sounds great 🙂

I think that it dismissed a T-SQL command that is a good alternative of running 'DBCC DBREINDEX (tablename)' :

ALTER...

I actually generate a database to simulate 5 years of production (about 150GB for the data file).

I started with only one packet of data (23 items).

I first generated the amount...