Viewing 15 posts - 1,216 through 1,230 (of 2,917 total)
Anything interesting in the logs? That is usually where I start all of my troubleshooting. SQL Server logs as well as the Windows logs. Never know where it may be...
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.
May 10, 2021 at 9:02 pm
I was doing some digging into this and best I can tell there is no way to do it without looking for a "\" in the ServerName field. And this...
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.
May 10, 2021 at 7:03 pm
I would recommend running a chkdsk on it (and DBCC once you get it online). It could be that there was some corruption on the file/folder around permissions. So when...
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.
May 10, 2021 at 5:30 pm
phpmyadmin, if I remember right, is an administration tool for PHP. This, if I remember right, does not care about your database. I think it can connect to a database,...
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.
May 10, 2021 at 5:20 pm
OH... you want 1 contents.txt per directory. That gets a bit more complicated, but still pretty easy in Powershell. Basically, you will need to start by getting the directory list...
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.
May 7, 2021 at 7:09 pm
One thought (may not be possible) but what about using a windows account rather than a SQL account?
If that is not an option, SQLCMD can execute TSQL against a SQL...
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.
May 7, 2021 at 4:53 pm
It looks like you have the code already. Just append "> Contents.txt" to the end of it.
If you don't want powershell, bat file can do it too with "dir /s...
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.
May 7, 2021 at 2:26 pm
It's all good! Not sure if I've been mistaken for Pietlinden before, but I know my opinions on query hints are that they should be avoided.
And I agree about getting...
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.
May 6, 2021 at 10:28 pm
I can't speak on how ETL developer compares to SQL Developer in terms of level. They are 2 different roles from my understanding.
The benefit of branching out is you get...
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.
May 6, 2021 at 9:57 pm
My opinion with regards to performance - test it out!
In theory, one method may be faster than the other. In practice, this can surprise you. Sometimes the statistics and indexes...
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.
May 6, 2021 at 9:17 pm
Without having sample data, it is tricky to say for certain, but as a thought - would a DISTINCT on your SELECT help?
If not, could you provide some DDL and...
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.
May 6, 2021 at 7:30 pm
Scott - I am not sure if you saw my most recent reply where I basically retracted my previous statements on NOLOCK. It was a bit of a ramble and...
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.
May 6, 2021 at 6:20 pm
I think the first thing I'd ask is - what problem are you trying to solve?
Having an index highly fragmented MAY cause performance issues, or may be perfectly fine. Are...
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.
May 5, 2021 at 8:24 pm
Another thought (as I ran into a similar issue when working with Great Pains... I mean Great Plains) - try setting your MAXDOP on that query to 1. We had...
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.
May 5, 2021 at 5:01 pm
How are you mapping "REG1" to "SICK1" and REG2 to SICK2? You would need something to JOIN on.
Using the data you have given, I see no way to map those...
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.
May 5, 2021 at 4:59 pm
Viewing 15 posts - 1,216 through 1,230 (of 2,917 total)