That will be fine then. You can use the technique in the article to gradually delete records in situ, or to copy rows...

Peter Brinkhaus (3/20/2010)

---

Hierarchyid was a new data type in SQL 2008. You posted your question in a SQL 2008 forum, so you got a SQL 2008 solution from Paul. Post...

Peter Trast (3/20/2010)

---

Maybe if the data were not previously PARTITIONED, yes, but an assumption not in the question. The clustered index existed before as stated in the question so...

See http://blogs.msdn.com/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx

Lock pages in memory is working!

Using dynamic lock allocation. Initial allocation of...

Nah, it...

The Dixie Flatline (3/20/2010)

---

The bit about COLLATEs is new to me. I'll have to test it out. Where did you pick up that bit of...

No. You need Standard at least, Enterprise for serious use. See http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx#highavail and http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

Workgroup can only act as a Witness.

I have always used ftp for this, and it has always been very simple. Then again, I have always had a team of network guys that make that sort...

Recursive CTEs are sooooo yesterday. Everything involves hierarchyid today 😀

Thanks, that is tidier. I would probably replace those UNIONs with UNION ALLs though. Oh, and it isn't important with such a small number of REPLACEs, but those...

Peter Trast (3/20/2010)

---

"Dropping and rebuilding a clustered index on a partition scheme may move data to other drives. " ?

Really? How can that be? The idea of the partition is...

Small point: sp_attach_db is deprecated and will be removed in a future version. Use CREATE DATABASE...FOR ATTACH instead.

There is a good SSC article on this topic by MVP ...

I am sure the cursor will be just fine here (though it would have been nice to see a non-default cursor!)

Anyway, not looking to start that debate, here is a...

Unless it is needed 😉

Failover partners spring to mind.

This site is pretty good:

http://www.connectionstrings.com/sql-server-2005

...as is Books Online of course.

You mean one processor license per socket.

"For example, if you are using SQL Server Enterprise Edition on a four-processor server with quad-core...