I've rolled out a refactor of our wind tunnel metrics database system, which was partitioned tables with row compression and is now partitioned views across separate databases with page compression....

Great article - we've used MERGE for some time and it reduces the CRUD burden considerably.

However, it should not be used if you are using transaction replication. We've found (and...

chapman.tim (10/1/2010)

---

Solomon is correct. Partitioning is NOT intended to increase query performance, it is intended to increase data manageability and administration. SQL 2008 did some things to make...

You can achieve a similar result using Standard and views should your budget not stretch to Enterprise. Really it's horses for courses, if you databases are large enough to warrant...

Great article - glad you mentioned that horizontal partitioning is only available in the enterprise version.

However, I think it is worth mentioning that vertical partitioning is available in all flavours...

Alejandro,

I agree. The biggest problem with deep unit testing SPs is testing the results - it's not good enough to just check the output from the SP, you have to...

I'm not sure if this is really unit testing - it's more system testing. My understanding of unit testing is that you are looking at a specific routine (or maybe...

I agree - I am reluctant to have a mixture of versions. However, this affects alot of different systems as the distributor is central to them all. It's not easy...

I have found a possible reason for this. Merge replication uses triggers on the tables that are in the publication at both the publisher and the subscribers. These triggers are...

I've used application roles in the past to allow users read only access via their login (actually I use AD groups so only need to create them once) for reporting...

I know this is an old post but it caught my eye as this is exactly what I'm testing.

In SQL2005 you can insert a token at any time via replication...

Unfortunately I've changed contract since this posting so can't check what the settings are now on the database. From what I recall I turned off all the replication of objects...

Turning off the auto-statistics on the destination database worked for me, and performance is fine for my needs. So not pursued this any further.

I've no problem writing the SQL from scratch, however the requirement for this is to replace a maths engine that a user edits. So the user enters statements that I can...

Thanks for that - I'd already considered it but it would restrict the current usage and there are maths statements that it would not work for. I've over-simplified the example...