I'm curious to know if anyone has done an analysis on the impact of CHECKSUM on insert/update/delete performance. There must be some tangible penalty. In the 2000 days,...

Great article. I'd like to see more about how query performance was affected. Also, when backing up a compressed table to a compressed backup, is that faster than...

I must give credit to

1) Microsoft for 1/2 the answer (:)

http://www.microsoft.com/technet/technetmag/issues/2007/03/Partitioning/default.aspx

and

2) Sarah Henwood at

http://sqlblog.com/blogs/sarah_henwood/default.aspx

My quest to migrate data in one partition to another Filegroup...

I currently have all partitions and this PK index residing on the PRIMARY filegroup.

I should specify what I'm trying to accomplish, I suppose. I'm trying to figure out how...

I'm receiving the same error message, but it's complaining in reverse that my table isn't partitioned, although it plainly is!

Warning: The specified partition 1 for the table myDb.dbo.myTable' was ignored...

Though I understand the concepts (which were presented eloquently), I would like to know more about how the table is actually used to dynamically recreate the partitions. Given the...

Where is XML Notepad?  How does one launch it?  Must I have Office 2007?

Yes and no.  In SQL 2005, a user can own multiple schemata.  In Oracle, a user can only own one schema.

For example, in SQL 2005, user "x" can own schema...

Well intended, but remember we're...we're not supposed to query those good old sys tables anymore (sysfiles)!  There's another sys. view that replaced that, but I'll have to find that and...

Excellent!  I look forward to seeing that.

I'm assuming that this comparison was done based on MS SQL 2000.  I'd like to know what your opinion is regarding SQL 2005 and any changes that you might make...

If you're interested in only backing up the Procs (and/or functions) I'd recommend generating a script and putting that file aside.  The full backup of the DB will certainly work,...

Let me put it this way.  I was a DBA on both for close to 6 years in a large investment company, and I can tell you this.  I was able to...

Nice article and I agree that MS should KISS.  That's what I find to be so great about it.  It is simple where you need it to be (like SQL tuning...it...

Analysis on which table/indexes should be separated has not yet been done.  Latch contention is high since this is a highly concurrent application (hundreds of concurrent queries).  Multiple datafiles should...