Rack,

If you need a SQL 2000 solution you should post in SQL 2000 forum. Many posters, like myself, will base our answers on the forum we are in.

Here you...

Never having had the pleasure of working with Oracle, could explain what PERCENTILE_CONT does? Then even a neophyte like myself might be able to help.

I've been working with SQL Server since 1999 and know next to nothing about clustering as I've never worked on a database large enough or really, critical enough to warrant...

You first should attempt to determine what size your TX Log should be. The typically recommended starting point is 20% of the database size. It may be you...

Yes the developer is right.

A 45.6GB log file shouldn't need to grow if you are doing regular log file backups. I'd even venture to say that you could reduce...

Under SQL Server Agent Properties -> History you can specify how much history you want to keep for job execution. By default it is 1000 total rows with 100...

Here is my list in order of importance (my opinion only of course):

1. Backup and Restore. If you can't get the data back after a problem you aren't...

I know in December I prefer the...

J (8/18/2008)

---

...

In my opinion, code clarity is more important that hoping the squeeze out a minuscule improvement in performance.

For instance, I was told, when joining two tables that this code:

[font="Courier...

This error is in VB.NET Code that is embedded...

psmith (8/18/2008)

---

Steve Jones - Editor (8/18/2008)

---

Why would you worry about productivity at home v the office? Plenty of people gab, goof off, walk around at the office and don't get...

I don't know of a simple way to change the language of a report, but here is an option, albeit not necessarily the best or possibly the easiest. You...

diana.rhoades (8/18/2008)

---

I don't have permission to run Profiler. I built the procedure so that based on the grouping parameter it hits an if/else that builds all the code based on...

What it really does it iterate over the list of databases and replaces the "?" with the database name, so for your query you would want to do this:

EXEC sp_msforeachdb...

Well, which column is the branch? Just modify my query to add the branch to the output and then add a group by branch.