Table variables are great

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #151,495 by ChrisR 4/16/04 8:37:19 PM Reply	Table variables are great They run faster since they don't use logging (no transaction overhead). Just wish they'd taken the next logical step and allow you to pass them as a parameter to another procedure. Means that all the processing on the Table Variable has to be inside one procedure - making modularity hard to accomplish.
Post #151,591 by mmoffitt 4/18/04 12:26:23 PM Reply	Thanks. If I ever get time to re-design the mess I've made, I'll give them a whirl.

Slow query needs optimizing - (tangaroa) - (19) - April 16, 2004, 02:52:55 AM EDT

Re: Slow query needs optimizing - (pwhysall) - (3) - April 16, 2004, 07:02:04 AM EDT

Just imagine a Beowolf cluster of those. -NT - (ChrisR) - (2) - April 16, 2004, 11:33:33 AM EDT

Great, now we're turning into /. - (inthane-chan) - April 16, 2004, 11:36:50 AM EDT

Running DOSiX! -NT - (Another Scott) - April 16, 2004, 11:50:39 AM EDT

Can you post - (jbrabeck) - (6) - April 16, 2004, 09:55:24 AM EDT

'fraid not - (tangaroa) - (5) - April 16, 2004, 06:11:09 PM EDT

pump to file, cat file |sort -k3 >outputfile - (boxley) - April 16, 2004, 10:48:21 PM EDT

If you're allowed correlated subquery, then: - (morganek) - (1) - April 16, 2004, 11:43:11 PM EDT

Re: If you're allowed correlated subquery, then: - (tangaroa) - April 17, 2004, 12:12:09 AM EDT

Re: 'fraid not - (JayMehaffey) - (1) - April 17, 2004, 01:43:40 AM EDT

Is "SQL Sever" intentional? (Regardless, I like it. :-) -NT - (ben_tilly) - April 17, 2004, 01:49:40 AM EDT

I don't recognize the "within" clause - (ben_tilly) - April 16, 2004, 01:47:40 PM EDT

Not quite sure what you are doing - (JayMehaffey) - (6) - April 16, 2004, 03:49:51 PM EDT

Whew, glad it's not just me that didn't understand. -NT - (jbrabeck) - April 16, 2004, 04:02:30 PM EDT

Pet peeve on SQLServer - (ChrisR) - (4) - April 16, 2004, 04:38:14 PM EDT

Rarely use real temporary tables - (JayMehaffey) - (3) - April 16, 2004, 05:27:44 PM EDT

I just finished writing about 15 stored procedures. - (mmoffitt) - (2) - April 16, 2004, 08:09:35 PM EDT

Table variables are great - (ChrisR) - (1) - April 16, 2004, 08:37:19 PM EDT

Thanks. - (mmoffitt) - April 18, 2004, 12:26:23 PM EDT

When?
78 ms