Early Versions (SQL Server 2000 – 2008)

Microsoft SQL Server 2008 logo
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 R2 AppliancesSQL Server 2008 R2 Appliances

Learn about Microsoft and HP's four new database appliances, Parallel Data Warehouse, Business Decision Appliance, Business Data Warehouse, and Database Consolidation Solution for Microsoft SQL Server, all of which run SQL Server 2008 R2.

byMichael Otey
Aug 16, 2011
|
1 Min Read
ITPro Today logo logo in a gray background |
Early Versions (SQL Server 2000 – 2008)
Controlling MAXDOP of executing queriesControlling MAXDOP of executing queries
byPaul Randal
Aug 11, 2011
1 Min Read
blue and silver computer mouse
Early Versions (SQL Server 2000 – 2008)
SQL Server 2005's APPLY, Part 2SQL Server 2005's APPLY, Part 2
byItzik Ben-Gan
Jul 25, 2011
1 Min Read
man typing on computer keyboard with data in the background
Early Versions (SQL Server 2000 – 2008)
SQL Server 2005's Apply, Part 1SQL Server 2005's Apply, Part 1
byItzik Ben-Gan
Jun 20, 2011
1 Min Read
colorful game pieces on a game board
Early Versions (SQL Server 2000 – 2008)
Tips for Using SQL Server Management Studio 2008Tips for Using SQL Server Management Studio 2008
byMichael Otey
Jun 10, 2011
1 Min Read
Synchronizing Disparate Data with Master Data Services
Early Versions (SQL Server 2000 – 2008)
Synchronizing Disparate Data with Master Data ServicesSynchronizing Disparate Data with Master Data Services
byDenny Cherry
Apr 25, 2011
1 Min Read
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Why can a database snapshot run out of space?
Why can a database snapshot run out of space?
Apr 9, 2011
|
1 Min Read
byPaul Randal
Simplifying Spatial Data
Early Versions (SQL Server 2000 – 2008)
Simplifying Spatial Data
Simplifying Spatial Data
Mar 15, 2011
|
1 Min Read
byKurt Survance
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Q: How can I tell how much memory SQL Server 2008 is using?
Q: How can I tell how much memory SQL Server 2008 is using?
Mar 7, 2011
|
1 Min Read
byJohn Savill
SQL Server Version Build Numbers
Early Versions (SQL Server 2000 – 2008)
SQL Server Version Build Numbers
SQL Server Version Build Numbers
Feb 28, 2011
|
1 Min Read
byMichael Otey
exploding computer keyboard
Early Versions (SQL Server 2000 – 2008)
Upgrading to SQL Server 2008 R2
Upgrading to SQL Server 2008 R2
Feb 23, 2011
|
1 Min Read
byMichael Otey
partitioning screenshot
Early Versions (SQL Server 2000 – 2008)
Investigating Partitioning Query Performance in SQL Server 2005 and SQL Server 2008
Investigating Partitioning Query Performance in SQL Server 2005 and SQL Server 2008
Dec 2, 2010
|
1 Min Read
byTim Chapman
FAQs On SQL Server 2008 R2 Parallel Data Warehouse
Early Versions (SQL Server 2000 – 2008)
FAQs On SQL Server 2008 R2 Parallel Data Warehouse
FAQs On SQL Server 2008 R2 Parallel Data Warehouse
Nov 19, 2010
|
1 Min Read
byMichael Otey
the letters sql in a glowing tech font
Early Versions (SQL Server 2000 – 2008)
Using Table-Valued Parameters to Update Multiple Rows
Using Table-Valued Parameters to Update Multiple Rows
Nov 18, 2010
|
1 Min Read
byMatthew Harris
credits cards money and padlock
Early Versions (SQL Server 2000 – 2008)
Securing Credit Card Data Through SQL Server 2008
Securing Credit Card Data Through SQL Server 2008
Nov 18, 2010
|
1 Min Read
byEdmund X. DeJesus
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Scale-out Architectures for SSRS 2008 R2
Scale-out Architectures for SSRS 2008 R2
Nov 16, 2010
|
1 Min Read
byMark Kromer
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Is SQL Server Up-Level Compatible?
Is SQL Server Up-Level Compatible?
Nov 12, 2010
|
1 Min Read
byPaul Randal
SQL Server 2008 Spatial Tools
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 Spatial Tools
SQL Server 2008 Spatial Tools
Nov 9, 2010
|
1 Min Read
byKevin Kline, SolarWinds
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Visual Studio 2005 & SQL Server 2005: Introduction
Visual Studio 2005 & SQL Server 2005: Introduction
Oct 6, 2010
|
1 Min Read
byPaul Thurrott
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
A Look at SQL Server 2008
A Look at SQL Server 2008
Oct 6, 2010
|
1 Min Read
byPaul Thurrott
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
SQL Server 7 "Sphinx" Technical Workshop Reviewed
SQL Server 7 "Sphinx" Technical Workshop Reviewed
Oct 6, 2010
|
1 Min Read
byPaul Thurrott
illustration of people mirroring concept and databases
Early Versions (SQL Server 2000 – 2008)
Database Mirroring in SQL Server 2008 R2 and SQL Server 2008
Database Mirroring in SQL Server 2008 R2 and SQL Server 2008
Sep 19, 2010
|
1 Min Read
byRichard Waymire
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Why Doesn’t SQL Server Use the RID for Lookups from a Nonclustered Index into a Clustered Table?
Why Doesn’t SQL Server Use the RID for Lookups from a Nonclustered Index into a Clustered Table?
Aug 30, 2010
|
1 Min Read
byKimberly L. Tripp
Pusher and QueryPusher Pick Up Where CMS Leaves Off
Early Versions (SQL Server 2000 – 2008)
Pusher and QueryPusher Pick Up Where CMS Leaves Off
Pusher and QueryPusher Pick Up Where CMS Leaves Off
Aug 25, 2010
|
1 Min Read
byDavid Paul Giroux
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Review: Crystal Reports 2008
Review: Crystal Reports 2008
Aug 23, 2010
|
1 Min Read
byDerek Comingore
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Kevin Kline and Brent Ozar’s Thoughts on SQL Server 2008 R2 Migration
Kevin Kline and Brent Ozar’s Thoughts on SQL Server 2008 R2 Migration
Jul 9, 2010
|
1 Min Read
byMegan Keller
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 R2 Express Installation Options
SQL Server 2008 R2 Express Installation Options
Jun 25, 2010
|
1 Min Read
byMichael Otey
star join query on SQL Server 2008
Early Versions (SQL Server 2000 – 2008)
Parallelism Enhancements in SQL Server 2008
Parallelism Enhancements in SQL Server 2008
Jun 8, 2010
|
1 Min Read
byItzik Ben-Gan
SQL Server 2008 LOB Data Types
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 LOB Data Types
SQL Server 2008 LOB Data Types
May 21, 2010
|
1 Min Read
byMichael Otey
Getting Started with Parallel Data Warehouse
Early Versions (SQL Server 2000 – 2008)
Getting Started with Parallel Data Warehouse
Getting Started with Parallel Data Warehouse
May 10, 2010
|
1 Min Read
byRich Johnson
Efficient Data Management in SQL Server 2008, Part 2
Early Versions (SQL Server 2000 – 2008)
Efficient Data Management in SQL Server 2008, Part 2
Efficient Data Management in SQL Server 2008, Part 2
Apr 26, 2010
|
1 Min Read
byDon Kiely
SQL Server 2008 R2 New Features
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 R2 New Features
SQL Server 2008 R2 New Features
Apr 23, 2010
|
1 Min Read
byMichael Otey
Microsoft Releases SQL Server 2008 R2 to Manufacturing
Early Versions (SQL Server 2000 – 2008)
Microsoft Releases SQL Server 2008 R2 to Manufacturing
Microsoft Releases SQL Server 2008 R2 to Manufacturing
Apr 21, 2010
|
1 Min Read
byBlair Greenwood
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Twitterview: Microsoft’s Donald Farmer on SQL Server 2008 R2
Twitterview: Microsoft’s Donald Farmer on SQL Server 2008 R2
Apr 21, 2010
|
1 Min Read
byBlair Greenwood
ITPro Today logo logo in a gray background | ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 R2 Hits RTM
SQL Server 2008 R2 Hits RTM
Apr 21, 2010
|
1 Min Read
byPaul Thurrott

Editor's Choice

the interface of the PowerShell search tool with a hand holding a magnifying glass on a background of a blue sky and clouds in the shape of gears
PowerShell
How I Built My Own PowerShell Multi-File Search Tool
How I Built My Own PowerShell Multi-File Search Tool

Oct 22, 2024

burnout gif featuring a mannequin surrounded by office technology on fire
Career Tips
Am I Burned Out? How To Identify and Address Burnout in IT
Am I Burned Out? How To Identify and Address Burnout in IT

Oct 24, 2024

MLOps
Ops and More
Choosing Between Cloud and On-Prem MLOps: What's Best for Your Needs?
Choosing Between Cloud and On-Prem MLOps: What's Best for Your Needs?

Oct 23, 2024

Exclusive ITPro Resources
See all ITPro Resources

Featured Technical Explainers

AI chip
Cloud Computing
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
SaaS concept on a tablet
Cloud Computing
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
DevOps logo on top of code
DevOps
DevOps: Key to Faster, More Efficient Government Software Development
DevOps: Key to Faster, More Efficient Government Software Development
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up

Recent What Is

cartoon shows a person next to a checklist and several icons that represent disaster scenarios
Disaster Recovery
BCDR Basics: A Quick Reference Guide for Business Continuity & Disaster RecoveryBCDR Basics: A Quick Reference Guide for IT Pros
technology interface with a person's hand drawing gears and cogs
PowerShell
Introduction To PowerShell Environment VariablesIntroduction To PowerShell Environment Variables
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up