Server and DB specs? How's that working out? Want to write about it...

Brandie Tarvin (1/11/2013)

---

Lynn Pettis (1/10/2013)

---

Just got an email from a newbie here on the forums. He had his account deleted. He felt he was on the wrong forums...

David.Poole (1/11/2013)

---

Given that audit logs are not read frequently I feel we need to consider where the appropriate place is to store audit logs.

Clearly they need to be secure so...

AD isn't that big a deal, and most of these technologies will require some parts of it since you are trying to move information around. For a relatively low volume...

Grant Fritchey (1/11/2013)

---

After seeing Lynn's comments about SQL Server Performance, I read through... well, attempted to read through a couple of articles over there. I have to ask, who is...

Lynn Pettis (1/10/2013)

---

Just got an email from a newbie here on the forums. He had his account deleted. He felt he was on the wrong forums thanks to...

You should examine why you might be having a slow insert.

- Is the log growing now? If so, since you have to zero out the file before data can...

I'd have to dig in, but I believe that the FTS index is a system table, and you can find out the number of times a word appears in a...

To follow on from Anthony, SQL Server 2008 R2 and SQL Server 2008 are not the same version of SQL Server.

SQL Server 2008: 10.0.xxxx

SQL Server 2008 R2: 10.5.xxx

The naming is...

Already answered above, but I agree with Jeff and Grant.

database mirroring is probably the simplest way to do this. You might read up on it and see if that meets your needs.

Concur. I've almost always used the dbo schema for most applications.

Is this SQL 2000 or 2008? You mention both in your post, so it's not clear.

If you are refreshing one table, you're going to generate transaction log entries. There's no...

I'd agree with Gus. a workload from your current server is a great way to benchmark.

Yes, you can run this.

It will not calculate checksums on all your pages or impact your load. What will happen is as pages are written back to disk for whatever...