Star Schema is a reporting structure for data where you have fact data (invoice details for example) in a main table that is key-referenced to one or more dimension tables...

Sounds like a good opportunity for a small datamart for reporting! If you denormalized or perhaps star-schema'd this data it would likely report much more quickly.

Clearly you cannot rely on some monitoring product telling you your memory is being inappropriately used since the threshold could be set to any number.

pages/sec is a simeple and effective...

With proper monitoring you should be able to KNOW if you are having memory pressure. Things like pages/sec, dbcc memstatus, various DMVs can inform you about this. ...

GilaMonster (10/12/2007)

---

In my experience it has the most impact when the aggregated columns are also in the index.

CREATE TABLE Payments (

PaymentKey INT IDENTITY PRIMARY KEY,

CustomerID int,

InvoiceID int,

PaymentDate datetime,

Amount Numeric(17,5)

)

Assume...

Yeah - thanks Paul. I actually had it in my head to add a note that truncate_only was going to be deprecated but got distracted by a darn work...

As you mention, SIMPLE recovery mode would eliminate the issue with tlog growth (unless you get a runnaway DML spid). A sql job that regularly (once per week?) runs...

Doing a full backup will NOT allow log file to shrink. You must in some way backup the log to allow space reuse. This is a VERY common...

All I can say is that it is REALLY scary that a company has an untrained/inexperienced DBA managing critical infrastructure!! I have been doing this for 15 years now...

I strongly advise clients to stay away from the Database Tuning Advisor. I know some have had some success with it, but I have seen it absolutely destroy database...

That is for used box. .NET stuff is freely downloadable/installable/distributable from download.microsoft.com. Best of luck with your endeavour!

<$200 is my guess for a machine to serve that data. 🙂 1 cpu or perhaps 2, 2GB RAM, 1 drive. Note that that doesn't get you...

I would decide first what your budget is. Then hit eBay or some other used-equipment seller and get what you can for your budget. A LOT depends on...

I would go with at LEAST 30GB for OS partition - perhaps 40. Seems like EVERYTHING these days puts crap in the os part - especially the installer directory....

I would recommend you look at the new Vostro 1700 model. I am LOVING mine - Core 2 Duo CPU, 2 hard drives, 4GB RAM and an awesome monitor!