Forum Replies Created
Viewing 15 posts - 751 through 765 (of 2,917 total)
-
Reply To: Slow Query On SQL 2019
My first step would be to load up the execution plan on both systems and make sure they look similar, if not identical.
Next, I would check for blocking while your...
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. -
Reply To: Multiple Parameters
I am a bit confused why this is dynamic SQL and what you are trying to do. You have 2 stored procedures that appear to be unrelated. The first uses...
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. -
Reply To: Applying SQL Server 2019 CU 14 cause's master database corruption
As a thought - is your master database valid (ie not corrupt) prior to installing that update? I would run checkdb on it and verify that it is valid 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. -
Reply To: if condition not working
Is that your entire stored procedure or did you strip something out? It looks to me like you are missing a 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. -
Reply To: Case Statement in where
My understanding, it won't work QUITE like that. BUT what you could do is something like:
SELECT Itemcode,Itemname,ItemGroup
FROM tbl1
WHERE (itemgroup IS NULL and @ItemGroup IS NULL)
...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. -
Reply To: Getting error 64 when trying to connect to the AdventureWorksLT database
DISREGARD THIS POST
I agree with Grant - you shouldn't need to do anything with the Antivirus. I also agree that it is likely going to be firewall related on either...
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. -
Reply To: Using EE to trace the code generated by an app
Sometimes it is good having a lot of detail, sometimes people are looking for a "quick and easy" answer and my detail just gets skimmed or ignored.
The XE trace will...
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. -
Reply To: Using EE to trace the code generated by an app
Do you have access to the source code behind the GUI? If so, I would tackle it on the GUI source side of things NOT on the database side 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. -
Reply To: Production setup of SSRS
I think a lot of it falls under "it depends". IF you have the licenses, I would recommend putting it on a separate machine. BUT SSRS needs a SQL license...
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. -
Reply To: Arithmetic overflow error converting expression to data type smallint
My opinion - I would try your query as just a SELECT without the CAST and see what you get back, as well as selecting all values in that CTE.
If...
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. -
Reply To: Arithmetic overflow error converting expression to data type smallint
Could you post your code and sample data and DDL?
You are doing something that the query optimizer thinks will be a SMALLINT, but that being said, 0.0000005328 WILL successfully cast...
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. -
Reply To: Restore error on Page[0.0]
My opinion, if you want to toss the full backup on onedrive in smaller chunks, I would include MD5's with the backups.
I am a bit confused what you mean 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. -
Reply To: T-SQL Error: Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '('.
I can't say with 100% certainty the cause of the error, but to me that doesn't look like TSQL.
What I mean is the $ part and ESCAPE_NONE. I don't know...
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. -
Reply To: Mobile DBA Tool for Android
wilsonhopper wrote:SQL BrainBox wrote:Has anyone used Brain Box SQL app for Android in the google play store?
What do you think?
I've been using it to connect remotely to my SQL Servers via...
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. -
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format
DaveBriCam wrote:I think we may be on the right track but my data isn't presenting correctly. I'm getting (although the seconds are not visible, they are incorrect):
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.
Viewing 15 posts - 751 through 765 (of 2,917 total)