Systems Engineering and RDBMS

  • Click Here for Decipher's Homepage


  • Categories

  • Questions?

    Please send your wish list of things that you would like us to write about or if you have suggestions to help improve this blog site. You can send all questions/suggestions to: Blog Support
  • Archives

  • Blog Stats

    • 7,319,108 Views

Archive for February 18th, 2008

Windows 2008 RTM

Posted by decipherinfosys on February 18, 2008

Windows 2008 has been released to manufacturing and the company is all geared up for it’s Feb. 27th launch of Windows 2008, Visual Studio 2008 and SQL Server 2008. Keep in mind that the launch of SQL Server 2008 does not mean that SQL Server 2008 is being released to manufacturing yet. Read our previous post here on the latest on the timeline for SQL Server 2008.

We have Windows 2008 installed and are performing tests as we speak. We have been impressed with the initial runs – the speed, the UI changes, the features and will be posting more on it in the days to come. You can also read more on Windows 2008 in the Windows 2008 Reviewers Guide at Microsoft Tech Center.

Posted in Windows | 1 Comment »

1TB Drives for Arrays

Posted by decipherinfosys on February 18, 2008

IBM is also using 1TB drives for it’s storage arrays now. Think about what this could mean for the data storage needs for large data centers. You can read more on this at this eWeek link:

http://www.eweek.com/c/a/Storage/IBM-Moves-to-1TB-Drives-for-New-Arrays/

Posted in Hardware, News | Leave a Comment »

Some important bug fixes for SQL Server 2005

Posted by decipherinfosys on February 18, 2008

We ran into a couple of issues while helping one of our clients and were researching the fixes for those issues and it turns out that the fixes for those are available in some of the cumulative updates so we thought we would share them with you. If you do not do so already, you should keep an eye out on the bug fixes that are released by MSFT in the cumulative updates. You can look at KBalertz.com and can subscribe to the automatic notifications so that you do not spend too much time troubleshooting issues that are really bugs in the product that have already been reported and fixed by MSFT.

Here are some that we found while working for our client:

FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”

FIX: Some rows are not returned when you run a complex query that uses the DISTINCT keyword in Microsoft SQL Server 2005

FIX: A blocking issue occurs when you update rows in a table in SQL Server 2005

FIX: A stored procedure cannot finish its execution in SQL Server 2005

Posted in SQL Server | 1 Comment »