Viewing 15 posts - 706 through 720 (of 5,111 total)
That pretty much depends on the work place, in my opinion. But a Senior should be much more well versed in the T-SQL language, as well as how the data...
November 1, 2019 at 11:54 pm
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...
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...
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,...
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...
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...
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...
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...
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'?
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...
October 27, 2019 at 4:24 pm
Did the answer change from something else to 6?
Nope, it was always 6.
October 25, 2019 at 8:39 pm
Look at the SQL Server logs and filter them to where Message contains the text "Login failed".
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....
October 25, 2019 at 3:38 pm
That isn't a failed login event you've posted.
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...
October 25, 2019 at 2:41 pm
Viewing 15 posts - 706 through 720 (of 5,111 total)