Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Every 3rd Friday of the Month

    Be careful when you use DW in a datepart function as the number that represents a particular day will change based on the value of @@DATEFIRST...

  • RE: Finding sets of records

    ON A.caseid = D.caseid

    where A.closedate = ' '

    group by D.caseid

    having sum(case when D.closedate = ' ' then 1 else 0 end) = 0

  • RE: Query Performance -Troubleshooting

    The issue scales with volume anyway and the particular query is largely irrelevant. A query that runs <1 sec on the test box takes 23 seconds on Prod...

  • RE: Available MBytes goal?

    Is 150MB too low? Well it kind of depends. Are you seeing paging on the servers? How if the page life expectancy in SQL, etc.

Viewing 4 posts - 1 through 4 (of 4 total)