SQL Server 2008 – Filtered Indexes
SQL Server 2008 introduces a new feature called Filtered Index. A filtered index is a way of adding a WHERE clause to the index definition… Read More »SQL Server 2008 – Filtered Indexes
SQL Server 2008 introduces a new feature called Filtered Index. A filtered index is a way of adding a WHERE clause to the index definition… Read More »SQL Server 2008 – Filtered Indexes
The biggest benefit that I see with the new backup compression in SQL Server 2008 is that it improves the speed of the restore. The… Read More »SQL Server 2008 – Backup Compression
In SQL Server, an empty or a null column still would take up space in the database, so even if you added a column that… Read More »SQL Server 2008 – Sparse Columns
Since I am no longer paying for an broadcast television service (other than Netflix). Not satellite, no cable TV, and no broadcast TV. Now I… Read More »Giving up on Regular Broadcast TV
A week or so ago I heard someone on the radio talking about Open DNS as a way to help protect children from some of… Read More »OpenDNS Review – What a Great Site, what a great service
MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE… Read More »A Comparison of Oracle and MySQL
Wow, what a day, this was a fabulous adventure. We rented a SUV and the guy at the rental shop told us that we were… Read More »Kauai Tunnel Hike
Just started working at Amazon.com. Now I need to take everything that I know about SQL server and apply it to Oracle.
Working on the Cyberprise project at Wall Data where we are utilizing Microsoft SQL server to create a corporate intranet product which includes connectivity to… Read More »Working With SQL Server Again
We just got the first version of WinTech a SQL Server based support services tool completed, and the team Supporting the Windows 3.0 product started… Read More »WinTech released to Microsoft Support Services