Browse by Tags
All Tags »
SQL Server (
RSS)
Recently a local SA Developer .NET community member reported an issue installing SQL Server 2008 Express as it required the as yet unreleased .NET Framework 2.0 SP2. I have explained the dependency in my post over here . Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Finally there is a solution to having a unique column with NULL values in it. The answer is using SQL Server 2008 filtered indexes but there is a practical limitation as well. Read more in my post over here . Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Microsoft is definitely on a roll with releasing CTPs and betas lately. The latest drop of SQL Server 2008 is now available for download and I'm extremely happy to see that there is now new data types for representing date and time separately with support for time zone information. How extensive the time zone support will be remains to be seen. Another addition to the July CTP is table valued parameters. In theory you will be able to now be able to have stored procedures that accept multiple...
Recently I posted some reservations on LINQ and in particular LINQ to SQL and the usage of stored procedures. After numerous comments from respected community members I have furthered my quest on the subject and found a very interesting blog entry by Mark Seemann where he shares his thoughts on how LINQ to SQL will impact database development best practices. I feel that he shares my thoughts on the subject and he raises some interesting comments. I am a firm believer in the current database development...
I happened to stumble upon the blog of Mike Taulty and the following three very interesting articles on how LINQ actually works. The first article looks at Lambda expressions and introduces the interface IQueryable<T> which inherits from IEnumerable<T> and Expression property to represent the expression tree ( Expression<T> ). The second article explores the IQueryable<T> interface a bit more and applies it to a simple array of integers to explain the concepts. The third article...
Recently I stumbled upon a rather useful SQL Server 2005 Best Practices section on Microsoft TechNet and I thought others might find it useful. In particular I found the internal function to identify missing indexes based on runtime statistics recorded by the query optimizer quite useful. Just remember it is intended as a guide toward optimization. I find it useful to analyse a running database under typical workload and then determine what indexes could make a major performance impact. Just a pity...
Yesterday the much awaited SQL Server 2005 Service Pack 2 was released to the web. Significant changes include: the ability to run maintenance plans without SQL Server 2005 Integration Services (SSIS) installed performance improvements to the plan cache to make more effective use of physical memory reversal of the SP1 change to SQL Server 2005 Reporting Services (SSRS) where multivalue report parameters lost the Select All option Windows Vista support Note that the links for the express edition don...