Viewing 15 posts - 56,431 through 56,445 (of 59,067 total)
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
No, Sir, David... you're not wrong... but not for the reasons you state...
First, let's build a small table of only 10,000 rows with only the data with which we are...
May 14, 2007 at 8:43 pm
Heh... my boss' boss says that all the time... it's why our projects seem to go in so fast... who cares if it takes six months extra to fix what we...
May 14, 2007 at 6:00 am
Thanks, guys. Yeah, the only thing I could think of was a minimal logging bulk insert staging table but he's not using it for that... it's a permanent cross-reference table...
May 14, 2007 at 5:57 am
Who are you and what have you done with the real Serqiy? The real Serqiy I know would have said something about going back and fixing the database so there...
May 13, 2007 at 9:08 pm
Viewing 15 posts - 56,431 through 56,445 (of 59,067 total)