I routinely have to backup remote production databases and then restore them to local test servers. It's simple to have the host machine to the full backup to a...

Yes we should test Microsoft's code. I don't get that option with OS updates. They are crammed down the throat of my machines every week.

I have machines that...

Try this:

@echo off

if #%1# == ## goto noparm

echo running %1

echo ####################### running %1 #######################>>log.txt

osql -U log.txt

goto :done

:noparm

echo ####################### Start Process #######################>log.txt

for %%X in (*.sql) do (call %0 %%X)

echo #######################...

And here I wanted to talk about the blooper reel. 🙂 Good ones.

As a former broadcaster I have some suggestions. Since it's tape when you go...

WWW. ...

I could look it up for you, but then I'd have...

I'm and old IBM 1130 hack. A buddy of mine who was, at the time, a...

Jon,

I'm not sure how you would go about that. Your PersonProps table will get you flamed, but good, by many folks on this forum. It's called an Entity-Attribute-Value...

We used to call it Axle's Law: "Good, Fast, Cheap. Pick any two. Then we found out that Axle did not originate it. I just put it...

I watch Top Gear. One of my favorite programs on BBC. Clarkson is always complaining about cars with a limited top speed. Going 240 on anything but...

Eric Inman (9/17/2008)

---

Great info.

I see a lot of these in all my environments:

CREATE INDEX [missing_index_537_536_MSdistribution_history] ON [distribution].[dbo].[MSdistribution_history] ([agent_id],[time]) INCLUDE ([runstatus], [start_time], [timestamp])

Looks like replication needs some help, but fear...

Thanks Rob.

Good article. Great starting point. I one time saw a script that used this info to build the suggested indexes.

There is also some DMV about unused indexes. ...

Happy Birthday Steve!

Mine is next Monday, the 15th, and I'm only telling you lot. I avoid them. Diabetics don't get cake and ice cream. At my age...

Ralph Hightower (9/12/2008)

---

Happy Birthday Steve.

Umm, what would I want for my birthday?

I would like a fully functional PDP-11, preferably a PDP-11/45 or a PDP-11/70; one of the first computers that...