Viewing 15 posts - 496 through 510 (of 2,917 total)
To play Devil's advocate, I would say it really depends. If you are currently employed, what does your employer use? I know at my workplace, we are not using SSAS...
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, 2023 at 6:06 pm
We have a policy at our company that the C# code must call stored procedures to get or manipulate any data. It gives us better tuning opportunities and allows us...
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, 2023 at 6:00 pm
I agree with Jo Pattyn - this looks like a duplicate of that other question and my advice is still the same. If you want to track changes, you need...
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 3, 2023 at 9:21 pm
First question I'd ask is "what problem are you trying to solve by putting the Excel data into SQL Server?". How will putting the data into SQL Server help you?
But...
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 3, 2023 at 9:13 pm
DBA's should be involved in database design (my opinion)... otherwise what is stopping a developer from making tables that are not normalized or using bad datatypes (TEXT for example)... Makes...
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 3, 2023 at 8:58 pm
Every time I have seen "Attempting to use an NT account name with SQL Server Auth" it means that my SQL instance is set up for Windows Authentication (instead of...
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 3, 2023 at 3:07 pm
To me that is a good argument to move it from MySQL to MSSQL. That is one of the use cases where I'd do the migration.
As for the database schema,...
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 3, 2023 at 3:02 pm
This is actually pretty easy to do and Microsoft even has a writeup on it:
The steps are:
In the tablix data region row group area, right-click a cell in the column...
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 3, 2023 at 2:43 pm
@ScottPletcher I do agree that triggers and CDC are not necessarily performance killers, but they do impact performance. I haven't set up CDC, so I am not sure what 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.
November 3, 2023 at 2:32 pm
If memory serves, CDC is not trivial to set up and it can be a performance suck as well.
My opinion is still that targeting the stored procedure or application code...
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 2, 2023 at 7:42 pm
To add to what Ant-Green suggests (dumping to flat files), that also would allow you to build a proper schema for it. I've seen some of the automated tools for...
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 2, 2023 at 5:54 pm
My opinion, the easiest way to set this up (as a SHORT TERM thing) would be an after update trigger then. I say short term as triggers are "hidden problems"...
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 2, 2023 at 5:44 pm
Might not hurt to ask about the new security policy and let them know that you are having issues complying to the new security policy due to how SQL Server...
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 31, 2023 at 10:17 pm
Another thing to check is the logs. Look at the security logs on the server XXX. Chances are something will be in the log like "access denied".
Also, with it working...
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 31, 2023 at 5:48 pm
One approach I can think of to this is to have the end users insert their job request into a table. Then you have a SQL job that runs every...
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 31, 2023 at 5:41 pm
Viewing 15 posts - 496 through 510 (of 2,917 total)