Viewing 15 posts - 2,851 through 2,865 (of 4,080 total)
Lynn, I may need to borrow a sand dune. Our man with the concurrency question still won't accept that SQL will handle his potential-double-insert fears, even after...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 8, 2009 at 7:15 am
Conditional or not, an INSERT is an INSERT. Look at the code I just sent you and think about it for a moment. Using...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 8, 2009 at 6:57 am
Dean, I recently saw a query where the developer used a temp table to break something down into steps. The result was to run at least...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 8, 2009 at 6:50 am
Typically I try to make things happen in a single query, trying for a single pass through the table(s). If it doesn't seem to be running very fast,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 7, 2009 at 5:04 pm
Another this is, is it good development practice to always select distinct from a table, as my feeling is that, if the table is properly normalized, structured and free...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 7, 2009 at 4:31 pm
Jamie, are you thinking that you have to somehow code the locks yourself?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 7, 2009 at 2:28 pm
That is incorrect. Look at this. You can start a transaction explicity and leave it hanging in session 1, then go to session 2 and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 7, 2009 at 2:19 pm
Obviously, neither did I. But that's worth remembering. Thanks, Mark!
However, it seems the two CTE approach runs a little faster with a larger number of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 7, 2009 at 1:28 pm
Indexing as in indexes on the database tables to make searches against the tables efficient so they don't cause massive locking and very slow queries. No app can provide that....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 10:51 pm
Just for fun... Don't ask if you can insert before you can insert. In situations where you actually expect the insert to succeed most of the time,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 10:24 pm
There isn't a native one, but why not write one? To solve your DATEDIFF issue, I actually think you want the greater value. It can be made...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 9:34 pm
If you want a weird programming language, look at Whitespace.
Is that band still touring? I thought they broke up.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 2:48 pm
You really are a ninja, Gus!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 2:39 pm
...and GSquared is invisible ???
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 2:29 pm
But do you look like your avatar, Roy?
P.S. It's good to see you back online. I can't remember if I said that earlier.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 2:06 pm
Viewing 15 posts - 2,851 through 2,865 (of 4,080 total)