Viewing 15 posts - 706 through 720 (of 5,109 total)
I'm curious - I've never had SSIS not work - what issues are you having?
SSIS on VS2019 is, currently, a mess. It's still in preview, and I really don't...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2019 at 4:19 pm
The whole VS SSIS/SSRS/SSDT is crappy.
They actually removed SSDT with VS 2019. There are now separate Extensions for Visual Studio and you are told (by the documentation) to download...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 29, 2019 at 4:28 pm
To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?
I, personally, suspect a while. SSDT 2017 supports SQL Server 2012-2019,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 29, 2019 at 3:55 pm
If you want to know what an If statement looks like, then the documentation is here: if-else (C# Reference). If you want to know how to use variables in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 29, 2019 at 9:29 am
This is the dynamic approach. note that because the variables (@t and @y) would only be accessible in the scope outside of the dynamic SQL, I have had to use...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2019 at 10:04 pm
Looks like you want a Dynamic Pivot. Have you had a go at this at all, or at least tried to pivot it without dynamic SQL? You'll learn a lot...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2019 at 7:50 pm
Hi Thom, How to approach such people issues. This is been like a habbit for the dev team to send out email to dba team to tune as their...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2019 at 9:06 am
date format 101 is mm/dd/yyy and therefore the answer is 4
'04'is less than '02'?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 28, 2019 at 8:45 am
The problem is the code that is "overly" using TempDB; you can't make TempDB use less space. Those that wrote the query need to fix it; if it's using 100GB...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 27, 2019 at 4:24 pm
Did the answer change from something else to 6?
Nope, it was always 6.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 25, 2019 at 8:39 pm
Look at the SQL Server logs and filter them to where Message contains the text "Login failed".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 25, 2019 at 4:15 pm
I need to upgrade to Windows 10 before year end because Microsoft are stopping Windows 7 security updates from January
You don't once mention upgrading your version of SQL Server though....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 25, 2019 at 3:38 pm
That isn't a failed login event you've posted.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 25, 2019 at 3:21 pm
Are you sure it doesn't tell you? A Login Failure will definately have those values. it'll look like this:
Login failed for user 'LoginName'. Reason: Could not find a login matching...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 25, 2019 at 2:41 pm
The answer depends on the data type of dbo.SalesHeader.OrderDate. If it's a datetime or similar then the answer is 6 as given. But if it's a varchar column then...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 25, 2019 at 10:47 am
Viewing 15 posts - 706 through 720 (of 5,109 total)