Viewing 15 posts - 1,936 through 1,950 (of 2,645 total)
November 30, 2018 at 3:39 am
Yes! @jonathan-2 AC Roberts I was just heading over to add the Force Seek to...
November 29, 2018 at 7:57 pm
@frederico_fonseca , @jonathan-2 AC Roberts and ChrisM@Work
(1)
Corrected
FROM DistributionCenterFeed.[dbo].[QR_Device_Trade_In_Master_2016onward] QR
WHERE QR.[Offer_Generate_Date] >= @FROM_DATE...
November 29, 2018 at 4:48 pm
@jonathan-2 AC Roberts
I used Generate Scripts to script out all indexes created for this table,...
November 29, 2018 at 9:54 am
FROM [#Assurant Manufacturer Received] QR
WHERE QR.[Offer_Generate_Date] BETWEEN...
November 29, 2018 at 9:31 am
November 29, 2018 at 9:25 am
Hi polkadot,
You said the query only returns 9 rows. This means you should be ok to put hints to force usage of the indexes.
Make sure you have indexes...
November 29, 2018 at 9:03 am
Need index suggestion for the below query which can improve the performance. (Assume...
November 29, 2018 at 7:51 am
TRUNCATEONLY will only shrink the file if it has free space at the end of the file.
You could try to shrink it several times reducing the size by a...
November 28, 2018 at 10:09 am
November 28, 2018 at 9:57 am
;WITH myTable AS
(
SELECT *
FROM (VALUES ('A',2, 'this is a short string no need to split'),
...
November 28, 2018 at 9:35 am
November 28, 2018 at 7:27 am
November 28, 2018 at 7:18 am
November 27, 2018 at 1:46 pm
November 27, 2018 at 8:53 am
Viewing 15 posts - 1,936 through 1,950 (of 2,645 total)