Viewing 15 posts - 56,431 through 56,445 (of 59,072 total)
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...
May 16, 2007 at 8:57 pm
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...
May 16, 2007 at 8:51 pm
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...
May 16, 2007 at 8:49 pm
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...
May 15, 2007 at 11:57 pm
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...
May 15, 2007 at 11:51 pm
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...
May 15, 2007 at 11:49 pm
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...
May 15, 2007 at 8:10 am
Thanks... that's gotta be a 2005 thing, huh? Wondered when they would get around to forcing that issue...
May 15, 2007 at 8:04 am
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...
May 15, 2007 at 8:01 am
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...
May 15, 2007 at 7:43 am
Heh... maybe that's it! I should thank him, huh? ![]()
May 15, 2007 at 1:32 am
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.
May 14, 2007 at 9:36 pm
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.
May 14, 2007 at 9:32 pm
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...
May 14, 2007 at 9:17 pm
Viewing 15 posts - 56,431 through 56,445 (of 59,072 total)