Now that I think of it, since my tempdb is the only occupant of F:, there's really no reason to not size it to 146GB and be done with it. ...

The warehouse load is a big, hairy monster that I hesitate to disturb.  The server guys want to turn off monitoring so they don't get a page when the disk...

You would need a client that is written in some language that understands how to read jpg files from a disk and can send it off to be inserted in...

"Imagine what would happen if the same kind of DBAs are also the interviewers too !!!!!!!!"

Then they would be managment. 

set nocount on

declare @Result TABLE (String varchar(50))

declare @String varchar(50), @10 char(3), @13 char(3), @9 char(3)

SET @10 = '%' + char(10) + '%'

SET @13 = '%' + char(13) + '%'

SET @9...

"I am creating a new erd diagram that has many tables that won't fit into the largest page."

Don't overlook the low-tech solution:  I only have an 8-1/2 by 11 inch...

In the USA, you can deduct bad debts from your taxes.  I don't recall if it's from gross income or adjusted gross, but it beats a blank.  (Note to self: ...

No underscores for me, either.  Fat fingers.

"If it was hard to write, it should be hard to read, and even harder to maintain."

I vote thumbs down on prefixes.  I am now dealing with 400+ tables that all begin with TBL_XX_tablename, where XX is the initials of the guy who created it.  The...

I've had nine contracts or jobs the last eight years, so I've interviewed a bit.  I much prefer Joanna's scenario-based questions.  I've had a few tests, but mostly they were...

Why not go to VB.NET 2005 Express?

If you haven't already solved this, check out BULK INSERT and bcp in BOL and on this site.  You should be able to specify the column and row delimiters in...

Skip:

I, too, have suffered from the sins of the fathers (and mothers) with a similar setup.  Assuming that you store the value of the ID column in each child table and...

I would bulk insert it into a table, massage it, then use bcp to write to the file.  Search the forums here or look in BOL for some useful information.

Luck,...

Minh:  Search the site forums for "apostrophe", and you will get lots of useful information.