Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

My Badges

Request Friendship



Upload Image

My Sections

My Activities

Blogs69
Just Learned315
Puzzles50
Ask4
Pages5
Quiz4
ErikEckhardt
65 · 3% · 898

ErikEckhardt's Home

My name is ErikEckhardt.I live in USA . I work as Database, Application and Website Programmer Analyst Designer.
  • Performance comparison - IIF logical function Vs CASE expression

    ErikEckhardt Commented 1 Years ago through Blogs
    I disagree with your conclusion. The resolution of the SQL server clock is 16.6667 ms, so any numbers that are 15-17 ms apart are only **one time unit** away from each other. I would say from the results you got that they are in fact identical. Could yo...
    Madhivanan JR
    3 · 40% · 12947
  • Grouping Date and time values with DATEADD and DATEDIFF functions

    ErikEckhardt Commented 1 Years ago through Blogs
    @qaisi786: Converting to varchar is slower than using date math. It is also much less clear (it has magic numbers like in your code, 111, whose meaning has to be memorized or looked up to know what is going on). Learning to use date math over string ...
    Madhivanan JR
    3 · 40% · 12947
  • Efficient filtering with HAVING Clause

    ErikEckhardt Commented 1 Years ago through Blogs
    That is a perfectly reasonable query, too. Testing is in order, as usual....
    Madhivanan JR
    3 · 40% · 12947
  • Efficient filtering with HAVING Clause

    ErikEckhardt Commented 1 Years ago through Blogs
    I'm so glad you're catching my mistakes, because I'm not doing it, obviously! You are 100% correct: I meant "not exists". I should actually be running my queries against your supplied data before posting them, shouldn't I? :) About my query number 4,...
    Madhivanan JR
    3 · 40% · 12947
  • Efficient filtering with HAVING Clause

    ErikEckhardt Commented 1 Years ago through Blogs
    Yes, you made another good catch--it was late and I was in a hurry, I guess. I've updated the query in my post to remove the extraneous snippet. About query #3, I did miss the extra requirement "and no other products". So here's a revised query for #...
    Madhivanan JR
    3 · 40% · 12947
  • Efficient filtering with HAVING Clause

    ErikEckhardt Commented 1 Years ago through Blogs
    Ah, thanks for pointing that out--I missed part of the requirements. I will re-examine as soon as I can....
    Madhivanan JR
    3 · 40% · 12947
  • Efficient filtering with HAVING Clause

    ErikEckhardt Commented 1 Years ago through Blogs
    I like a lot of what you've shown, though I have a small quibble with queries 3 and 4. In those, the queries cannot make use of an index on the `product_id` to gain a seek, but would require a full scan. This would almost certainly be a performance prob...
    Madhivanan JR
    3 · 40% · 12947
  • Question of the month June 2013 - When did you use CURSOR for performance benefit?

    ErikEckhardt Commented 1 Years ago through Blogs
    A cursor *may* outperform a `WHILE` loop in some scenarios where (as others have said) one must do something one at a time, such as create a `VIEW` or a `TRIGGER` for each row in a table. However, I've always used `WHILE` loops. @Jeff about an email-...
    Madhivanan JR
    3 · 40% · 12947
  • Table with only one column

    ErikEckhardt Commented 1 Years ago through Blogs
    A table with a single column definitely has practical uses. One is a column that signifies the presence or absence of something, and to which one wants to make a child-FK relationship, so that relationship cannot exist without a corresponding row, and t...
    Madhivanan JR
    3 · 40% · 12947
  • POWER function may not return accurate values

    ErikEckhardt learned 1 Years ago through Blogs
    ...
    Madhivanan JR
    3 · 40% · 12947
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.