People of all skill levels visit this site. So, an easy question for one person might not be for some others. That one was easy for me but what about...

Lowell,

Thanks for your reply. What did you name your Profiles? Do you have a naming scheme for them? And do you know anything about question 6?

Wow...you must of been looking for something particular to go back so far for a thread 🙂

Thanks for the response though! 🙂

I have been looking at documentation like you suggested. One such document suggests using different accounts for the SQL services. How many different services are created if everything was installed...

Thanks for the detailed responses. From what I have read over at http://msdn.microsoft.com/en-us/library/ms188917.aspx , and your responses, I was going to go with the WHERE index_level = 0...

According to the link, users are not allowed in the database during the bulk-logged time. I am trying to do a rebuild/reorg online. Is there a way to control the...

GilaMonster (12/7/2009)

---

A rough rule-of-thumb, given by a former program manager of the storage engine is around 1000...

CirquedeSQLeil (12/7/2009)

---

Something that would be helpful in answering this would be to know page counts for your tables. It would also be helpful to see what kinds of indexes...

All excellent points. Thanks.

I don't have a clue why I started at 40. I am just that absent-minded I guess 🙂

I didn't have the reindex or backup in there because...

Currently the database is at 67 GB. I need it around 25 GB. Would the following be an exact example of what you are saying? T-SQL correct?

-- STEP 1-----------------------------------------------------------------------

USE MedReconNet

GO

ALTER...

Not that I have found. 🙁

MarkusB (1/14/2009)

---

Did you try to unregister...

Nicholas Cain (1/14/2009)

---

Anyone who says buggured up automatically get's my attention.

Curious as to whether there are any pointers in the event logs, or the SQL logs that might indicate some...

I set both services to be run by local. Logging into EM is the problem. That is what causes it to crash. So I can't change anything in there. I...

Sigh...Sometimes I wonder how I get by in the world. I saw that option and I guess my brain just filed it away in the "I'm a idiot file". So,...

First off, let me thank you guys for your responses!

It is supposed to be a temporary solution. The sys admins have already gobbled up more space than they originally...