Viewing 15 posts - 286 through 300 (of 2,917 total)
Why would it? Your dynamic SQL starts with a select, so the quiet getting executed is a select. You would want something more along the lines of
Select...
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 20, 2024 at 1:44 pm
I think I misrepresented the "Database Owner" role and the database "owner". "Database Owner" is a role. The database "owner" is the person who created the database. Multiple people can...
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 19, 2024 at 3:16 pm
As a guess, I imagine a few joins could help and no loop would be required.
BUT It depends on how you designed things. Is that 4 tables? If so, I...
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 19, 2024 at 3:08 pm
It depends. Is your powershell script calling a SQL script to handle the backups or are you using a 3rd party backup solution or powershell itself for the backups.
My approach...
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 19, 2024 at 2:54 pm
Actually Application is stable and live since many years and such kind of issue happened only few times. I am still trying to find anyway I can see 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.
April 19, 2024 at 2:49 pm
Yes, my bad, but on the other hand when one 1 person works on one DB is not going to be able to run multiple Queries, usually you 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.
April 19, 2024 at 2:34 pm
Looks like you are going to need to use dynamic SQL and you are going to have a bad time with that I fear. Why? because what happens if someone...
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 17, 2024 at 8:50 pm
With regards to your "what can a database owner" do, google is your friend there. But to summarize, DBO can do anything on the database level. You can access 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.
April 17, 2024 at 8:47 pm
Each INSTANCE of SQL Server would have it's own tempdb. I think Martin's suggestion was to have a single INSTANCE with multiple DATABASES. This would end up sharing the same...
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 17, 2024 at 8:02 pm
My opinion - where I work we started with the development team being in a room on their own with low noise (little bit of chats between the 20-ish developers...
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 17, 2024 at 2:57 pm
If I had to guess, whoever designed that was truncating the table then looking at the statistics for that table and seeing that the statistics indicated there were rows in...
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 17, 2024 at 2:37 pm
I am 99.9999999999% sure that the problem is not on the SQL side - that is an application bug. SQL takes a query and provides results. There is literally no...
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 17, 2024 at 2:21 pm
My opinion - that's pointless. Statistics tell you information about your table data. If the table is empty, the statistics are (mostly) useless. You need data in the table 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.
April 16, 2024 at 10:05 pm
100% agree with Drew here and in your specific scenario, JOIN may perform better or worse. My advice is to test on your system as is (ie don't add extra...
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 16, 2024 at 6:34 pm
With desktop versions of windows, if you see 90%+ memory being used, (14.5/15 GB), that is a good sign stuff is being paged to disk. Windows tries to not let...
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 15, 2024 at 6:03 pm
Viewing 15 posts - 286 through 300 (of 2,917 total)