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!
Nespresso Creatista Coffee Machine
WD MY PASSPORT™ X Gaming Storage
Bang and Olufsen BeoVision 14
Panasonic OLED 4K Ultra HD TV - TH-55EZ950U
Panasonic OLED 4K Ultra HD TV - TH-77EZ1000U
cloudandco Smart Cane
SanDisk MicroSDXC™ for Nintendo® Switch™
Breitling Superocean Heritage Chronographe 44
WD MY PASSPORT™ Gaming Storage
Apple iPhone X
Toys for Boys
Lego Mindstorms EV3
Onyx Smart Walkie Talkie
LaCie Rugged USB-C Portable Hard Drive
Ubiquiti Network’s Front Row Camera
Bose SoundLink Micro
Leica M10 Digital Rangefinder Camera
Google Daydream View VR Headset
UBTech First Order Stormtrooper Robot
Propel Star Wars T-65 X-Wing Drone
Belkin Pocket Power 10,000mAh
PETKIG Go Smart Dog Leash
Panasonic Hi-Fi - SC-UA7GS-K
Xbox One X
Amazon Echo Bluetooth Speaker
Nest Protect Smart Smoke Alarm
Toffee Bags Commuter Satchel
Dearear Endear In-ear Wireless Earphones
WD MY CLOUD™ HOME Personal Cloud Storage
Panasonic 4K UHD Blu-Ray Player and Full HD Recorder with Netflix - UBT1GL-K
iRobot Roomba 980 Vaccum Cleaning Robot
Razer DeathAdder Expert Ergonomic Gaming Mouse
Tile Pro Bluetooth Tracker
Kogan Bluetooth Soundbar
Fallout Geeki Tikis
Urbanworx Full HD Action Camera
Panasonic Portable Splashproof Fun - RF-D20U
Lexon Flip Alarm Clock
Logitech Doodle Collection Wireless Mouse
3SIXT 3-in-1 Smartphone Lens Kit
Ikea NORDMÄRKE Wireless Charging Pad
Raspberry Pi Starter Kit
Most Popular Reviews
- 1 Fitbit Ionic review: Impressive but not quite iconic
- 2 Acer Spin 5 review: Value for money but conditions apply
- 3 Huawei Mate 10 Pro Review: A solid winter flagship that cribs from the best
- 4 Sony LF-S50G review: Google Assistant and then some
- 5 Google Pixel 2 review: not quite 'pixel perfect' but damn close
Latest News Articles
- Officeworks hops on voice interface bandwagon with Google Assistant integration
- Amazon confirms early 2018 Australian launch for Alexa and Echo
- JBL join smart speaker arena with the portable, waterproof and (Google-powered) JBL Link range
- University of Sydney Signs World-First Agreement with Dropbox
- Microsoft delves deeper into AI with new kit bag of tools
PCW Evaluation Team
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.
The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic
- CES 2018: Belkin go big on wearables accessories
- CES 2018: Alcatel Embrace 18:9 Aspect Ratio In 2018
- OPPO Load Up A73 Smartphone With Flagship Features
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
Product Launch Showcase
- CCDesktop EngineerQLD
- FTProgram ManagerSA
- FTCRM DeveloperACT
- FTUX Design LeadOther
- CCIBM FileNet ConsultantsSA
- FTImplementation Project ManagerOther
- CCTechnical Business Analyst - Government - 12 Month Contract - SydneyNSW
- CCAIX System Administration ? UNIXVIC
- CCNetwork Engineer (Juniper)VIC
- FTBusiness Analyst - CMS / DMSOther
- CCMiddleware SpecialistNSW
- CCSystem Access Administrator - TelcoVIC
- FTCyber Security ArchitectOther
- FTSenior Change Analyst / Change Manager ( Banking background)Other
- FTiOS DeveloperOther
- FTNetwork EngineerSA
- TPICT Service Assurance Manager - ServiceNowQLD
- FTEmbedded Software EngineerWA
- FTDevOps EngineerOther
- FTSenior Insights AnalystNSW
- FT.NET DeveloperNSW
- TPSenior Business Analyst - TechnicalNSW
- TPTechnical WriterQLD
- CCIT Service Desk Specialist - BrisbaneVIC
- FTNatural/ADABAS ProgrammerOther