|
MarkTJohnson wrote: Now, having read Mycroft's post I feel terrible about my post. I'm not Also looked like a bit of a jest, since 22 days for "hello world" would indeed be a bit of.. underwhelming
MarkTJohnson wrote: Good to hear Tx
Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Welcome back
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
tx for that
Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
I hope day 23 through day 700 are easier (one assumes/hopes that after 2 years the habit should be eliminated)
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Mycroft Holmes wrote: (one assumes/hopes that after 2 years the habit should be eliminated) I think that for some things it will never be eliminated. It just takes some less effort to continue clean.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Day by day Eddy. Good luck.
(Thank god I checked - that originally read ‘Good lick’)
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
Nice to hear it. Welcome back.
Keep going
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Luckily I can't relate.
Good luck!
|
|
|
|
|
Great! Just hang in there. One day at a time.
Nothing worthwhile is easy.
ed
|
|
|
|
|
When I was in high school, I was selected to take a field trip to Vanderbilt University in Nashville Tennessee where I was given access to research department personnel researching drug addiction. The primary physician told me that certain addictions form due to the brain forming receptors for the specific drug. Once formed, these receptors never go away and send signals to the rest of the brain that cause the cravings. He stated that these signals equivalate to someone dying of thirst. It takes true will power to overcome these cravings, so anyone who can accomplish this can be considered to be extraordinary.
That says a lot about you Eddy. Hang in there!
"When you are dead, you won't even know that you are dead. It's a pain only felt by others; same thing when you are stupid."
Ignorant - An individual without knowledge, but is willing to learn.
Stupid - An individual without knowledge and is incapable of learning.
Idiot - An individual without knowledge and allows social media to do the thinking for them.
modified 19-Nov-21 21:01pm.
|
|
|
|
|
Tx, also for sharing the story
Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Congratulations !
«The mind is not a vessel to be filled but a fire to be kindled» Plutarch
|
|
|
|
|
Hello Eddy.
Best wishes to you in your quest. I'm sure what you have accomplished was quite difficult.
Congrats!
|
|
|
|
|
I'm trying to make sure that we've removed all references to several deprecated columns from a large number of stored procedures. Unfortunately one of the columns being nuked is an FK to a widely used table; meaning that text searches like the below sproc and up returning a lot of false positives for instances of OtherTable.TableNameId when all I'm interested in are references to TableIwantToRemoveTheColumnFrom.TableNameId .
select OBJECT_NAME(object_id), [definition]
from sys.sql_modules
where [definition] like '%TableNameId%'
That culls the list of files I'd need to manually examine from >100 to several dozen. it is at least a bit of a start; but is still a lot of painful manual review, and far worse than the application code/ Intellisense has let me confirm that the only remaining references to the old value there are the data migration functions and a few spots where existing values need to be nulled out so FK constraints don't blow up when doing deletes. (All of which is safe to remove from the C# once the final DB nuking is done.)
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
Abandon all hope, ye who code here...
Software Zen: delete this;
|
|
|
|
|
The best I can think would be to script out the culled list to text files and use something like Agent Ransack which shows matched words and surrounding content. Good luck!
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
|
unfortunately not. I suspect whatever is used to fill the result dialog does have what I'm looking for; but as is all it tells me is that most tables in the system have a dependency on the users table (created/updated by fields so they have userId FKs); but not what column the dependency is on so I could filter it by the one I want to get rid of.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
You need to add a few joins to make it useful.
Here's something I found on SO and modified for my own use:
USE MyDatabase
DECLARE @SchemaName nvarchar(128) = 'dbo'
DECLARE @TableName nvarchar(128) = 'TableWithColumnToRemove'
DECLARE @ColumnName nvarchar(128) = 'ColumnToRemove'
;
SELECT SCHEMA_NAME(o1.schema_id) + '.' + o1.name ReferencingObject
,SCHEMA_NAME(o2.schema_id) + '.' + ed.referenced_entity_name ReferencedObject
,c.name ColumnName
,o2.type ReferencedObjectType
,o1.type ReferencingObjectType
FROM sys.sql_expression_dependencies ed
JOIN sys.objects o1 ON ed.referencing_id = o1.object_id
JOIN sys.objects o2 ON ed.referenced_id = o2.object_id
JOIN sys.sql_dependencies d ON ed.referencing_id = d.object_id
AND d.referenced_major_id = ed.referenced_id
JOIN sys.columns c ON c.object_id = ed.referenced_id
AND d.referenced_minor_id = c.column_id
WHERE 1=1
AND SCHEMA_NAME(o2.schema_id) = @SchemaName
AND o2.name = @TableName
AND c.name = @ColumnName
ORDER BY ReferencedObject
,c.column_id;
modified 14-Oct-21 10:33am.
|
|
|
|
|
Thank you, that looks like it does exactly what I was looking for.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
If this isn't a programming qvestion, I don't know what programming is ...
|
|
|
|
|
I'm on the fence about it.
There are two things I'd like to know.
Who among you has installed it, and what do you think?
Also, is the free upgrade to Windows 11 time limited? Do I have to get it while the getting is good, or can i sit on it for 3-6 months?
Real programmers use butterflies
|
|
|
|
|
Installed, not overly impressed. I like the new setup (as in Control Panel) format, but that and rounded corners is about all I've noticed so far. I'd stick with 10 for now, especially if you have an AMD CPU.
As far as I've heard, there isn't a time limit on the upgrade. I'm sure it will get louder and louder, but not switch to pay. I could have missed it though. I'm pretty much out of the loop these days.
TTFN - Kent
|
|
|
|
|
Thanks!
Real programmers use butterflies
|
|
|
|
|
I saw yesterday that my Win10 (in AMD) told me, my PC is not suitable for Updating to 11.
I drunk a glass of Champagne
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|