Viewing 15 posts - 1,291 through 1,305 (of 2,917 total)
I would load up extended events or profiler to see what is happening on the database side. What queries are being sent during the time the application is connecting 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 1, 2021 at 7:30 pm
Can you provide some DDL and a script we can run to reproduce your original results?
If not, one approach would be to do a self join on firstname, lastname, 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.
March 30, 2021 at 10:10 pm
That is a new one for me. If it is the exact same script, I would expect it to have the exact same results each time.
Any chance anything else has...
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.
March 30, 2021 at 10:06 pm
My guess (could be way out to lunch) is that your scripts are slightly different for the restore. What I mean is if you drop the database and recreate it,...
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.
March 30, 2021 at 7:37 pm
It is because of your aggregate function (SUM). Once you put in an aggregate function, you NEED to group by all non-aggregate columns that are in use. Otherwise SQL has...
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.
March 25, 2021 at 4:17 pm
Another thought is it could be parameter sniffing problem too. If user A passes in 'hello' as a parameter and user B passes in 'world', it could be that 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.
March 25, 2021 at 2:34 pm
That is a good point Grant and Fredrico. Optimizing a 2 ms query that is run once per year is wasted effort. Optimizing it when it is run 100's 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.
March 25, 2021 at 2:12 pm
As ratbak noted - Cursors are slow. Cursors work on a row by row basis rather than on the set of data. The more rows you have, the slower 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.
March 24, 2021 at 10:19 pm
I am just thinking if you have Python in SQL Server (can't remember if 2012 had that or not, but thinking it MAY have been a newer version that first...
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.
March 24, 2021 at 10:04 pm
To add to what Grant said, is there a reason you NEED that to be dynamic SQL? Quick look through it I don't see any reason for that to 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.
March 24, 2021 at 3:10 pm
Maybe I'm a bit unfamiliar with that level of XML, but to me that looks like it is XML that is expected to be read by a specific tool (svg?).
From...
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.
March 24, 2021 at 2:46 pm
Pretty sure you are going to be looking at parsing the XML to get the signature. You can do this with TSQL (which is where i would start). Once 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.
March 23, 2021 at 8:48 pm
I am sure there are a lot of ways, but my approach is to check each individually.
Perfmon will tell you quite nicely how much CPU SQL Server is using compared...
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.
March 23, 2021 at 7:25 pm
I think this falls under an "it depends" scenario. If the users are logging in with a generic account and that is all the information that SQL Server has, then...
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.
March 23, 2021 at 2:43 pm
Try changing the SQL Server Agent startup type to "automatic (delayed start)" to make it start after SQL Server.
I personally have never needed to do that, but I have with...
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.
March 23, 2021 at 2:37 pm
Viewing 15 posts - 1,291 through 1,305 (of 2,917 total)