Viewing 15 posts - 46 through 60 (of 65 total)
Jeff Moden (9/28/2015)
Kim Crosser (9/28/2015)
On the other hand, UDFs used to do some fancy formatting of an output result value aren't likely to have any significant impact on performance.
Lets not...
September 28, 2015 at 4:54 pm
Luis Cazares (9/28/2015)
Just because it isn't a problem right now, it doesn't mean that it won't be a problem in the future. If Kristen starts refactoring the functions now, there...
September 28, 2015 at 1:00 pm
The real question is whether the UDFs are causing any performance problems. 10x sounds horrible, but in your system does that result in a query that runs 10 minutes...
September 28, 2015 at 10:12 am
In a system for which I was one of the principal architects, we code-generated stored procedures for each and every table that implemented full parameter validation and auditing, then added...
September 28, 2015 at 9:52 am
Manic Star (9/22/2015)
If you are using proper source control this is hardly an issue.
Source code control is important, but beside the point.
Most higher-level languages have some form of encapsulation. ...
September 24, 2015 at 7:01 pm
Of course, SQL Server could certainly benefit by implementing the Package concept that Oracle provides.
You can bundle all your related procedures and functions into a single Package for portability and...
September 17, 2015 at 9:34 am
FYI - some interesting Checksum behavior.
declare @STR varchar(8000) = '';
declare @i int = 0;
while @i < 256
begin
set @i = @i + 1;
...
September 16, 2015 at 9:29 am
Just for grins... I generated a list of CHECKSUM values for strings of "a", "aa", "aaa", ... up to a string of 255 "a" characters.
The Checksum values for...
September 15, 2015 at 11:26 am
The question may not have been fully qualified, but if you make some minimal assumptions about it, the answer given is correct. The whole point of the question is...
September 15, 2015 at 9:26 am
... and of course, you have a suitable (unique? clustered? as appropriate) index on ContractorCoverageException, like:
... ContractorCoverageException (contractorcoverageid, postalid)
or
... ContractorCoverageException (contractorcoverageid) include (postalid)
September 1, 2015 at 1:49 pm
Have you tried the following?
-- in the joins section
left outer join ContractorCoverageException e where e.contractorcoverageid = ContractorCoverage.id and e.postalid = postal.id
-- in the where section
and e.postalid is null
September 1, 2015 at 1:40 pm
I have the following Tenets regarding Software (or System) Deployments that I try to share with developers.
It looks like Airbus missed multiples of these - highlighted - the updated failed...
August 17, 2015 at 10:55 am
A lot of this stems from the fact that a binary "floating point" representation cannot exactly represent certain decimal values. In particular, any fractional part of a number ending...
August 13, 2015 at 1:25 pm
rmechaber (8/4/2015)
August 6, 2015 at 6:29 pm
My $0.02 (and worth every penny...).
When I am faced with a query that is performing poorly, particularly if it is joining a lot of tables and returning a lot of...
July 28, 2015 at 5:30 pm
Viewing 15 posts - 46 through 60 (of 65 total)