Viewing 15 posts - 16 through 30 (of 59,038 total)
Just to add to the advice - I would advise against SELECT * unless it is absolutely necessary. The reason being if the source metadata changes (column added or...
August 12, 2025 at 10:17 pm
I have to give Steve a huge amount of credit for my success... he's kept this site going and he encouraged me to write articles. This site was also a...
August 9, 2025 at 9:53 pm
However, when the query SELECT * FROM LS01.DB01.dbo.vwA is executed directly on Server B (targeting the linked server), the same operation takes approximately 50 seconds to complete.
We had similar...
August 9, 2025 at 9:25 pm
In some cases, indexes can hurt SELECT performance. .
Do you have a link on that subject?
August 9, 2025 at 3:05 am
Heh... all that and it still left a temporal BETWEEN instead of using the more correct and bullet proof "Closed/Open" comparison method...
...
WHERE soh.OrderDate >=...
July 28, 2025 at 9:15 pm
SELECT SUM([value]) AS [value], {some magic code} FROM [table1]
value is_processed
39.6 Y--===== Because 'Y' is greater than 'N', this works.
SELECT...
July 28, 2025 at 9:03 pm
THIS!!! (from the article)...
Plain language isn’t a lack of sophistication; it’s a sign of mastery.
July 22, 2025 at 3:59 pm
Just a bit of a sidebar... avoid using FORMAT except for maybe 1 row displays. Performance of FORMAT is absolutely horrible even compared to relatively complex CONVERTs. Here's an article...
July 22, 2025 at 3:52 pm
Heh... I'm with ya. My git'up'n'go has got up and went. Hope you had a pleasant weekend, Grant.
July 6, 2025 at 11:08 pm
The missing 5th choice, of course...
"All of them"
Happy Independence Day to all!
July 4, 2025 at 12:08 am
It's not happening to me. I'm not getting the error. I'm also not seeing the "Subscribe" button change to "Unsubscribe" either.
And, as soon as I said that, I hit "Subscribe"...
July 1, 2025 at 5:24 pm
How many core did the system you tested this on have?
June 23, 2025 at 7:49 pm
Please send me a pdf if possible.
The pre-aggregation sounds familiar
It should sound familiar. You've reviewed this slide deck before. I've made some modifications but, as before, I've mentioned that...
June 16, 2025 at 10:56 pm
This post is just a test to see what the response time of processing a post is now...
June 16, 2025 at 10:51 pm
Viewing 15 posts - 16 through 30 (of 59,038 total)