The article is basically correct, but misses a few key points.

First, the recompile cost in SQL 2005 compared to SQL 2000, is vastly reduced. SQL 2005 can do statement-level...

Only thing I can think of in that case is install something like CutePDF and use that.

Take a look at msdb..sp_help_jobschedule. That might do what you need.

You should be able to print right from the File menu of Management Studio. Can you not?

There isn't a way that I know of.

If what they're running are simple ad hoc queries, it shouldn't matter too much. If they're doing that in production code, then...

Personally, I'd rather have a manager who was skilled at management and poor at technology than the other way around.

My current manager likes to joke about his "prequel" skills. ...

You can shrink a database if you need to. Rebuilding indexes afterwards will help.

I just recommend against it because, (a) it fragments indexes and reduces performance, and (b) it...

They way I think I'd do it, in that case, is have the cost be a column in the table where you log the error dates. Then you can...

My wife's car (the one we use 90% of the time, since she likes to drive and I don't) is an old Mazda Protege. Standard transmission, non-hybrid, etc. ...

Yes, it makes sense, but SQL sees it as a possible infinite loop. It isn't, but the code has to err on the side of false positives in this...

SQL Server is built to take a certain amount of RAM (as much as it can unless you tell it otherwise) and hang onto it indefinitely. That's by design,...

No, making it vertical is better. I'm just trying to understand how it works.

Let's say you have an order with 4 errors. That means you have 4 rows...

dva2007 (9/29/2008)

In this case if i want to rewrite some views then how do i make sure that which stored procedure i need to change? Because i need to change...

I follow the ParentChild table naming convention, but use plural names. Ends up kind of awkward sometimes, like "CustomersTypesCategories", but makes it very easy to find things in the...

Many-to-many reference tables have a similar problem. Can't chain delete from both parents into those. Have to use triggers for that kind of thing.