Viewing 15 posts - 46 through 60 (of 2,917 total)
I can't see the article, but with the premise I think it, like all things with a DBA, depends. If I am building a life support system and it is...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 26, 2025 at 7:42 pm
I personally prefer the dynamic SQL IF you are working with changing table structure as then if you add or remove a column you don't need to add or remove...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 20, 2025 at 7:12 pm
another approach, although will become messy if there are a lot of columns, would be to have 1 "master" stored procedure that takes the parameter (such as fpartno in your...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 14, 2025 at 10:21 pm
Well, MSSQL has several mechanics that can do something similar.
If you want to run a huge SELECT but don't care about the results open the Query Options go to...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 12, 2025 at 3:22 pm
I am a fan of having things like "current" or "latest" with the expectation that I will rename it when a newer version comes out. Where possible, I like having...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 7, 2025 at 9:46 pm
I like CDATA as a concept, but it is an expensive tool for sure AND it still requires other tools to do the heavy lifting. If you want the ODBC...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 6, 2025 at 3:53 pm
Is the different domain in the same AD forest? If so, then you should be able to authenticate across and see the other servers and everything should just work. If...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 5, 2025 at 10:26 pm
One more thing - make sure the ODBC DSN that you are using is the correct bitness (32-bit vs 64-bit). If the app is 32-bit, then it MUST be the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
October 29, 2025 at 8:52 pm
Speed of the SSD and network latency will determine the maximum performance of the SQL instance. My understanding, if the network latency is 1 second and the SSD speed is...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
October 29, 2025 at 6:45 pm
My opinion - if E2 is running on a SQL Server backend, why reinvent the wheel? Use SSIS for your ETL.
If that isn't an option for one reason or another,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
October 29, 2025 at 6:33 pm
Maybe this is over-simplifying the problem, but is there any reason why you can't connect directly to the data source?
In my experience, the more hoops your application has to jump...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
October 28, 2025 at 9:03 pm
Just my opinion, but systems with "variable mass systems" such as rockets, comets, fluid ejection, or systems with dynamic mass exchange, I am not sure what this model helps with....
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
October 23, 2025 at 7:43 pm
I'd be hesitant to use floats personally. Main reason is that floats and reals are approximate values. See this link
PLUS if you are REALLY needing a NUMERIC(30,10), the CAST...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 19, 2025 at 7:39 pm
We actually use DH2i for handling our HA/DR, but we are only hosting a few instances in that failover - roughly 30 across all of our servers - and it...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 18, 2025 at 7:42 pm
I don't think this is a problem with "rounding" but a problem with "precision". SQL has complicated logic around precision. The below is taken from here
The...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 18, 2025 at 5:49 pm
Viewing 15 posts - 46 through 60 (of 2,917 total)