ssb (5/22/2009)

---

Thanks for the reply Michael.

So I will use separate accounts for each of the services across each of the servers. Just out of curiosity besides what you mentioned...

Use a different account as the service account for each SQL Server.

If you use the same account on more than one server, it becomes almost impossible to change the account...

Float stores the data as binary numbers, and this causes problems in applications where there needs to be an exact base 10 representation. Many base 10 fractions have no...

Grant Fritchey (5/22/2009)

---

Really? I'm sorry if I put out bad info. Maybe it's a setting during the install because we've been dealing with file systems seperate from the data store...

I just hate seeing NOLOCK put out there as the bad practice of first resort for solving concurrency problems, especially before trying SNAPSHOT isolation.

Grant Fritchey (5/21/2009)

---

Actually the files themselves in Sharepoint are stored on the file system. The meta data about the files is stored in Sharepoint. Restores of a Sharepoint system can...

Tim Walker (5/20/2009)

---

You didn't post your database size. But here are my comments.

Michael...

I don't know many details of how the application was built, but we recently implemented a custom built application containing about 500,000 document images using Sharepoint to hold the image...

You would probably better off posting you question on a web site that is devoted to math, not SQL, to find an algorithm that can be used to solve the...

Are you running Windows Enterprise Edition so that SQL Server can use more than 4 GB of memory?

Not sure how this a a SQL Server question, but...

How about just getting some boxes and bottles of those sizes, and seeing how many of each type of bottle you...

So would this be a strong 15 character password?

My1stPassword!!

Ten Windows Password Myths

http://www.securityfocus.com/infocus/1554

Tim Walker (5/19/2009)

---

Thanks for the feedback.

Michael, you've clearly put a lot of effort into password generation but it comes to close to 'I can't remember it without post it...

Configure log shipping for a Sharepoint database the same way you would configure log shipping for any other database.