# Thinking outside the box

Patron Saint of Lost Yaks
posts - 203, comments - 734, trackbacks - 4

## July 2011 Blog Posts

##### Do people want help? I mean, real help?

Or do they just want to continue with their old habits? The reason for this blog post is that I the last week have tried to help people on several forums. Most of them just want to know how to solve their current problem and there is no harm in that. But when I recognize the same poster the very next day with a similar problem I ask myself; Did I really help him or her at all? All I did was probably to help the poster keep...

posted @ Sunday, July 24, 2011 8:08 AM | Feedback (14) | Filed Under [ Miscellaneous Denali ]

##### Code Audit - The Beginning

For the next few months, I will be involved in an interesting project for a mission critical application that our company have outsourced to a well-known and respected consulting company here Sweden. My part will be the technical details of the forecasting application now when our former DBA has left our company. Today I took a brief look at the smallest building blocks; the Functions. No function is inline so I can assume some of the performance issues are derived from these. One function I stumled across is very simple. All it does is to add a timepart from current execution time to...

posted @ Thursday, July 21, 2011 8:44 AM | Feedback (2) | Filed Under [ Optimization SQL Server 2008 Algorithms Administration SQL Server 2005 ]

##### A glance at SQL Server Denali CTP3 - DATEFROMPARTS

There is a new function in SQL Server Denali named DATEFROMPART. What is does, is to calculate a date from a number of user supplied parameters such as Year, Month and Date. Previously you had to use a formula like this DATEADD(MONTH, 12 * @Year + @Month - 22801, @Day) to calculate the correct datevalue from the parameters. With the new DATEFROMPARTS, you simple write DATEFROMPARTS(@Year, @Month, @Day) and you get the same result, only slower by 22 percent. So why should you use the new function, if it's slower? There are two good arguments for this 1) It is easier to remember 2) It has a built-in validator...

posted @ Wednesday, July 13, 2011 9:18 AM | Feedback (5) | Filed Under [ Denali ]

##### MVP renewed

I got an email last friday telling me I was to keep my MVP status! What do one say about that? Except "Thank you". To all that reads my articles and posts. To all who attends my presentations. //Peter

posted @ Sunday, July 03, 2011 3:20 PM | Feedback (0) | Filed Under [ Miscellaneous ]

Powered by: