Lowell (4/29/2010)

---

Steve can you put out some numbers for perspective? SSC has a lot of users and traffic, compared to many of us small biz guys we usually deal with;...

Lots of DBs cause backups to fail? With what error?

How were you doing those backups? Maintenance plan?

Grant Fritchey (4/29/2010)

---

But... almost forgot this, part of why you use monotonically increasing values as clustered keys so often (or identities defaulted to the primary key) is because inserts always...

No. Not 512 TB. 524,272 TB. 524 PB (petabytes)

2 year old thread.

Rows are not necessarily sorted within a page, but there's a slot index that defines the order that they should be in. The pages however are not necessarily stored in...

Cold backups (when the service is stopped) are not recommended for SQL Server. Take database backups (BACKUP DATABASE) and copy those to tape/offsite storage.

Are you sure it's TB, not GB? A log file cannot be bigger than 2TB.

Depends on the company. It's not something that has a precise, universal definition.

Get a professional in. There are going to be very few people with experience in databases over a few TB and an 800TB has to be one of the biggest...

Since you're using SQL 2008, have you looked at Change data capture or Change tracking? Other than those, triggers on the tables you're interested in or SQL trace.

The transaction log...

Have you checked out the MS list of skills measured?

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448&locale=en-us

Oh, and the query... This is one way, it may be a little slow if there's lots of data. Idea is to get all possible combinations of member and quiz,...

I would recommend that you write the SQL to get a standard resultset and do the pivoting for display in the front end.

So your SQL query, for the example results,...

How many rows does the query return? How long does it currently run? How many rows are in the tables?