There are two great articles by MVP Jeff Moden on this site that show you exactly how to do what you need:

Cross Tabs and Pivots, Part 1 – Converting Rows...

Lowell (6/1/2010)

---

Paul thank you for a great example; I did not know you could transform a BULK INSERT with the OPENROWSET and XML; this is a great example I added...

It is quite dense in places, and there's a decent high-level summary here:

Execution Plan Caching and Reuse

(It contains a link to the document I pointed you at before, for those...

I agree. SQL Server 2008 R2 is just a point release, not worth a new forum.

As you probably suspect, it is down to the different rules applied for word-breaking and stemming depending on the language selected.

The new Neutral word-breaker happens to search for numbers in...

Microsoft Best Practices Article: Waits and Queues (Word Document)

Hey BrainDonor,

I sympathise...it is complex, but at least logical.

There is a full (and logical) explanation in one of my favourite references:

Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server...

In case you want to create an XML format file, or are using a later version than 2000, please see these Books Online links:

Creating a Format File

Importing and Exporting Bulk...

You are not the first person to want to record volume free space. There are a number of articles and scripts on this site:

http://www.sqlservercentral.com/search/?q=free+space&t=a&t=s

There are also better ways to...

There is a problem with using CASE in an ORDER BY expression: SQL Server will not be able to make use of an index to order the rows (you'll always...

da-zero (6/1/2010)

---

If you use a "logical" surrogate key in the fact table, for example 20100601, you can still have the time table AND fast searching and simple SQL queries against...

Ha! Easy for anyone who reads your excellent blog 🙂

Great question.

A very good question. I had to take a guess at whether SQL Server would continue the downward sequence correctly after the IDENTITY_INSERT operation. The correct behaviour is...

Couple of points to add:

1. Many people think that parallelism is not possible with table variables. This is not so. It is true that the lack of statistics...

I used the sample table and data from your earlier post :unsure: