A 200 mb TempDB is nothing... I wouldn't recommend leaving it that small... as others have stated, figure out how big it needs to be and the set the intial...

Here there everybody... thank you folks for the good info... most of you are of the same ilk about the necessity of a primay key... I think that's why they...

Heh... figures... Rudy!  They cut off my access to the DB in question so I can't see the table and it's dependents anymore... guess they got tired of my prying...

Heh... yeah, I was talking about the indexes.  BTW (dunno if you took it this way)  Didn't mean to make it sound like that whole thing was directed at you or...

I strongly recommend that you do NOT store images in your database... store the file names in the database and let the app load them.

See my next post below for...

Post the cursor and some info about what it's supposed to be doing.  A little table info would help, too.  You'd be amazed at what folks can do about getting...

I gotta look that one up, Steve...  I very well could be having a problem with convincing the DBA if my definition of what a heap is is incorrect.   My...

Thanks... that's gotta be a 2005 thing, huh?  Wondered when they would get around to forcing that issue...

I'm not at work right now... I'll dig it up when I get there.  I normally have access from home but not on this particular DB...

Not sure what you mean, Ronda.  What kind of a sort are you talking about?

My real concern is over "entity integrity".... or, if you will, a table without a Primary...

http://www.sqlservercentral.com/columnists/jmoden/calculatingworkdays.asp

Heh... maybe that's it!  I should thank him, huh?

Yep... that's the position I was taking... just wanted to make sure there wasn't some exotic reason I was missing.  Thanks for the feedback, folks.

Yep... check Books Online... SQL Server has had it for a while now.  It also has ROLLUP which is like CUBE but without all the extra subtotals.

It would be done pretty much the same way in MS-SQL Server as you did in Oracle... unless you used a cursor which is not the most effective way to...