Viewing 15 posts - 871 through 885 (of 2,917 total)
One thing about the CPU - a lot of SQL Server operations are single-threaded, so having a lot of cores may not benefit you. There are exceptions (as queries can...
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.
October 28, 2021 at 3:05 pm
hahaha... no, that isn't what I meant Grant... I am going to edit that to be 99% agree with that.
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.
October 27, 2021 at 9:53 pm
To me this sounds pretty easy to do and I expect there are multiple solutions, but my approach would be to break it up into multiple steps for the sake...
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.
October 27, 2021 at 5:56 pm
I 99% agree with Grant (that is not one ugly dude). In-person events get you so much more interaction and discussion than virtual. Both from the presenter side and from...
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.
October 27, 2021 at 2:49 pm
My opinion - this is the wrong site for that. This is a SQL Server forum, not an SEO forum.
My best guess though as to why some newly published blog...
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.
October 27, 2021 at 1:41 pm
Your story sounds a lot like mine, except I don't lead a team... I'm just a member of a team of 3 DBA's who do non-DBA things (like development work)...
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.
October 26, 2021 at 7:24 pm
Getting sp_executesql to work is pretty easy.
DECLARE @sql NVARCHAR(MAX)
SELECT @sql = '<insert dynamic SQL here>'
EXEC sp_executesql @sql
The only thing that makes your query a bit more tricky...
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.
October 26, 2021 at 5:37 pm
Quick google of this brought me to this link:
Which basically says you cannot do it because SQL is expecting a static number of columns to be returned, but a semi-dynamic...
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.
October 26, 2021 at 3:34 pm
I agree with Grant's first statement - that is asking for trouble and can be a scary practice... and if you read his signature, he is The Scary DBA!
Why it...
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.
October 26, 2021 at 3:14 pm
NOTE - I am not an LDAP expert, but the following is my understanding of how the authentication chain works.
I think this was answered previously and my answer was that...
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.
October 26, 2021 at 3:07 pm
My opinion - test it out.
Upgrading from 2008 R2 to 2019 MAY require upgrading your OS as well and, if I remember right, 2019 doesn't support 2008 compatibility mode.
What I...
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.
October 26, 2021 at 2:59 pm
I wasn't sure if the Browser service was required for the default instance on port 1433 or not, but I generally start the browser service as soon as I install...
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.
October 26, 2021 at 2:50 pm
As I said multiple times - Firewall. Just because port A is open in the firewall and you can connect to SQL instance B doesn't mean that port C is...
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.
October 25, 2021 at 3:29 pm
First, I think you would likely get better support on a MySQL forum than a SQL Server forum.
Second, my understanding of MySQL is that it keeps the temporary tables in...
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.
October 25, 2021 at 3:26 pm
I think there are multiple approaches to this, but if it was me, I would start by trying to define the problem you are trying to solve rather than starting...
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.
October 25, 2021 at 2:28 pm
Viewing 15 posts - 871 through 885 (of 2,917 total)