Viewing 15 posts - 4,366 through 4,380 (of 59,067 total)
Sorry... post withdrawn. Wrong post.
November 2, 2021 at 9:14 pm
Actually you could be causing a performance problem by getting SQL to use the same query plan for different values, i.e., by avoiding the "overhead" of a...
November 2, 2021 at 8:36 pm
I'd love to see a generic framework/example for this, even if the OP has left the building.
I know your preference for datetime over datetime2, but would also be interested...
November 2, 2021 at 8:31 pm
Actually you could be causing a performance problem by getting SQL to use the same query plan for different values, i.e., by avoiding the "overhead" of a recompile. The...
November 2, 2021 at 8:16 pm
The example is for a query called by the Customer List page of the web application. It will execute 1000's of times a day.
In that case, please see the...
November 2, 2021 at 3:53 pm
Any interest in your own problem that you posted?
November 2, 2021 at 3:16 pm
The common name for such a query is a "Catch-All" query and "It Depends" strongly comes into play here. How often will this query be executed?
November 2, 2021 at 3:07 pm
If you are planning for large amounts of data you might be interested in some 'light' reading:
https://www.itprotoday.com/sql-server/interval-queries-sql-server
Itzik's article is fantastic but I hope that doesn't scare off the...
November 2, 2021 at 2:42 pm
Thanks to all
Adelia,
Don't go yet. I asked you some questions about datatypes that you've not answered yet. If you let me know that the datatypes of the start and...
November 2, 2021 at 2:14 pm
I'd say it depends on how often you need to show the resolution duration. That's a rather complex calc to do repeatedly..
I have to disagree. If you...
November 1, 2021 at 11:49 pm
Regarding calculated column VS persisted triggered data, I don't have enough knowledge so I would like to read more. I was expecting the indexes to come to play already...
November 1, 2021 at 11:33 pm
I'd say it depends on how often you need to show the resolution duration. That's a rather complex calc to do repeatedly..
I have to disagree. If you use the...
November 1, 2021 at 3:31 pm
One would hope response time wouldn't change... though I've seen companies where even that might not be true.
I could see resolution time changing (e.g., help desk declares it resolved,...
November 1, 2021 at 3:26 pm
Strong suggestion, don't store the response time. Store the start and stop times and then calculate the response times when you retrieve the data.
I have to ask,...
November 1, 2021 at 3:14 pm
Strong suggestion, don't store the response time. Store the start and stop times and then calculate the response times when you retrieve the data.
I have to ask, what is...
November 1, 2021 at 2:31 pm
Viewing 15 posts - 4,366 through 4,380 (of 59,067 total)