Exactly on surviving the 3 hour interview. Mine ran nearly 3 1/2 and it was the day before Thanksgiving. Nobody wants to do anything on days like that but when...

In December of last year I took a new position after being at the same company for over 16 years. It is totally natural to feel nervous because you are...

The Oracle tools became crap when 8i was introduced and Java came in to play. It is my opinion that this is a major reason the command line is the...

At a company I used to work for the application used a somewhat proprietary files system based "database" utilizing a DISAM setup. .dat and .idx files and either file type...

Lynn Pettis (2/19/2013)

---

If documentation exists and you fail to read it, you have only yourself to blame. Just pointing out one of the possible reasons you may not know...

It could be a text book and people will refuse to consult it. Apparently you've only worked with people who read everything before doing anything. I and I suspect most...

You assume people would bother to read such things. We all know everyone and every level reads the docs 🙂

I get that but my point is that sometimes you don't want this and if a person is performing an action without knowing or forgetting there is a trigger they...

I despise triggers because far too often they are doing things others are not aware of and they will spend too much time trying to find the cause only to...

Thanks for the info. I know for a fact there are tables with varchar(max) and such and I've seen a few of the procedures that app calls where they set...

TempDB has plenty of room but unfortunately these servers with the exception of one don't have that database on it own array. It is on the same disk as the...

Thanks you Gail for the quick reply. I've selectively turned page locks off on certain indexes over the course of a few weeks and I haven't had any issues (yet)...

The SLA is strict so once a week down time is something I can't do at this time.

Thanks for the info. One thing I want to make clear is that there is no index rebuilding, just reorg. This is why the update stats is the next step....

You need to sync your patch levels. Applying a service pack on a single machine does not apply it to all instances.