Viewing 15 posts - 52,756 through 52,770 (of 59,070 total)
...If anyone knows, please post it here so we can all learn something...
January 22, 2008 at 10:02 pm
Lester Policarpio (1/22/2008)
Just like human torch said "Flame On!!!!" peace to all :):D
It was a real life coach... I think Karthik can go a long way if he changes his...
January 22, 2008 at 9:01 pm
Thanks for the feedback... as always, my test data may not be 100% the same as your situation... once you've tried the index, lemme know how it works... might be...
January 22, 2008 at 8:56 pm
There is... assuming that your serial numbers are actually integers...
SELECT GapStart = (SELECT ISNULL(MAX(b.SerialNumber),0)+1
...
January 22, 2008 at 8:25 pm
Heh... make sure you get rid of that pesky TempDB database while your at it. 😛 All it does is take up room and cause headaches... saves a lot...
January 22, 2008 at 8:00 pm
ashishchap (1/22/2008)
We are storing the information as xml instead of the tables to minimize the storage space. XML is a MUST for our database.
Just a passing thought... maybe even a...
January 22, 2008 at 7:49 pm
I'll add a couple of more...
Everyone who doesn't telecommute will hate you (for obvious reasons).
Everyone who doesn't telecommute will perceive you as a slacker unless you produce double the work...
January 22, 2008 at 7:40 pm
Heh... I know what you're thinking and "No", do NOT change the order of the columns in the index I recommended 😉
January 22, 2008 at 7:31 pm
The PK Clustered Index you have might be good for something else, but it's no good for this query even though the execution plan say's you're using the clustered index......
January 22, 2008 at 7:30 pm
For testing purposes, how many file names are we talking about? And, if you don't mind, can you post the CREATE statment for the table, any existing indexs, and...
January 22, 2008 at 6:38 pm
Yowch! The data's a bloody mess. Who in their right mind would list the word "NULL" for a null in a transmitted text file nevermind add trailing spaces...
January 22, 2008 at 5:40 pm
Steve Rosenbach (1/13/2005)
Jeff, you have expressed more eloquently and in far less words my frustration with ISO-11179... and I only read Part 5 - the part about naming conventions!
Thanks, Steve......
January 22, 2008 at 5:17 pm
That's not nice... Matt was spot-on by saying you weren't providing enough information. I simply took a guess and didn't say much more than he did.
January 22, 2008 at 5:04 pm
I do. In fact, I wrote an article about it that should be coming out soon! It was submitted way back on 11 Dec 2007...
January 22, 2008 at 5:01 pm
And that, folks, is a Triangular join... works seemingly fine on small groups... cripples CPU's on larger groups... be careful...
See the following URL for more details on Triangular joins...
January 22, 2008 at 4:10 pm
Viewing 15 posts - 52,756 through 52,770 (of 59,070 total)