Viewing 15 posts - 1,936 through 1,950 (of 2,643 total)
@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
Declare you variables, and populate them:DECLARE
@BULKID varchar(50) = 5006,
@BAN varchar(50) = null,-- '955932237',
@FROM_DATE date = NULL,
@TO_DATE date = NULL,
@IMEI varchar(100) = NULL
Create a temporary...
November 27, 2018 at 7:07 am
;WITH myTable AS
(
SELECT * FROM (VALUES(1001), (1001), (1002), (1002), (1003), (1003), (1004), (1004), (1005), (1005),
(1006), (1006), (1007), (1007), (1008), (1008), (1009), (1009),...
November 26, 2018 at 10:46 am
Viewing 15 posts - 1,936 through 1,950 (of 2,643 total)