Viewing 15 posts - 1,246 through 1,260 (of 2,917 total)
I'd have a read on this page:
But basically, "alter table <tablename> rebuild" will rebuild your heap.
Does that table need to be a heap or would it benefit from an index?
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.
April 27, 2021 at 7:49 pm
Just to confirm, if you log into the server while the job is running and load up task manager, who does cscript.exe say it is running as?
The reason I ask...
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.
April 27, 2021 at 5:42 pm
Just my opinion, but do you need ALL of the ERP data?
The reason I ask is if you aren't needing all 130 GB of data, it MAY be faster 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.
April 27, 2021 at 5:19 pm
What is likely happening is sys.tables is getting a lock due to the SELECT * INTO TableName which would create the table AND do a select in a single transaction...
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.
April 27, 2021 at 4:57 pm
Making a guess here, but is that a TABLE or a VIEW or STORED PROCEDURE? I am just trying to imagine designing a system that will alter a table 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.
April 27, 2021 at 4:40 pm
What about UNC path vs drive letter or is the file stored locally?
As another thought, are you using the 32-bit driver or the 64-bit driver?
This is the link I found...
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.
April 26, 2021 at 4:55 pm
Another option (others may shoot this down as a bad idea) would be to turn on filestream access on the folder and have the SQL side mostly pulled out 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.
April 23, 2021 at 9:53 pm
I second Ken's approach. I like having my application logic at the application layer and my database logic in the database.
I would much rather have 2 stored procedures (pre java...
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.
April 23, 2021 at 8:33 pm
One other thing you will want to be certain of is that the drive letter doesn't change.
It USUALLY doesn't from a format, but I've seen Windows do stranger things before.
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.
April 23, 2021 at 8:25 pm
CXCONSUMER was introduced in SQL Server 2017 CU3. 14.0.2037.2 is NOT CU3.
you are not "patched to current" as current SQL Server 2017 is CU23 which is version 14.0.3381.3
Even CU3 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.
April 23, 2021 at 5:31 pm
I agree with you 110%!
I almost always use CTE's over nested selects. I find them easier to read and easier to test and debug. "SELECT * FROM <cte name>" after...
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.
April 23, 2021 at 4:08 pm
From my experience, nested selects vs CTE's have had very similar performance.
If you have a SQL formatting tool (such as RedGate SQL Prompt or ApexSQL Refactor), I would start by...
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.
April 23, 2021 at 3:00 pm
Your XML ends with:
<InterfaceDefinition><id>Radio
so right away, I see that id and InterfaceDefinition are both unclosed. I expect these are not root level XML tags, so you probably have more that...
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.
April 23, 2021 at 2:04 pm
Quick look at your code, your XML is missing closing tags, so it is malformed XML and as such cannot be cast to XML.
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.
April 22, 2021 at 6:12 pm
My opinion for process - install it on test, test the crap out of it, if no fault found, install on live.
As for "should" you install it? I would. SP2...
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.
April 22, 2021 at 6:11 pm
Viewing 15 posts - 1,246 through 1,260 (of 2,917 total)