Viewing 15 posts - 50,596 through 50,610 (of 59,078 total)
Peso (5/12/2008)
Michaels suggestion runs in 334 seconds and needs 572,852 reads.
The SQL Server...
May 12, 2008 at 8:50 pm
Theanks for the feedback, Ted... I'll add those to the list of reasons why I don't use DTS or SSIS 😀
May 12, 2008 at 8:15 pm
born2bongo (5/12/2008)
May 12, 2008 at 8:14 pm
Kinda what I was getting at but couldn't do so in my coffee deprived state... thanks, Gus.
May 12, 2008 at 8:12 pm
Peso (5/12/2008)
I don't think : and ? are valid characters for a Windows filename.
HourCharASCII
--------------
0- 1048
1- 2159
2- 3250
3- 4351
4- 5452
5-...
May 12, 2008 at 8:10 pm
It would appear that you're trying to write everything as a single line using SP_OA... instead of trying to jamb everything into a single line of text, why not continue...
May 12, 2008 at 8:02 pm
karthikeyan (5/12/2008)
Jeff,Just i am thinking, will Tally table be a good replacement for this cursor ?
Hi Karthik,
I could be wrong, but I'm pretty sure the answer is "No"....
May 12, 2008 at 7:56 pm
GSquared (5/12/2008)
Sharul, the first thing I'd do for performance, is get rid of the conversion functions in...
May 12, 2008 at 7:46 pm
Jeff Moden (5/12/2008)
How many rows are being output by the query? Also, are you outputing the query to the screen? If so, why?
Still haven't answered the question above...
May 12, 2008 at 7:39 pm
I know it sounds strange, but the first thing I'd try is dropping and recreating the function.
May 12, 2008 at 7:37 pm
Matt Miller (5/12/2008)
Jeff Moden (5/12/2008)
May 12, 2008 at 7:26 pm
RyanRandall (5/12/2008)
Jeff Moden (5/12/2008)
Heh... not my blog, Ryan. I think that's Jeff Smith's, but I'm not sure.
LOL - yes I know it's not your blog. I guess you missed...
May 12, 2008 at 6:37 am
ahsansharjeel (5/12/2008)
SELECT * , ROW_NUMBER() OVER(ORDER BY ID) AS MY_ROW_NUM FROM
(
SELECT ID, FirstName, LastName, JoinDate FROM Table1
UNION
SELECT ID, FirstName,...
May 12, 2008 at 6:34 am
Instead of bailing from the company, you have a huge opportunity... set up a multi-million row test and show them why it's a bad idea. Challenge those that support...
May 12, 2008 at 6:26 am
RyanRandall (5/12/2008)
Jeff Moden (5/12/2008)
Isn't CROSS APPLY just another name for "correlated sub-query"?
😛
It sure is, but if it's the fastest method, who cares? 🙂
It's something else to try, anyway, and I'm...
May 12, 2008 at 6:23 am
Viewing 15 posts - 50,596 through 50,610 (of 59,078 total)