Viewing 15 posts - 15,241 through 15,255 (of 18,923 total)
"you'd wither away and waste to nothing if you didn't have your work"
No chance... I have other lifes, remember??
July 12, 2005 at 7:42 am
I'd go further than that. His understanding of relational database is wrong. The goal of a database is to hide the data retrival task/methods from the user. ...
July 12, 2005 at 7:34 am
"and you have multiple records on the inserted table what value is @intTreeID going to receive? the first, the second,...?"
...the last (just in case the newbies come up on...
July 12, 2005 at 7:25 am
Have you tried the single select approach??? I'm sure it can be the hell out of this insert select thingy...
July 12, 2005 at 7:22 am
Also you might wanna look at the identity property to create a next id automatically. This will speed things up.
July 12, 2005 at 7:18 am
Guys you forgot the most important question to ask :
Why do you want to use dynamic sql??
Did you ever read this?
July 12, 2005 at 7:03 am
Nice quote, this one is ont step better : "Life is too short and good to work!" in fear"
July 12, 2005 at 6:36 am
Which would make sens because the local server executing the select could use the best plan instead of shipping all the data and letting the other server sort it out.
July 12, 2005 at 6:31 am
anyone got a huge table they can copy and drop to see the effects on the log?
July 12, 2005 at 6:24 am
R u talking to me??
The only way to track all those is to start a trace using the profiler. This will allow you to get all that information.
The downside...
July 12, 2005 at 6:23 am
I already said that, but he'll have to change the bot column to a tinyint to be able to index it.
July 12, 2005 at 6:19 am
Maybe something was recompiled, or rewritten in some way because you shouldn't get that big of a boost... moving from a sp to am inline function.
July 12, 2005 at 4:58 am
Ya that link is using DAO... not that much different from ADO but you still got to find the right method name
.
July 12, 2005 at 4:56 am
doesn't validate that it ends with '0000' and it won't work for canadian/europian zip codes
July 12, 2005 at 4:54 am
Will be watching
.
Now that I think of it I'm not that far away from the carpal tunnel stage...
July 11, 2005 at 8:23 pm
Viewing 15 posts - 15,241 through 15,255 (of 18,923 total)