I'm guessing that there is some type of third party tool that kicked off a trace.

You can use any method, just set a peak size and leave it at that.

For databases in full or bulk logged modes, you need to run log backups. That is the only way to backup the log records and reuse the space.

The log size...

We are looking to do more with HTML 5 in the future, which might help as well.

Brandie Tarvin (8/10/2011)

---

Help me bug Microsoft about a minor issue that is driving me sane.

https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

This one is giving me heartburn. I almost ran something in Production that was supposed to...

It's possible, but I doubt we would spend much time on this. Ultimately we don't expect you do use the code from the iPhone since a cut/paste doesn't make a...

I have updated and corrected the script and included a create database statement. This does show fragmentation of .39% and 90+% if you run this in a newly created database...

SanDroid (8/10/2011)

---

SanDroid (8/10/2011)

---

The catgory was Administration and...

jay holovacs (8/10/2011)

---

I'm going to go a way off the rails into heresy, but this is human nature and should not come as a surprise.

Social animals (and humans are the...

Good point, but not trying to address the whole problem. Designing security...

That should be correct.

Grant is correct, you aren't giving enough information. Is there monitoring on the new server for backups? If so, how does that work? Perhaps they are the same.

It doesn't have...

Set the min low, maybe 1024MB (1GB) and then go from there. The max is usually more important.

If this is x86, 32 bit (and I think it is), then you...

Excellent question, Ron. I've used this type of demo in presentations before.

It looks like you have 8GB of RAM in the server and have the min for SQL Server set to 7GB?

I wouldn't set the minimum at all. Leave it...