Touche.

I worded that poorly. It's not so much that you can write poor...

Shrinking - sometimes. Auto-shrinking - essentially never.

Shrinking allows you to recover some size...

J Sitz (3/10/2008)

---

Matt,

Rebooting the server fixed it. How can I test for a memory leak on the server? This was the first assembly on the server, but it...

if you don't like the row terminator, then add the -r (row terminator) flag to your BCP. You will need to try various ones to find which one works...

It would look something like this:

Alter DATABASE [tempdb]

MODIFY...

Nice article...but -

I can't help but ask - why use VBScript when you can use an actual full-featured language? You know - something with actual types, error-handling, etc...?

I...

The bigger question is - what kind of data do you need to get into Informix? What types of files does Informix prefers?

You can export (using SSIS, BCP, or...

If you mean turning off logging through the transaction log - no. Not possible. All activity is "logged" (meaning the changes are put into the log FIRST, then...

Jeff Moden (3/10/2008)

---

Throw CTE's and ROW_NUMBER() into the picture and the idea of using a cursor just means you got lazy or you really shouldn't be writting SQL (not anyone...

Not only is the new pivot command limited to one column, it's limited to...

I noticed you mentioned that the Maintenance plan does a log backup. That would fail if the DB is in Simple recovery mode.......

(Log backups only "work" in Full or...

Actually dfalso - not at all. it's fairly remarkable what formats work right out of the box.... just CAST them to datetime. with or without slashes....

Well right - it's homework, so you need to do most of the heavy lifting.

A few questions might help you along though:

- what's the term used in databases dealing...

Steve Jones - Editor (3/10/2008)

---

My one dog doesn't like peanut butter. First dog I've seen like that. American cheese folder around the pill works well.

giving a horse aspirin is a...

One of the primary attributes of a Primary Key is that is must be unique - so your purchase order ID cannot be the PK of this particular table (since...