Monthly Archive: December 2011

Dec 21

Assuming order of data without ORDER BY

Why are my results out of order? Many times I have seen posts in forums asking about why their data is not being returned in the order of the clustered index. Similar questions have been brought up questioning the order of data from a view when the view includes an ORDER BY clause (which it …

Continue reading »

Dec 19

Windows Requires Restart: Keeps failing on install of SQL Server 2008 even after restart

For my first content related blog post I wanted to start with something simple and something that is encountered upon installation of SQL Server. I encountered this problem a number of times on desktop machines where a number of peripherals may already be installed. The issue is that when SQL Server is going through its …

Continue reading »

Dec 16

Welome to SQL Know-It-All!

Welcome to SQL Know-It-All! The goal of my blog is to provide information to both beginners and advanced users of SQL Server. Although it will mostly cover information regarding SQL Server and its applications (Integration Services, Reporting Services, Analysis Services, and most importantly Database Engine), it will also periodically contain information regarding other applications or …

Continue reading »