Viewing 15 posts - 766 through 780 (of 2,917 total)
The way I would do it is similar to this:
DECLARE @test1 DATE = GETDATE()
DECLARE @test2 TIME = GETDATE()
SELECT @test1, @test2, CAST(CAST(@test1 AS VARCHAR(255)) +' '+ CAST(@test2 AS...
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.
December 10, 2021 at 8:57 pm
That last bit is EASY to fix - trim your strings:
SELECT PARSENAME(TRIM(@statement), 1)
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.
December 10, 2021 at 8:51 pm
What I would check, and what I expect the problem is, is the "Package" tab. What is probably happening or happened is that the SQL instance you are configuring 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.
December 10, 2021 at 7:13 pm
I have a few thoughts on this.
First - is this consistently returning the same number of rows? Like if you run the query 10 times do you always get 1035...
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.
December 10, 2021 at 7:05 pm
I agree with Fredrico_Fonseca on the performance question - it depends on a LOT of factors and the EASIEST way to know if it helps or not is to test...
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.
December 10, 2021 at 2:09 pm
As a thought - is it a native backup or a 3rd party tool (like redgate) backup? Is the backup encrypted? Can you restore the backup to another 2012 STD...
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.
December 9, 2021 at 10:07 pm
One option you could do (probably not ideal, but a possibility) would be to use something like the scripting agent in SSIS to open the file in excel (hidden window)...
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.
December 9, 2021 at 5:35 pm
That I am not 100% certain on, but in my opinion - I would buy some sort of SQL monitoring tool. It will let you know when a deadlock occurs...
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.
December 9, 2021 at 4:56 pm
My opinion - this is likely not a database issue, but possible a configuration issue.
BUT to rule out database, I would do a dbcc checkdb to make sure nothing 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.
December 9, 2021 at 4:00 pm
The other bit of "fun" with that, on top of what ZZartin siad, is that the TLOG may be in use by other queries that could be inserting, updating, or...
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.
December 8, 2021 at 7:11 pm
Yep - you see that greyed out "script" button? Click on a checkbox then click on the script button then cancel out of that window.
That script button will tell you...
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.
December 7, 2021 at 9:20 pm
I am not certain what you mean by "access the checkbox" in TSQL code, but I am 99% sure that all configuration options within SQL Server for all available features...
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.
December 7, 2021 at 7:58 pm
Personally - I would not do this on the SQL side. The ONLY way I can think of to do this would be with dynamic SQL and to me 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.
December 7, 2021 at 5:54 pm
My opinion - every time I've seen an "unable to delete" error, or unable to copy, move, archive, etc, it has been due to disk failure. I would run a...
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.
December 7, 2021 at 2:16 pm
I wish my disk latency was down as low as 8ms... my lowest read stall is 11ms and the highest is 265869 ms; mind you that DMV is showing you...
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.
December 6, 2021 at 9:58 pm
Viewing 15 posts - 766 through 780 (of 2,917 total)