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 to get faster access to a subset of the data. For instance if you have a huge table where you are typically only accessing a small part of the table, you can add a filtered …
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 thing that is far more important that a database backup is the actual restore process, and with a compressed backup, this can speed up the restore time by as much as 40% which can make …
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 was set to null values, there would still be space taken up in the database. Sparse Columns introduced in SQL Server 2008, are a new type of column configuration that truly take up zero space …
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 am 100% internet TV, I guess I should say 100% legal internet 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 the nasty sites on the internet. After using it now for about a week, I am very impressed, and I have realize that there are some very interesting features beyond just blocking bad sites. DNS …
OpenDNS Review – What a Great Site, what a great service Read more »
MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE rowmun < 10 MySql uses the LIMIT clause. SELECT * FROM tablename LIMIT 10 Bind Variables The latest versions of MySql supports bind variables, and Oracle has supported bind variables for a very long time. …
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 not allowed to take it off of the pavement. I guess what he doesn’t know won’t hurt us. Our team today consisted of Steve, Marcia, Alex (8 years old), and Uncle Glenn (2nd time Geocaching). …
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 AS/400’s and manframes.
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 using it.