I would not believe that, anymore. It may have been true, but the optimizer is getting pretty smart. Kalen's had a couple of interesting articles digging into the optimizer...

I think the DBA should be part of the development team, even a developer with good data modeling skills may not have the current knowledge of the DBMS details.

How about...

Well I can't give any exact reasons, but.

DASD is cheap today, years ago,(many for some of us) saving a byte on a million or 2 rows was big $$$$. ...

Solved the problem. Guest was messed up, don't know how but fixed it.

Still don't know why the use appeared, I didn't create it in model so it's just going...

Still don't have a resolution, but here is some further info.

I created a dummy id, it has the same problem.

I cannot see the DB in the ODBC setup...

SAN Drives are clusters of external drives usually hooked to the server via Fiber. Versus SCSI Attached external drive enclosers. But the concept is similiar.

They map a LUN...

One reason I like poking around here regularly.

WITH TIES, didn't know about that one.

Except we're corporate casual, so we don't wear ties.

BOOO HISSS get the hook out.

KlK, MCSE

Drop the Middle "GO".

I did the same thing recently pasting together a bunch of code. The go apparently acts like an END for the SP, so the code following...

Well I was getting the error doing a restore with EM, I avoid command line stuff. (I use too much for DB2).

But I tried it with QA command and it...

Well to get exactly what you are looking for will take some extra work.

But if 123,456.78 is OK try this

Convert(Char(20), CAST(SUM(Loss_Disb_Amt) AS Money), 1) AS "Loss...

Just got done doing the reverse. Been building a DW on a test server, loading and cleansing the data. Used a linked server to copy the updates.

Create an ID...

Been running this config in Dev for ages, no issue's at the server.

Do note that older MDACs pre 2.6 (???) cannot easily reference a Named instance. That was the...

You are indicating that the TempDB Log is full, are you doing something to fill it.

Issuing a large select to identify the records to Delete ??

If so possibly consider...

I've actually been in IT for going on 35 years.

Started as a junior operator for the High School district. Minimum wage, but look where it lead too. The perks...

Well I'm still proud to be a "nerd".

Per the other thread about age, I was a nerd before nerds had some status.

But I will agree, I have no sense...