Not bad. In my case we're more concerned with reporting than DR. I've raised the issue and a cluster aint in the forecast! As far as if the main server...

Sure, if you can afford to do it, why not? Assuming you don't have luxury of two spare boxes and you have the requirement to be within 5-10 minutes of...

If you'd like to put together an article we'd be happy to post as long as it fits our standards (good quality, easy to read, etc). Forward it to any...

Greg,

What would you do if you needed near real time querying ability on the standy server - say data to within 10-15 mins of live?

Andy

No reason to use a cursor, this can be done as a set based operation. Maybe something like this:

select t.*, c.* from information_schema.tables t inner join information_schema.columns c on t.table_name=c.table_name

Using...

I gotta ask - why would you do this??

Couple things wrong. Your insert is incomplete and you don't need to use xp_cmdshell, just another exec.

Andy

You can do this with transactional - take a look at the immediately updating subscribers option (and maybe even the queued updates option). Immediately updating basically puts triggers on all...

Then why would OS memory matter? If you're just running queries, you need to look at what kind of load you're putting on the server and why. I'd suggest looking...

Not sure what to suggest besides moving to network cards. You have connectiviity for sure - you can ping both ways once you connect initially?

Andy

Simplify. I'd suggest importing the file to a working table, tagging ID's that already exist, appending the rest. Then you can email the 'bad' ones to yourself, assign new ids,...

I wouldnt worry about reserving for the OS, SQL will give back memory if the OS needs it. As long as SQL is the only thing on the box, let...

I dont think you want to use -1, I think(someone confirm?) that SQL reserves -1 through -15 for its own use. Nothing quite like on error goto. Basically you have...

Well, the default is to create a database the same size as the model, which may have some extra space to start with. The "why" is that to allocate more...

If you wouldnt mind, how about posting the script? Probably someone else may find use for it now that we're discussing it!

Andy

Interesting. I always turn auto shrink off, probably explains why I've never seen this one:-)

Andy