Create a scheduled job that writes the results of the dbcc command to a table.

Create an Excell sheet that queries the table your writing the prior steps results to. I...

I really like racosta's solution.

Are you wanting to know about the threading architecture, parallelism, changes to locking, overall performance, pro's vrs con's, what? That's an awful broad question. What are you trying to...

I think we can all agree that with a good understanding of the roles your assigning, security can be maintained. Whether you use a public role or create your own,...

No, dbcc memorystatus does not truncate the sysperfinfo table. It's a straight forward counter giving stats cumulative since the server started. And an excellent source of info.

I also use dbcc...

I prefer to use ISQL myself in a lot of instances. Keep in mind that's how it was done before microsoft went down the "we don't need a dba" path,...

I use a similar methodology as David. I've found that in most cases (there have been some exceptions), the left outer join insert runs with less overhead than a delete...

He's a perfect example of what I was talking about.......

Ask him what he intends to do when the disaster DOES occur, and remind him that since he knows about it...

Excellent Article. I've seen the heartbeats you describe ever since 7.0, and had researched it to see what it was years ago, but never thought to change the behavior myself....

I can't say that this is the best way to do it, but what I do is profile the database, including objectid and indexid, over a period of time determined...

LMAO......

In my humble opinion, the BEST kind of DBA is the one who says, "I don't know." when in fact he doesn't, and then goes and researches whatever it is...

It used to be, that we tried not to create clustered indexes on primary keys if they were simply incrementing numbers, such as an identity column. Sql server's architecture adjusts...

Although those are very good points, Brian, they do not apply to previous versions of SQL. Securities are cracking down and the situation as a whole is improving, but its...

I think people would be amazed at how often things like this occur though. I've seen similar things quite often, and when asking about them, find that the most common...

I'm with Antares686 on this one. My experiences have been in finding that someone created the queries for Crystal using that secretaries tool for query building that comes in Crystal,...