The file formats are the same, so you can do this. However if you have features that you are using in the primary that aren't supported on the secondary, some...

I tend to agree with Gail's approach. Don't update everything if you don't need to.

There's a counter to keep track of # of rows changed. Lowell's script seems to make...

I haven't really seen any issues reported with SP3. The new system seems to be working well. I expect an SP4 before too much longer.

I think I'm winning, but my back and knee might disagree.

I'll blog the whole thing later. It's a good project, and easy to do if you don't mind a little...

Lost thur to errands and my wife's truck tires, but I need to cut 6 small trim pieces for the edges along the wall and then glue about 12 tiles...

Michael has a good point. A basic SQL setup ought to be like the car. Which means that on setup for the incidental DBA, there either should be some notes,...

It varies by version, but first, you need to clear the log out.

The basic steps are to clear the log of active transactions, then shrink it, and then set...

Are they completely duplicate? All fields? Be sure you keep the one you want if there are differences. Mark's solution should work, but it's not checking which row might get...

agreed.

I'm not sure we pay too much. There is some competition, and there's certainly demand. I wonder how things would work if we could al la carte things.

I'll tell...

I'd ask how much data changes? And how often? You could use transactional replication, either on a schedule or continuous, to move data across. That would avoid the downtime with...

Thinking like a CIO/CEO/or manager should change your job. Think about their point of view, their needs, etc. and it will help you. You don't have to agree with them,...

Why 3 tables? Isn't market in the Market_Product table? Can't you join those 2 tables?

I miss anything? Just cranky old guys and gals complaining?

The post is a little self promotion, but I'm more willing to tolerate authors promoting themselves than companies. Might be a...

sys.objects will contain the name of the index or table, but not the details. If you want more information about those, sys.indexes, or sys.columns will help. There are lots of...