Offhand, the best way I have found to search for it is to use SQL Search OR to script out all of the jobs and do a search in those. ...

Yeah, I wasn't saying it was "good", it is just what it was doing.  I prefer the "WHERE (A=@a) OR (@a IS NULL)" approach myself... and depending on how often...

if @Parameter3 is null, then use table1.id2.

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 3 years, 9 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...