Just to wrap up this week’s discussion on VLDBs we need to look at the new features of SQL Server 2008 as it improves the Data Partitioning features introduced in 2005. Let’s take a look. First of all ...

One of the restrictions of SQL Server 2005 (and now in 2008) is that you cannot include an ORDER BY within a view. This presumably is to remove the possibility of a “double sort” where the view ...

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs. I ...