Viewing 15 posts - 2,311 through 2,325 (of 2,648 total)
I've had to query the CounterData table before.
I use LEFT(CounterDateTime, 23) and it works ok.
I think the 24th character is something like a file terminator.
August 10, 2018 at 9:37 am
I'm testing some new backup processes here (a weekly job and a daily job).
I...
August 10, 2018 at 6:09 am
August 9, 2018 at 8:39 am
August 9, 2018 at 5:38 am
You could try adding some indexes. See if any of these makes a difference:CREATE INDEX IX_PhoneBook_PhoneBookID ON dbo.PhoneBook(PhoneBookID);
CREATE INDEX IX_TagTable_PhoneBookID ON dbo.TagTable(PhoneBookID);
CREATE INDEX IX_TagTable_TagBaseID ON dbo.TagTable(TagBaseID);
CREATE INDEX IX_TagBaseTable_TagBaseID...
August 9, 2018 at 4:52 am
August 9, 2018 at 4:33 am
August 8, 2018 at 8:41 am
Hi experts,
The stored procedure executes only with the Warning. But when it executes from the...
August 8, 2018 at 6:32 am
Using VM's and SANS, is there any...
August 8, 2018 at 6:07 am
DECLARE @Increment Int = 0 -- or -1
SELECT
CT.claim_type_name AS ClaimType,
COUNT(CM.claim_type)...
August 8, 2018 at 5:34 am
August 8, 2018 at 2:15 am
August 7, 2018 at 8:39 am
August 6, 2018 at 1:48 pm
Putting the semicolon at the beginning of a CTE is my biggest pet...
August 6, 2018 at 1:16 pm
Viewing 15 posts - 2,311 through 2,325 (of 2,648 total)