Viewing 15 posts - 3,496 through 3,510 (of 7,609 total)
March 16, 2018 at 12:15 pm
March 16, 2018 at 8:21 am
Cluster the table by the most common search. Most searches aren't totally random each time. If this one really is, use an int (or bigint) key, not a char(20) one...
March 15, 2018 at 1:40 pm
It doesn't look like you're passing a date, you're passing an id instead, which will get interpreted as a date but it won't be the date you expect or want.
March 15, 2018 at 1:28 pm
March 15, 2018 at 7:59 am
March 14, 2018 at 11:56 am
March 13, 2018 at 2:44 pm
March 13, 2018 at 2:03 pm
March 13, 2018 at 12:40 pm
You should seriously consider specifying "ON DELETE SET NULL" in the FK relationship and let SQL do this for you rather than writing it yourself.
March 13, 2018 at 12:00 pm
March 13, 2018 at 11:49 am
So below either one should work,
where sg.storedDate...
March 13, 2018 at 11:30 am
TableA is not the issue. And the subquery is not correlated, so the subquery is not directly the issue either.
Look at the query plan. If SQL's having to...
March 13, 2018 at 11:24 am
March 8, 2018 at 11:36 am
'm fully in agreement about normalization, though. The impedance mismatch between object oriented design and 3NF is often painful (3NF is viewed by many developers as horrifically antiquated).
Roger.Plowman
March 8, 2018 at 10:24 am
Viewing 15 posts - 3,496 through 3,510 (of 7,609 total)