Viewing 15 posts - 826 through 840 (of 8,760 total)
December 26, 2018 at 3:45 am
December 24, 2018 at 8:49 am
Using GO [EXEC COUNT] is neither a realistic nor accurate way of testing as the execution overhead is far higher than the actual statement cost.
😎
Here is...
December 24, 2018 at 4:26 am
In the following test query first INSERT statment execution plan shows implicit conversion for ...
December 24, 2018 at 2:28 am
Heh... so you want to us to help you duplicate the grammatical and...
December 23, 2018 at 9:19 am
December 23, 2018 at 5:21 am
December 22, 2018 at 8:05 am
December 22, 2018 at 1:28 am
This might help you getting started
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @SAMPLE_DATA TABLE
(
ID INT NOT NULL
,[NAME] ...
December 22, 2018 at 1:11 am
December 21, 2018 at 5:50 am
December 21, 2018 at 4:16 am
Ignoring the obvious error in the desired results, here is one way of skinning this cat.
😎
USE TEEST;
GO
SET NOCOUNT ON;
December 21, 2018 at 4:13 am
December 21, 2018 at 2:29 am
Here is an example that should get you passed this hurdle.
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @TXML XML =...
December 21, 2018 at 12:22 am
If you are using a work table for the import, why not just add a calculated column for the conversion?
😎
USE TEEST;
December 20, 2018 at 11:22 pm
Viewing 15 posts - 826 through 840 (of 8,760 total)