Viewing 15 posts - 1 through 15 (of 70 total)
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...
January 23, 2024 at 5:42 pm
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...
January 22, 2024 at 11:28 am
Guess I am going to change these for consistency and let the catalogs rebuild just for peace of mind that all looks OK.
January 12, 2024 at 5:21 pm
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...
December 29, 2023 at 4:25 pm
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...
May 9, 2023 at 8:10 am
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...
May 8, 2023 at 10:29 am
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...
March 25, 2023 at 11:05 am
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...
March 25, 2023 at 9:40 am
Here is the output from the query invoked as above :
ItemID AccountID RecordSeriesID
163093810 111889 NULL
163840777 111889 NULL
163876831 111889 ...
March 23, 2023 at 10:08 pm
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,...
March 23, 2023 at 10:03 pm
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...
March 23, 2023 at 9:38 pm
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...
March 19, 2023 at 9:20 am
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...
March 18, 2023 at 1:18 pm
Thanks Federico - I recall being told long ago that this was set at Instance level - I just checked using that link and compress backups is ticked. I do...
February 12, 2023 at 3:35 pm
OK - found a bit more - here is a snip from the History for the Maintenance Plan (Backup step)
BACKUP DATABASE [DBAUtilities] TO DISK = N''O:\Backups\Daily\DBAUtilities\DBAUtilities_backup_2023_02_11_053151_2683033.bak'' WITH NOFORMAT, NOINIT, NAME...
February 12, 2023 at 12:43 pm
Viewing 15 posts - 1 through 15 (of 70 total)