I'm not sure it's elegant since you'll end up confusing people that look at the design.

Multiple tables, like Product, ProductDetail, ProductStatus, would form a sub-model I've used that approach as...

Sorry, you'll have to live with real technical content in addition to all the complaints, vents, rants, and recommendations.

Besides, if I have to see Lynn's soccer talk here, you'll have...

Use the SET commands. STATISTICS IO ON, compare reads/writes.

you could use Trace/Profiler as well.

Less reads, CPU might be the way to go.

I'm pretty open here, and I question a company hard. The first thing I want to do is meet the team(s) I will work with. That can be the developers,...

An MDB is an Access file. If it's an mdf/ndf/ldf, those are SQL Server files.

I think the rule was you leave about 1GB for the OS, unless you are on x32, going above 6GB of RAM. Somewhere around 6-8GB, I heard you are using...

I think that it's hard to generalize in many areas. A system administrator, or MCSE, is often assumed to know Exchange as well as he does Windows. Or be an...

That's a good point, Ian, but that depends on how the values are pulled out. The application might constrain the domain of items that are used.

If there need to be...

It will release memory to the OS if there is pressure, albeit slowly.

If you want SQL to use less, set a max limit that's lower. Otherwise, ignore it. SQL is...

One thing I'd be concerned about is an app pointed at the wrong server. Are the db names the same as production?

I''m sure your trace will show something.

The thing I think is that does "locked" matter if it's a product or customer?

In my example, I'd still have the status table. I typically have had ID, name, and...

It's got to be network or I/O limiting your ability to catch up. You mentioned a backup, is this part of nightly maintenance? Any chance that indexing was going on?...

I'd use SteveB's suggestion. Add a T-SQL task, calculate a date, branch based on the result.

Maintenance cleanup task for the files

History Cleanup for the log files (text)

Add it to your maintenance plan and point it to the folder.

The diff changes the LSN, so I'd expect this to work. The Diff would pick up all changes done in simple mode and then you could resume log backups.

I think...