Another confirmation, multiple log files do not provide any benefits.

For multiple data files, you get benefits only if you can separate out the reads and writes of heavy objects to...

I tend to agree with Jeff, but you can add a TicketDate with a datetime value, and if needed, you can display a combination of your Year, Department ID, and...

Kiara (6/18/2011)

---

Steve Jones - SSC Editor (6/17/2011)

---

Cross your fingers, everyone. Horse vet called, ugly cut on the rear hind of a horse. I think it can be stitched, but you...

The server name is your machine name.

For express, it's often machinename\SQLExpress. You should be able to scan for them.

Cross your fingers, everyone. Horse vet called, ugly cut on the rear hind of a horse. I think it can be stitched, but you never know.

That one made me laugh. Hadn't seen it before.

I believe the before data is included in the log record. Everything needed for roll forward / roll back is in the log, so it must either be a linked...

We don't have categories per se, but rather tags. Since a question can be in multiple tags, this is a little hard to show.

We could do the rank in a...

Install SQL Server, ignore the warnings, and then install SP1.

GilaMonster (6/17/2011)

---

Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get unchallenged stupid...

Agreed, nice post and thanks

checkpoints flush log records to disk, both committed and uncommitted. When the database recovers (in restore or on restart), the redo/undo actions either mark the data files with the changes...

George,

I used to give Devs only the same access as the application in development. That was mainly because I'd end up with tables like this

Create Table Customer

( CustomerID varchar(100)

...

You need to mock up a little more DDL. It's still not clear what you're intending.

CDC isn't necessarily what you would use. CDC is for detecting changes, but in general...

Management Studio Express: http://msdn.microsoft.com/en-us/library/ms365247.aspx