Saturday, October 29, 2005 - Posts

Precise and Deterministic Dates

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Precise and Deterministic Dates
The new RSS feed is here

If you want to include a date literal i.e. '1 oct 2005' in an indexed view then it needs to be converted to a precise deterministic date.

BOL does include the information you need to do this but it's not obvious.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Precise and Deterministic Dates

Great features in Management Studio

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Great features in Management Studio
The new RSS feed is here

I am continuing to find great features in SQL Server 2005. The latest is the log viewer. You now have the power to display logs from SQL Server, Event log, Database Mail and SQL Agent all in on view, merged based on time.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Great features in Management Studio