It was a wonderfull day, full of Kimberly Trip and Paul Randal sessions. I will make it short today as they put all the slides and scripts on there website SQLskills.
So only some thoughts for today:
- I always thought that the default fill factor at the server level was 90%. It turned out that it is a 100%. I have to review some things ...
- What new for database mirroring in Sql Server 2008? "Only" 3 things:
* automatically repair of page errors. It is, if the principle gets a bad page, it is corrected with the page information of the mirror and vice versa.
* Log stream compression
* More performance counters available.
That is it (almost) for today, there is one tiny little thing which is so amazing that it urns a separate blog post: the change in function object_name