mendesm (10/5/2011)

---

I still have not found convincing arguments as to why anyone would run a sql server in a way that swap/page file use would be of any benefit, and...

My understanding is that moving to a page file when no more memory is available is only 1 of the uses for a page file. Nevertheless, if you are not...

GilaMonster (10/5/2011)

---

Because it's not really necessary on a dedicated SQL box. I usually create one of a couple GB, no more. Just enough for a kernel...

Umm... Why not? 🙂

Jared

Swap file. Is it on the OS partition, or does it have its own partition?

Jared

Is your page file on a separate partition?

Thanks,

Jared

Well... To be honest I think that would be overkill. I mean, it would be nice server! But you should think about ROI. We do a much larger...

That really depends on your usage. I would typically go with RAM at this point, especially if this is strictly dedicated database server. My first 2 things are RAM...

Of course you can do it from 1 server to another! That is the main point! 🙂 Set up your second server as a linked server. I suggest Transactional replication...

Sean Lange (10/5/2011)

---

sql sees any string as equal regardless of the number of spaces. in other words '' = ' ...

It may help to right-click on the table -> Script Table As -> Update To -> New query editor window.

At least this will generate all of the text you need.

Thanks,

Jared

I'm not sure what is wrong with the customer using sa. Microsoft does this when setting up Great Plains, BigFix does this for its database... This is usually because...

Ok, I just did some testing. I believe that the login you are using to attach/restore the database was never given access to the original database 🙂

Attach/restore the file somewhere.

Login...

See below...

Thanks,

Jared

See below...

Thanks,

Jared