Viewing 15 posts - 53,296 through 53,310 (of 59,068 total)
Navision will find and rewrite performance challenged code?
Ok, since you brougt it up, I'll bite... what does Navision do?
December 28, 2007 at 11:45 am
Heh... agreed... but I'm not a moderator... usually, I'm just part of the problem 😛
December 28, 2007 at 11:43 am
pavithag_clarion (12/28/2007)
Can you explain in detail please..
Dinesh's fine solution will work for SSIS... I just don't like SSIS 😛
December 28, 2007 at 11:38 am
Heh... yeah... so they would say! After seeing the cruddy stored procedures they wrote (like sp_SpacedUsed, for example), it must be a "black light" 😛
December 28, 2007 at 11:30 am
Jeff Moden (12/28/2007)
Koji Matsumura (12/28/2007)
Jeff Moden (12/28/2007)
Exactly what I did in my cross-tab code... nice, job, Koji...
Jeff,
with SET STATISTICS IO ON
SELECT TV.Feature, TV.RunStatus, 100.00 * COUNT(*) / B.FeatureCount
:
GROUP BY TV.Feature,...
December 28, 2007 at 11:25 am
Koji Matsumura (12/28/2007)
Jeff Moden (12/28/2007)
Exactly what I did in my cross-tab code... nice, job, Koji...
Jeff,
with SET STATISTICS IO ON
SELECT TV.Feature, TV.RunStatus, 100.00 * COUNT(*) / B.FeatureCount
:
GROUP BY TV.Feature, TV.RunStatus, B.FeatureCount
:
Mine...
December 28, 2007 at 11:14 am
Then it's simple, Jason... Split what get's built for @SQL2 into two or 3 parts based on the number of RunStatuses (60 total) and change the execution to EXEC (@SQL1+@SQL2a+@SQL2b+@SQL2c+@SQL3)......
December 28, 2007 at 11:04 am
Heh... I have a real appreciation for that, Jacob... it's called "arrogance" and I usually don't tolerate it. My feeling is that if they want it real bad, maybe...
December 28, 2007 at 1:15 am
Exactly what I did in my cross-tab code... nice, job, Koji...
December 28, 2007 at 1:11 am
Ok... enough suspense... I'll tell you why... first a review of the dreadful mistake that a lot of developers make. A developer has to solve the problem of returning...
December 28, 2007 at 12:49 am
Madhivanan (12/28/2007)
You need to use IS NULL or IS NOT NULL to check againt NULL
Actually, for the problem I posted, that's absolutely NOT true. Do you know why? 😉
December 28, 2007 at 12:29 am
jose (12/6/2007)
How can i apply this if I'm using sql server 2000? (because the problem of the variable @sql =varchar(8000), in sql server 2000 doesnt...
December 28, 2007 at 12:24 am
shashi kant (12/7/2006)
Instand of using this thing u can use the Table variable while loop which help lot compare to Cursor...
Actually, that's an old wive's tale... a "Firehose" cursor is...
December 28, 2007 at 12:13 am
These should help...
http://www.databasejournal.com/features/mssql/article.php/1462641
http://codebetter.com/blogs/raymond.lewallen/archive/2005/09/12/131869.aspx
http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-41-udf_Sys_RegReadStr.htm
December 28, 2007 at 12:06 am
Viewing 15 posts - 53,296 through 53,310 (of 59,068 total)