Viewing 15 posts - 6,361 through 6,375 (of 59,070 total)
Any MDF, NDF, or LDF file currently being used by SQL Server cannot be modified in any way. With that in mind (and it would also work if multiple instances...
September 21, 2020 at 7:11 pm
Jeff published a wonderfull article called: Create a Tally Function
Thank you for the kudo. If you've not subscribed to the article discussion, you may want to. I've found...
September 21, 2020 at 6:44 pm
Jeff, I was going to mark your response above as the answer but it actually doesn't answer the question. Your answer is merely complete and I asked for minimal. ...
September 21, 2020 at 5:34 pm
Ah... almost forgot... What to do about the folks that claim that performance doesn't matter if you know that here will always only be a small number of...
September 20, 2020 at 7:06 pm
That person's query also contained a RIGHT OUTER JOIN. When was the last time you actually saw one of those not in a textbook?
About 10 minutes ago. I use...
September 20, 2020 at 6:55 pm
Some things CAN be done in SQL, but can be done so much faster and/or easier in other languages.
While that is certainly true, I find that it's a matter...
September 20, 2020 at 3:16 am
Ok here are two recent winning recursive cte's. Be gentle when evaluating the opposing answers 🙂
https://stackoverflow.com/questions/63922869/get-an-interval-of-dates-from-a-range-of-dates/63923536
https://stackoverflow.com/questions/63919706/fill-missing-months-on-a-date-query/63920844
As a bonus, here losing while using an ordinal splitter
https://stackoverflow.com/questions/63886788/extracting-date-from-text-in-sql-using-cursor/63887736
Thank you for posting those...
September 20, 2020 at 12:19 am
Ah... almost forgot... What to do about the folks that claim that performance doesn't matter if you know that there will always only be a small number of rows involved...
September 19, 2020 at 9:46 pm
Ok, here we go...
The code that you originally wrote generates the full range of values that the inline cascading CTE for the Tally cte can generate and it does so...
September 19, 2020 at 8:07 pm
What is the minimal way to create a tally table/tvf/cte and to describe its advantages (if any) versus recursive cte's? For the past several weeks I've observed most (all)...
September 19, 2020 at 3:39 pm
Jeffrey Williams, the more I look at your code the more I like it. I definitely missed a few things and using TOP in the select is so obvious...
September 19, 2020 at 3:21 pm
However, analysis of the execution plan shows it's horribly inefficient.
Until the later versions of SSMS 18.X, the execution plan doesn't really have anything that is actually a good determination...
September 19, 2020 at 3:13 pm
Over and over and over the tally based solutions almost always lose to a recursive cte based solution.
I've not checked the other posts on this thread yet but do...
September 19, 2020 at 3:08 pm
Johan,
If I quote your post, I can see your script in it but it's not doing a normal show on your post.
September 18, 2020 at 12:40 pm
If I have more than 50 servers do i need to create the Job in all 50 servers?
No. Look for Get-DBADump at the following link. It's part of the...
September 18, 2020 at 12:10 am
Viewing 15 posts - 6,361 through 6,375 (of 59,070 total)