Viewing 15 posts - 6,616 through 6,630 (of 13,876 total)
Here's a slightly different version:
DECLARE @DOB DATE = '20000101';
DECLARE @AgeYears TINYINT = DATEDIFF(YEAR, @DOB, GETDATE());
SELECT Age = (CASE WHEN @AgeYears <= 13 THEN 'Age less than 14'
...
September 29, 2016 at 2:15 pm
If you right-click on a project in SSISDB, and select 'Versions' you will see a list of previously deployed project versions (the maximum number of versions displayed will depend on...
September 29, 2016 at 7:31 am
Just got a spam e-mail that starts with this:
"I am the only Daughter of my late parents Mr and Mrs Nelson Smith. My father was a highly reputable business magnet...
September 29, 2016 at 5:37 am
Re1 (9/29/2016)
I am facing an issue with CozyRoc Table difference. It is passing Unchanged rows (same in both old and new) records into Updated rows (appear in both old...
September 29, 2016 at 5:33 am
See link.
September 28, 2016 at 1:33 pm
My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option.
I'm interested. Can you explain why, please, in a bit more...
September 28, 2016 at 11:09 am
GilaMonster (9/28/2016)
Phil Parkin (9/28/2016)
So I checked Tools/Options/Query Execution/SQL Server/Advancedand see that I have
SET XACT_ABORT
checked ... so that was doing the sweeping up for me.
You have the latest SSMS...
September 28, 2016 at 8:23 am
GilaMonster (9/28/2016)
Phil Parkin (9/28/2016)
The code does not even run.
It does (try it, you'll end up with @@TRancount of 1), because of deferred compile.
When the batch is parsed, the...
September 28, 2016 at 8:06 am
mcfarlandparkway (9/28/2016)
Researching like...
September 28, 2016 at 7:42 am
Rechana Rajan (9/28/2016)
Phil Parkin (9/28/2016)
Rechana Rajan (9/28/2016)
Phil Parkin (9/28/2016)
Rechana Rajan (9/28/2016)
September 28, 2016 at 7:38 am
I'd suggest that you try adding a merge hint to your MERGE. Start with HOLDLOCK and test ... moving up to TABLOCK if necessary.
You should also take steps to ensure...
September 28, 2016 at 6:50 am
Rechana Rajan (9/28/2016)
Phil Parkin (9/28/2016)
Rechana Rajan (9/28/2016)
September 28, 2016 at 6:43 am
Rechana Rajan (9/28/2016)
BEGIN TRY
...
September 28, 2016 at 6:32 am
quinn.jay (9/27/2016)
Phil Parkin (9/27/2016)
Such connections are not natively...
September 28, 2016 at 5:56 am
quinn.jay (9/27/2016)
Phil Parkin (9/27/2016)
1) Use the project deployment model,...
September 27, 2016 at 5:43 pm
Viewing 15 posts - 6,616 through 6,630 (of 13,876 total)