Microsoft SQL Server 2008
Microsoft SQL Server 2008, aka "Katmai", gives SQL Server shops plenty of reasons to get excited.
It's not without its faults, but Microsoft SQL Server 2008 easily passes our own five-point test for upgrades by bringing at least five significant improvements to a data environment. It's a winner.
Microsoft SQL Server 2008: index improvements
Indexes have received an overhaul. Not only can indexes be compressed in SQL Server 2008, but you can also build filtered indexes. Filtered indexes have a "where" clause, allowing you to partially index a large table. This may not seem very useful at first, but there are situations where it's very beneficial.
For example, let's look at a Sparse Column situation. Say you have 400 million records in a table with a significant number of null values, and you've defined a Sparse Column, so you're not taking up space for all of those nulls. Well, if you don't want to take up storage space with null values, then you surely don't want to take up index space with them either. Here you would define a filtered index on that sparse column where the value is not null so that only rows with actual data in them are indexed.
Not only can you save a lot of index space with filtered indexes, but the queries that use those indexes will be faster because they're running against a subset of the entire data set. You also shrink the maintenance window and re-index space for the index.
Another good use of filtered indexes might be if you have, say, 10 years of data in a table but nobody ever queries further than two years back. You could create a filtered index for just those two years and get the same benefits as in the first scenario.
Join the newsletter!
Cartier Calibre de Cartier Diver Watch
Ballistix Tactical Tracer RGB 3000
Samsung QLED 8K TV
Apple iMac Pro
Bang and Olufsen Beoplay A9 Speaker
Ballistix Sport AT
Toys for Boys
Nix Pro Colour Sensor
ESET Smart Security Premium
Tivoli PAL BT
ESET Internet Security
ESET Cyber Security Pro for Mac
Oregon Pro WMR500 Weather Station
Little Bits DROID Inventor Kit
Osmo Coding Awbie Game
Ikea RIGGAD work lamp with wireless charging
Ultimate Ears Wonderboom Bluetooth Speaker
TimeFlip Magnet Simple Time Tracking Device
Naztech Xtra Drive Mini + 256GB microSD Card
SmartLens - Clip on Phone Camera Lens Set of 3
Ransomware has been one of the most prolific malware families for years, generating financial losses for targeted users and organizations, as well as significant revenue for cybercriminals.
Most Popular Reviews
- 1 Oppo R17 Pro review: Oppo's thriftiest flagship yet drives a hard bargain
- 2 Nokia 7.1 review: A modest and modern mid-tier option
- 3 Tenda Nova MW6 review: A gateway drug for mesh Wi-Fi
- 4 Huawei Mate 20 Pro review: Expensive, but probably the best phone you can buy right now
- 5 Apple iPhone XS review: Astonishment at a price
Latest News Articles
- CBA capitulates, will support Apple Pay next year
- Intel unveils the Intel Neural Compute Stick 2
- Fetch TV expands with Aussie Broadband
- Adobe announces next generation of Creative Cloud
- Logitech announces Logitech Rally
PCW Evaluation Team
Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications
I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)
It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!
The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.
I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.
If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.
- PC World 2018 Editor's Choice Awards
- Huawei Mate 20 Pro review: Full, in-depth, Australian review
- Razer Phone 2 review: One for the fans
- Everything you need to know about Smart TVs
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?