Viewing 15 posts - 16 through 30 (of 59,039 total)
For example, if you were planning to use the "Import Data" wizard. That's there in 20, and prior, but not in 21
What on Earth are they thinking?
Lordy...
August 13, 2025 at 2:45 pm
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
Viewing 15 posts - 16 through 30 (of 59,039 total)