Alvin Ramard (6/18/2009)

---

That ok. I'm not going to...

What's weird about those results?

Check how long those log readers have been running. It usually continuous since the last time the server was started, which could account for the high...

Can you run a checkDB on that database please. Sometimes that message is because of corruption.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

You can use RAISERROR ... WITH LOG if you're a sysadmin user or have ALTER TRACE permissions

GSquared (6/18/2009)

---

As to which will be in first place, it'll depend on how fast they run. If, for example, I were an MCA (I'm not), and Gail were an...

Any findings/conclusions from testing?

For the table definitions, you can generate them from Management studio. Open object explorer, connect to the server, expand out the tree until you get to the tables, right click...

Insulting him is uncalled for.

What is it you don't understand?

I can't really help you out, because I'm not sure what it is that you want exactly. That's why I'm asking for sample data and...

Jeff Moden (6/17/2009)

---

RBarryYoung (6/17/2009)

---

Jeff Moden (6/17/2009)

---

...All they really need to do is make SUM() OVER work according to ANSI standards (or so I've heard). Of course, that particular documented...

Have you looked at Toad? It's 3rd party and not free, but I've heard good things about it. Other option if you still have 2000 disk lying around is to...

SELECT TOP 1 Employee.*

FROM Employee inner join salary on employee.empid = salary.empid

Order by Salary DESC

Test it out and see if it's better or worse than the one that you have.

jordonpilling (6/18/2009)

---

Now, I have a weekly Index rebuild task which may be bloating the log file considerably as you say. What I will do then is, alter my Weekly Rebuild...

You can have a look at a query's execution plan. It'll show what indexes were used on that execution.

The log files won't shrink. Backup log just makes the space inside reusable, it doesn't reduce the size of the file.

Personally, I would leave the file that big. If it's...