Viewing 15 posts - 3,571 through 3,585 (of 4,080 total)
You could always unsubscribe, noel. 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 4:20 pm
You DID get the compliment from an MVP
I heard you were an MVP. What I meant to say was that I took more pride in that compliment...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 4:16 pm
We are getting ideas.
OMG NOOOOOOOooooooooo :w00t:
Steve, a suggestion for enhancements: Could each block have a copy button above it to make it easier to cut and paste...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 3:41 pm
Steve posted his times for 11000 rows as follows
SQL Server Execution Times:
CPU time = 4992 ms, elapsed time = 5213 ms.
When I tested it on my...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 3:23 pm
Thanks Jeff... I take more pride in a compliment like that from you than I would from an MVP.... although unfortunately it doesn't look as good on a resume. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 3:12 pm
I also found the function to be slow in testing. I had an alternate way of generating the number that was much quicker, but for performance, the best...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 3:02 pm
I just tested the function from that article ... it is SLOW!!!!
9999 rows converted using that function takes almost 20 seconds!!!
set statistics time on;
-- test using join to existing table
select...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 2:53 pm
I'm afraid I don't have an answer for you. We haven't implemented full-text search in production. Someone suggested using it to replace some existing search functionality...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 2:43 pm
Empire State Building
State Building
Building
Since you will be writing the parsing to build the strings, doing that shouldn't be a problem.
How volatile is the data in the name...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 2:13 pm
No sweat. I didn't see the requirement in the first post either. You owe me a millisecond 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 2:08 pm
Once the table is built it appears to be more efficient to just look a number up. Running the test below with 9999 different numbers, the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 2:07 pm
I've seen an article in here recently where someone had implemented a similar scheme. Essentially, at the time the name field was inserted, they parsed out all...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 12:58 pm
First, you should be warned that string manipulations like this should be done by the application, not in SQL. The reasons for this are to protect the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 11:16 am
DOH!! :w00t:
That's what I get for having gotten away from using EXEC.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 10:50 am
The answer to these kinds of questions is usually "It depends." Two significant variables here are the size of the name column (average of four words)...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2009 at 9:18 am
Viewing 15 posts - 3,571 through 3,585 (of 4,080 total)