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!
Most Popular Reviews
- 1 Oppo A73 review: The budget smartphone that sets the bar for 2018
- 2 Oppo R11s review: The iClone you know and love, but not quite the one you deserve
- 3 Blackberry KEYone Black Edition review: What the original KEYone should have been
- 4 Zolo Liberty+ review: The true wireless earbuds you've been waiting for
- 5 Samsung Gear IconX 2018 review: The path of least resistance makes for an easy upgrade
Latest News Articles
- Sonos say Aussie Alexa support for One smart speaker won't arrive until Autumn 2018
- Transport for NSW boosts digital experience with Amazon Alexa
- Irdeto Acquires Denuvo
- Businesses jump on Amazon’s Alexa after Australian launch date revealed
- Officeworks hops on voice interface bandwagon with Google Assistant integration
PCW Evaluation Team
The printer was convenient, produced clear and vibrant images and was very easy to use
I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.
It’s easy to set up, it’s compact and quiet when printing and to top if off, the print quality is excellent. This is hands down the best printer I’ve used for printing labels.
Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.
The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.
The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.
- Interview - Netgear CEO Patrick Lo talks eSports, the NBN and why mesh is the smartphone of home Wi-Fi
- Everything You Can Do, I Can Do Better: Comparing The Google Home’s Assistant To Amazon Echo’s Alexa
- Samsung Galaxy S9+ review: A predictably-exellent flagship uplifted by a standout camera
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
Product Launch Showcase
- FTJava Developer (API)Other
- CCSenior Project CoordinatorNSW
- FTBusiness AnalystSA
- FTProject Manager - DatawarehouseACT
- FTBusiness AnalystNSW
- FTTest AnalystQLD
- FTIT SpecialistSA
- FTSoftware EngineerOther
- FTProject Manager - SAP Asset ManagementOther
- FTSenior Project Coordinator, Project DeliveryOther
- FTWireless Consulting EngineerNSW
- FTJava DeveloperWA
- FTOracle SOA Integration ConsultantOther
- FTJava DeveloperOther
- TPMessaging EngineerQLD
- FTApplication Delivery Manager - HealthcareQLD
- FTBusiness Intelligence DeveloperNSW
- FTInformation Management OfficerVIC
- FTSenior Business AnalystOther
- FTHelp desk Support AnalystOther
- TPChange and Communication ManagerVIC
- FTOrganisational Change ManagerOther
- FTOracle SOA DeveloperOther
- TPSenior Java Developer / IntegratorACT
- FTSoftware Media Applications SpecialistOther