Viewing 15 posts - 6,811 through 6,825 (of 6,831 total)
All those LEFT JOINs will kill your performance.
But, would you really ever need to process the Item master table? Wouldn't you be more likely to be processing the Applications, etc.,...
July 25, 2006 at 9:07 am
I would think that the first time the proc is run, and any future time that it has been paged out of the cache, there will be more overhead for...
July 25, 2006 at 8:46 am
Very sweet!
But why the extra overhead of declaring and setting a variable? Why not just return the calc'd value?
...
BEGIN
RETURN CASE WHEN ...
END
July 25, 2006 at 8:36 am
Make sure the table is not fragmented. You will have to add an index to check and/or adjust fragmentation. Once the table is compacted, if necessary, you can drop the...
June 28, 2006 at 12:37 pm
The method below creates and loads a table data type to hold the desired datetime ranges. The defaults are as you specified -- from 17:00 the previous day to 17:00...
June 28, 2006 at 12:32 pm
If you want to check the identity column specifically, you can use the reserved name IDENTITYCOL, which will always refer to the identity column of any table:
SELECT * FROM tableName
WHERE...
June 28, 2006 at 12:06 pm
What about the overhead of the comments themselves? This if often overlooked. It's my understanding that SQL does load comments (even full-line/multi-line comments) into the proc cache. So lots of...
June 13, 2006 at 10:26 am
One of my concerns with a sequence table, aside from the additional I/O and other overhead, is that you cannot then easily insert multiple invoices in one statement.
If, for example,...
May 17, 2006 at 10:21 am
>> "SET IDENTITY_INSERT ON" would be needed for prior year, with logic similar to above, but hopefully that would be relatively rare. <<
In fact, in most systems, especially dealing with...
May 17, 2006 at 8:59 am
Yes. Or possibly even a single identity column that was re-seeded each year to yy00000[0]; the "-" could be added prior to display just for the "visual effect" for the user. ...
May 17, 2006 at 8:21 am
Don't see any need for the "IF" at the start of the function. I wrote an almost identical function for this purpose but with just the WHILE.
February 6, 2006 at 4:00 pm
To check for existence of a column, don't think you need to do a system table query at all, just use a built-in SQL function:
IF COL_LENGTH ('tableName', 'columnName') IS NULL
--column...
December 21, 2005 at 8:50 am
Something like this should perform *much* better
SELECT a.procid, b.[ClientName] AS CName, b.[CompanyName], b.[CustRefNum] AS CRef,
b.[JobNumber] AS JNumber, --...,
b.[County] AS RCounty
FROM ...
June 17, 2005 at 8:12 am
When you run code #1, it actually does seem to work, although I'm not exactly sure why it would. Since punctuation falls within that range, it really shouldn't. You can run...
June 2, 2005 at 9:29 am
Viewing 15 posts - 6,811 through 6,825 (of 6,831 total)