It is common developer requirement to get missing records from series. For that they generate temporary table and insert complete list of numbers and then find missing numbers using LEFT JOIN. In SQL Server 2005 and 2008, new keyword “WITH” introduced that works with SELECT, INSERT and UPDATE statement that use to create temporary resultset [...]

Posted in Microsoft, Programming No Comments »

SQL Server 2008 First Service Pack (SP1) is now available. Service Pack 1 (SP1) focused on essential updates only, primarily roll-ups of cumulative updates 1 to 3 and fixes to issues reported through the SQL Server community. SP1 eases deployment and management of Service Packs by introducing Slipstream, Service Pack Uninstall, and Report Builder 2.0 [...]

Posted in Microsoft, Technology 1 Comment »

Microsoft SQL Server 2008 provides a scalable Business Intelligence platform optimized for data integration, reporting, and analysis, enabling organizations to deliver intelligence where users want it.
Top New Features

Create high-performance Analysis Services solutions with optimized cube designers, subspace computation, and MOLAP-enabled writeback capabilities.
Implement enterprise-scale Reporting Services solutions through new on-demand processing and instance-based rendering.
Build flexible and [...]

Posted in Microsoft 1 Comment »

Microsoft Windows Server 2008 R2 is the next version of the Windows Server operating system from Microsoft. Building on the features and capabilities of the current Windows Server 2008 release version, Windows Server 2008 R2 allows you to create solutions that are easier to plan, deploy, and manage than previous versions of Windows Server.
The Windows [...]

Posted in Microsoft 13 Comments »