sp_whoisactive: Capturing the Output

https://whoisactive.com/docs/25_capturing/

I think that this shows why Phil's suggestion won't work sadly but may provide a solution for me.

I have a similar (same) issue.

It says on the online docs that the filters are 'additive' but when I try to filter on 2 values it errors.

I want to ONLY...

Honestly not fussed on the harshness of response if it contributes to moving the discussion forward - obviously meant in good humour.

It does sound like there are different opinions on...

Thanks all for the responses.

To address a few points -

I am told that the DB files are all on fast SSD - and know they are all in the same...

Guess I am going to change these for consistency and let the catalogs rebuild just for peace of mind that all looks OK.

This is one of the queries I run :

--USE[

--1) Is FullTextSearchEnabled in SQL Instance

SELECT

CASE FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')

WHEN 1 THEN 'Full-Text installed.'

ELSE 'Full-Text is NOT installed.'

END

;

--2 Is FullTextSearchEnabled in DB

SELECT name, Database_id, is_fulltext_enabled

FROM...

Hello Priyanka.

Thanks for the response.

The system is fairly quiet ( 1:00AM-4:30AM) - little resource being used by other work.

I have checked IO, CPU and Memory and the lack of Blocking...

Hello Federico - still waiting (impatiently) for feedback from the Business despite repeated requests. Once I get a definitive reply I will revert. Suffice to say that we implemented the...

Thanks Frederico - I don;t even know how you construct your responses so quickly, never mind understanding them fully.

Using a combination of the below I seem to have something that...

Hello Federico.

Thanks for the lengthy response.

I don't pretend to understand the proposed solution but I have tried it and it does not like the column in the Contains so I...

Here is the output from the query invoked as above :

ItemID        AccountID   RecordSeriesID

163093810 111889          NULL

163840777 111889           NULL

163876831 111889   ...

This is how the main function is called ;

SELECT * FROM

dbo.fn_GetMatchingItemsForGlobalSearchSOC('111889,111891,111899','12181', 3)

and this is the main function

ALTER FUNCTION [dbo].[fn_GetMatchingItemsForGlobalSearchSOC] (

@strAccounts NVARCHAR(MAX),

@strSearchString NVARCHAR(MAX),

@objectType INT )

RETURNS @MatchedItems TABLE (ItemID INT NOT NULL,...

Well having come up with all sorts of 'issues' and various workarounds (including trace flags and db compatibility levels) it transpired that this code is just an extract from a...

Hello Emperor100 and thanks for the reply.

Having fed back my findings last night I was informed that the INNER JOIN was never in fact in the original query, and was...

DECLARE @Accounts Table (accountid INT)

INSERT INTO @Accounts

VALUES( '111889' ), ( '111891' ), ('111899')

SELECT AccountID FROM @Accounts

SELECT Distinct I.ItemID, I.AccountID, I.RecordSeriesID

FROM RSSQLDB.dbo.RSITEM I (NOLOCK) cross apply @Accounts

WHERE

I.BaseObjectID = 3

AND I.AccountID IN...