THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Showing page 5 of 7 (62 total posts)
  • SQL 2008 Data Compression - Linchi Shea

    Last night at the NYC SQL Server Users Group meeting Linchi Shea presented a session on Data Compression (not Backup Compression) in SQL Server 2008. By understanding how the compression algorithm works, and tuning your clustered indexes based on that understanding, you can achieve some pretty incredible space savings on disk, and performance ...
    Posted to Allen White (Weblog) by AllenMWhite on September 26, 2008
  • Geek City: Too Many Columns!

    As I am working on my new SQL Server 2008 internals book, I am finding many test situations in which I need to create a table with LOTS of columns. First of all, you're probably aware of the new SPARSE column feature that allows you to have up to 30,000 columns in a table!  I did some testing with sparse columns, but just today I realized I ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 20, 2008
  • Did You Know? It's Official...I'm a Geek!

    I almost didn't respond to the request for an interview with Richard Morris of Simple Talk. There were a few strange things in the request that made me think it might be spam or phishing. But I asked some trusted colleagues, and found out it was for real, and you can read the result ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 16, 2008
  • Introduction to the New Data Types in SQL 2008

    We are pleased to invite you to the September 11th 2008 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below: Microsoft Corporation 6050 Oak Tree Blvd. Suite 300 Cleveland, OH 44131 Agenda: 5:00 - ...
    Posted to Allen White (Weblog) by AllenMWhite on September 9, 2008
  • SQL 2008 ConfigurationFile.ini file - not just for unattended installs

    Scripting installations of SQL Server 2008 is much easier than it is with SQL Server 2005 because of the ConfigurationFile.ini. Even if you don't script your installations, you should review the contents of this file to verify that the installation transpired as intended. Although it is possible to script a SQL Server 2005 installation, you can't ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on August 15, 2008
  • Oh, What a Tangled Web

    At Tech Ed 2008 I made a mental note when Paul Randal mentioned that you can't use Database Mirroring when you've got the Filestream feature turned on. I like Database Mirroring and so that was useful information. In preparing a bunch of demos for SQL Server 2008, I'm using the AdventureWorks2008 database currently available on the Codeplex ...
    Posted to Allen White (Weblog) by AllenMWhite on July 31, 2008
  • Partition Wizard Makes it Simple

    The partitioned table was one of the great new features of SQL Server 2005. We could now manage data based on some range data, usually a date value, and keep the different ranges in separate physical files, and use rolling range scripts to move old data out of the table and create new partitions for new data and incorporate those new ranges into ...
    Posted to Allen White (Weblog) by AllenMWhite on July 28, 2008
  • Installing SQL Server 2008 RC0

    Introduction SQL Server 2008 RC0 has been out for a while. You can download it here. This post is not a detailed examination of the setup options. There are much better articles and posts out there if you want more information. This post represents one way to get SQL Server 2008 RC0 up and running so you can start learning the new ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 14, 2008
  • SQL Saturday 6 - Cleveland August 9

    Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia). Then, my last week as a DBA at Advanstar, followed by my first week as a Trainer for ...
    Posted to Allen White (Weblog) by AllenMWhite on June 27, 2008
  • Policy Based Management Evaluation Modes

    Dan Jones wrote a great post about Facets from the new Policy-Based Management feature of SQL Server 2008. At one point in the post, he listed all of the available facets and their supported evaluation modes. Since SQL Server 2008 is not RTM, and since facets can be added in the future, I thought I'd write a query that would list the facets and ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on June 16, 2008
Privacy Statement