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...

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...

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...

Is that your entire stored procedure or did you strip something out?  It looks to me like you are missing a FROM.

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) 
 ...

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...

• This reply was modified 4 years, 5 months ago by Mr. Brian Gale.

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...

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...

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...

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...

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...

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...

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...

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...

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):

December 13, 2021 at 2:09 pm

#3963068