Viewing 15 posts - 10,906 through 10,920 (of 14,953 total)
Grant Fritchey (2/19/2009)
GilaMonster (2/19/2009)
Roy Ernest (2/19/2009)
My problem is the management says I am too tough when giving interviews.
My former management used to tell me the same thing. So I expect...
February 19, 2009 at 7:23 am
I think it actually goes one step further than that in some of these cases.
Gathering vast amounts of information is usually justified with "it's more efficient". It's more efficient...
February 19, 2009 at 7:07 am
James Stover (2/18/2009)
What's this? Organizations wasting time and money and making poor decisions? Inconceivable!
You must work for a government office. Don't worry, this kind of thing only happens in...
February 18, 2009 at 3:05 pm
Search online for "parameter sniffing" and you'll find some good articles on that exact subject. They include solutions.
February 18, 2009 at 3:02 pm
GilaMonster (2/18/2009)
Roy Ernest (2/18/2009)
February 18, 2009 at 3:00 pm
Glad we could help. Learning new stuff is cool. It's one of the things that keeps me coming back to this site.
February 18, 2009 at 1:38 pm
Roy Ernest (2/18/2009)
There was one thing that was...
February 18, 2009 at 1:36 pm
It doesn't matter what you name the table. Some people on this site call it Tally. I call it Numbers. I've seen Integers too, I think. ...
February 18, 2009 at 1:35 pm
Select
isnull(ALIAS1.naam, ALIAS2.naam) as naam,
isnull(ALIAS1.Aantal_Incidenten, 0) as Aantal_Incidenten,
isnull(ALIAS2.Aantal_Inc_Portal, 0) as Aantal_Inc_Portal
FROM
(
select vestiging.naam, count(*) as Aantal_Incidenten
from incident, vestiging
where incident.aanmeldervestigingid = vestiging.unid
group by vestiging.naam
) ALIAS1 FULL OUTER...
February 18, 2009 at 1:29 pm
The most annoying thing in the forums is that I can't post XML in them. Some solutions/answers require XML, and I have to resort to attaching text files, or...
February 18, 2009 at 1:26 pm
Replace the Inner Join with Full Outer Join, and do this to the numeric columns:
IsNull(ALIAS1.Aantal_Incidenten, 0) as Aantal_Incidenten
February 18, 2009 at 1:19 pm
Are you using SQL 2000? I assumed 2005, because of the forum the question was posted in.
If so, then you won't be able to use the XML version of...
February 18, 2009 at 1:15 pm
One of the best ways to improve performance is to write good queries.
Another is to have a well-defined data architecture (schema).
You should also set up the right indexes and maintenance...
February 18, 2009 at 1:03 pm
Remove the "Alias2.naam" column from the select statement and you should have what you want.
February 18, 2009 at 1:02 pm
Perhaps permissions on the folder it's accessing? Perhaps permissions in SQL Server?
February 18, 2009 at 12:51 pm
Viewing 15 posts - 10,906 through 10,920 (of 14,953 total)