Microsoft Hosting Solutions Built to Your Needs
Sponsored Link
Rackspace is the expert when it comes to delivering hosting solutions. From building out Windows servers and highly complex configurations to managing and supporting network environments, mail solutions, storage, data backups and far more. We are here for you 24x7x365.
Learn How to Maximize SharePoint - In-Person Training – 8 Cities
Attend this SharePoint event to for best practices and tips regarding infrastructure, design, redundancy, site administration, and ECM. Register today to take advantage of Early Bird special pricing for only $99 – Extended Until September 15th!
Demystifying SQL Server Virtualization
Michael Otey dispels some myths surrounding SQL Server virtualization, including the notion that all virtualization platforms are created equal. He explains the high-level differences between the hosted, hypervisor, and virtualized OS platforms.
Discover the Benefits of Filtered Indexes and Statistics
Learn how you can take advantage of SQL Server 2008’s filtered indexes and statistics feature to improve query performance and obtain detailed and accurate distribution statistics.
T-SQL Enhancements in SQL Server 2008, Part 2
SQL Server 2008 powers up T-SQL with new features such as the GROUPING SETS operator and table-valued parameters.
Migrating to SQL Server 2008
Now that Microsoft supports direct migration from SQL Server 2000 to SQL Server 2008, you must decide: Should I migrate from SQL Server 2000 to SQL Server 2005, or should I migrate directly to SQL Server 2008?
SQL Server 2008’s HierarchyID, Part 2
Use the new HIERARCHYID data type to move a subtree from one parent location in the hierarchy to another, and to convert a parent-child representation of the hierarchy to a representation that uses the HIERARCHYID data type.
T-SQL Enhancements in SQL Server 2008
Tour SQL Server 2008’s extended T-SQL feature set and learn how the new statements DECLARE, MERGE, and INSERT can make a DBA’s job easier.
SQL Server Compact Edition FAQs
SQL Server Compact Edition 3.5 is Microsoft’s smallest full relational database—check out these FAQs to learn more.
Virtualizing SQL Server with VMware or Hyper-V
Tests of server virtualization products VMware ESX Server 3.5 and Windows Server 2008 Hyper-V, plus SQL Server running four virtual machines (VMs) indicate that SQL Server running in a VM is ready to handle production workloads.
BlogsGo to the Blogs Index Page
In a Nutshell
Counting Context Switches, PerfMon Counters, And Other Miscellaneous Notes
Comment on the blogRead this blog
Puzzled by T-SQL
T-SQL Sorting Challenge
Itzik provides a T-SQL challenge involving sorting separated lists of values.
2 CommentsRead this blogPuzzled by T-SQL
SQL Server 2008 RTM MERGE Bug and Fix
Itzik describes a bug involving the MERGE statement in SQL Server 2008 RTM, and provides a pointer to the bug fix.
Comment on the blogRead this blogIn a Nutshell
SQL Server Memory Tracking with Windows Task Manager
Kevin describes a possible problem scenario when monitoring SQL Server memory using Windows Task Manager.
Comment on the blogRead this blogSubscribeLearn More Here
![]() |
September 2008Implementing Microsoft's BI Platform Subscribe Renew Current Issue Archive Monthly Online Pass & Digital issue Master CD |
WhitepapersGo to the Whitepapers Index Page
Download Microsoft SQL Server whitepapers from top vendors and research firms. .
SQL Job Openings
Instant Poll
What type of SQL Server news do you look for on the Internet?
DownloadsGo to the Downloads Index Page
13 Things You Need to Know About SQL Server 2005
Learn what's in SQL Server 2005 and what's out.The Argent Guardian easily beats out MOM in all our tests
OS: Microsoft Windows 200x and UNIX Company: Argent ®
More Downloads Here




