http://lmgtfy.com/?q=%22SQL+Server+2005%22+%22New+Features%22

There is nothing built into SQL Server 2000 that will answer that question automatically. The reason Paul asked for the version is because 2008 has a process called Change Data...

I agree with Steve. Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on the system. You should...

It really depends on the needs of the system and, which school of thought you subscribe to. I'm not a fan of using natural keys as the primary key of...

That's a completely circular reference. While you can set those up, they're impossible to maintain.

The main problem is, your set based solution is using that UDF instead of straight SQL. That's causing performance issues.

Have you run DBCC CHECKDB on this database?

I'd suggest getting a copy of the book "Microsoft SQL Server 2008 Internals" by Kalen Delaney. This is a huge topic, as was already noted, and just can't possibly be...

Just adding another thought...

Most app developers that need to support multiple platforms are taking advantage of ORM tools like Hibernate, nHibernate, LINQ, Entity Framework, etc., to perform the work for...

I'm with Paul, obviously it would be better to have multiple machines, but if you can't, multiple instances will at least simulate the results. This way you avoid the issue...

Even though both operators have the word SCAN in them, there is no real comparison between a Constant Scan and an Index/Cluster/Table Scan.

Usually, but not always, an Index/Cluster/Table Scan is...

It really depends on the situation, but for most of us, no, this is a waste of time & effort. I've been working for a company for almost nine years....

The best way to deal with sudden issues on the database is to prepare beforehand. Know how to look for contention. Know how to look at the processses that are...

I've honestly never tried it that way, so I'm not sure where to go. If you know which procedure is giving your problems, I just work with it on my...

Traditionally it's considered bad form to hijack someone elses question. Also, when you do this, the only people that are aware of the new question are those that are already...