Viewing 15 posts - 1,441 through 1,455 (of 2,917 total)
I'll answer things in order.
1:
Honestly, I am not certain what DTL format is, but if you need another tool to convert that to CSV, then it really depends on if...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 24, 2020 at 2:59 pm
A nice easy one for Christmas!
Merry Christmas to you and yours as well! And thanks for all the great QOTD's!
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 24, 2020 at 2:36 pm
Heh, I enjoy being called:
1 - brain
2 - clever
I feel smart! S-M-R-T. But Phil is correct - I prefer being called Brian.
But yes, I think that using CTE's and DATEADD...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 23, 2020 at 7:50 pm
Not from me. I've never configured scale out for Polybase, or anything for that matter. My systems are pretty lightweight and I've not had a need for it.
My advice -...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 23, 2020 at 3:56 pm
To me this seems like a weird request, but there are a few things I am unclear on with it. First, does this need to be in a while loop? ...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 22, 2020 at 10:13 pm
To answer your questions:
1 - SQL (via SSIS) or C# can pull data from a CSV file (and multiple other formats) into SQL Server
2 - You can create as many...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 22, 2020 at 2:35 pm
If Microsoft does go this route, I am all for it, but they would need to be careful with it too.
Thing is some of that is already possible. Parallel job...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 21, 2020 at 9:59 pm
First, I'd be looking at getting onto a newer SP for SQL 2008 R2... that thing is pretty old and out of mainstream support.
Next, I'd be asking a few questions:
1...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 21, 2020 at 7:25 pm
The error you listed to me looks like an error from Windows service manager (or SQL Server Configuration Manager), not from Polybase. I would check the log files and/or windows...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 21, 2020 at 6:00 pm
I would just like to add that if Die Hard is a Christmas film, so is Batman Returns which is on my watch list this Christmas.
Happy Holidays to everyone!
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 21, 2020 at 5:14 pm
What do the logs say? They will very likely tell you exactly why it can't start the service.
Without seeing any logs, my first thought is permissions. Does the Polybase service...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 21, 2020 at 4:56 pm
That is odd that it works fine in the web browser and in MS Word, but not PDF. This makes it sound like the tool that is creating that PDF...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 17, 2020 at 9:28 pm
Like Jeffrey, I would be cautious about removing sysadmin via an automated task. One typo in that script and you could blow out all sysadmins.
Permissions are something I prefer not...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 17, 2020 at 9:23 pm
I do not have one of those, but I am pretty sure they are essentially just HID's (human interface devices) in Windows and LIKELY is simply a mouse-emulator
I have a...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 17, 2020 at 9:14 pm
I would reach out to Microsoft on this one as it sounds like a bug that they will need to fix.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 17, 2020 at 7:44 pm
Viewing 15 posts - 1,441 through 1,455 (of 2,917 total)