GSquared,

All good questions.

If I knew I was not qualified to perform the interview myself, I would start by writing as good a job description as I was able. Then,...

Grant Fritchey (8/27/2012)

---

You might want to hire a consultant to do the interview for you. I know several people that are regularly doing interviews for employers that don't have the...

Thanks. I'm looking forward to it, as is my company's software development staff.

LC

Jeff,

I may have missed it glancing through all of the posts. When do you plan to produce Part 3?

Thanks for the effort you expended on such excellent documentation.

LC

Understood. I don't have very much experience with Powershell.

Could you make them part of a SQL Agent job? When our database backup jobs execute, the jobs execute:

> step 1 -...

I've run into some subtleties when using ROBOCOPY as a SQL Agent job step:

1. Don't paste the ROBOCOPY code into a SQL Agent job step properties, general page, command window....

hkflight (1/25/2012)

---

Thank you both very much for your help. Unfortunately, I cannot control indexes or queries as they are part of the software and if I changed them, future updates...

My employer has 2 production database servers and a Compellent SAN. I am both the DBA and the SAN Administrator.

After monitoring both database server and SAN activities during backups, I...

And your point is?

If it's 3 years old, does it make the information in the thread any less valuable?

Being 3 years old, why did...

Simon-413722 (7/1/2008)

---

Whilst it does make sense to only have 1 transaction log per User DB, any idea about tempdb? The recommendation from M$ was to have 1 data file per...

While doing some testing on my laptop, I inadvertently triggered a known bug in SQL Server Configuration Manager where if one of the SQL Server services is disabled it cannot...

fahey.jonathan (1/24/2012)

---

This may be unrelated, but I had a problem once with a query that acted very strangely. Long story short, there were unprintable characters in the texgt that...

SQL Server, et al, and SAN administration, Systems Administration, Network Administration.

LC

laurence.pulle (10/31/2011)

---

The query on the larger table is fairly simple:

delete

from audit_event

where start_timestamp < '01-may-2011'

The query on the smaller table will be more involved and needs rewriting...

Ninja's_RGR'us (10/27/2011)

---

Lee Crain (10/27/2011)

---

That's a shotgun criticism. Could you be a little more surgical? 😀

If you're educated about proper indexing, the information Performance Dashboard provides can be used in a...