I've tried three times now to write this, so this will just have to do - this was an irritating thread to read. We're here to share knowledge and solve...

Nice pragmatic approach, I agree with it entirely!

You can also just look for bad & missing items. Make sure every table as a primary key, a clustered key, that you have no duplicate indexes, and that any...

Im not sure what to call that other than bad.

Biggest reason I've seen companies do stuff even close to that is that the developers dont do a good job...

My two cents; encrypting the wire should be a network guy thing, not a SQL guy thing. IPSEC or firewall client of your choice are better and broader solutions.

Either way you have to move some data. SQL 2005 partitioning features require the table to be empty, has to be created on a partition scheme instead of a filegroup....

Its the downside of NT authentication; you're granting access to the user rather than the app. The technique mentioned above will work, but certainly doesnt stop them and its easy...

I've seen discrepancies as well, though I dont think that extreme. I use QA/SSMS to view the plans, Profiler to measure performance. With two monitors it works well and I...

On the constraints, as a simple if not great example imagine that you have a really large customer table that you want to partition on last name. We'll create two...

Cool that you posted the follow up!

I pretty much agree with Jeff's reply. Partitioning is definitely a valid technique using a view to pull it all back together. From a performance perspective the one thing I...

I imagine LS would have to implement it natively and I have no idea if they have - maybe someone else can comment.

Agreed, only data changes are transmitted to subscribers. One of the nice benefits of this is that you can set up different indexes on each subscriber if needed, dont have...

Steve's on vacation, will be back next Mon - but didnt you say something that if it ain't....

If you dont have the col probably not a bad idea to just back up and try again, delete and rebuild the pub.