Viewing 15 posts - 4,501 through 4,515 (of 59,067 total)
You don't need a table valued function. A view will do the job:
"It Depends". I've found that a whole lot of folks end up writing code that causes all...
October 4, 2021 at 2:49 pm
You could try SSIS Catalog Migration Wizard on Visual Studio Marketplace.
That link is broken.
October 4, 2021 at 3:52 am
Can you please assist with some way.
Thank you
Heh... DUDE! Look at the latest post I have code posted in! ;D
October 4, 2021 at 3:48 am
I'll try to get back to this tomorrow. I ran out of time today.
October 4, 2021 at 3:47 am
Database and index reviews cannot be automated. No software now does even a reasonably decent job of doing that. It must be done by a person.
Just to be sure,...
October 3, 2021 at 10:27 pm
Editing of this post in process. Will repost in a couple of minutes.
October 3, 2021 at 10:14 pm
From my previous life as a production engineer (making stuff) I'd call it an improvement in resolution, rather than accuracy. Along the same lines as someone hamfisted using a...
October 2, 2021 at 7:59 pm
Can you show me please what that code will look like?
Sure but the is no clear definition that I can see of what the desired output is in the...
October 2, 2021 at 7:54 pm
If you look at the previous code, 90% of the answer is in the first CTE. All you have to do to that is add some of the original columns...
October 2, 2021 at 7:49 pm
Jeff, I'm not about points (I give most of mine away) or "3 pointing stripes", whatever that means. Somewhat like yous here, I donate my time to help people...
October 2, 2021 at 6:44 pm
A possible alternative to all that is maybe it should be in an iTVF (inline Table Valued Function) so that it can be called by multiple procs and still be...
October 2, 2021 at 6:30 pm
Current index inventory
Current index usage
New indexes recommendations
What do you think should I add ?
NOTE: Edited to clarify what can be automated and what requires "human judgement".
And I give up...
October 2, 2021 at 6:16 pm
I think that a couple of better questions to ask your self is do you like your current job and are you happy with how much you're making?
I've also seen...
October 2, 2021 at 5:22 am
I had someone ask me how many a couple was this morning, it was just one of those weird moments where I assumed that was just standard knowledge but...
October 1, 2021 at 4:36 am
I agree with you Jeff and with your "ERROR in ACCURACY" definition 🙂
I have to thank you for the question! It's also ironic that I actually had to do...
October 1, 2021 at 4:34 am
Viewing 15 posts - 4,501 through 4,515 (of 59,067 total)