Viewing 15 posts - 1,831 through 1,845 (of 2,917 total)
1 - An opportunity to meet and learn from experts in SQL and learn about new features in the Microsoft data platform
2 - An opportunity to talk to other data...
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.
June 19, 2020 at 5:35 pm
As a former UG leader and a speaker, I ran the user group more because it was fun to learn and meet other speakers. Getting free admission to PASS was...
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.
June 19, 2020 at 5:20 pm
Powershell and visual basic script.
You also say "C# NET", but really any .NET language (or even non-.NET languages like VB6) can talk to SQL Server.
It really depends on what you...
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.
June 19, 2020 at 5:06 pm
Technically, you could even bump that down to 1 trigger instead of 2 by having it as a for update AND insert. Doing it as 1 trigger might not help...
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.
June 19, 2020 at 4:58 pm
I would start by reading this:
https://www.microsoft.com/en-us/learning/certification-exam-policies.aspx
Specifically the section about the NDA:
Why am I required to accept a non-disclosure agreement (NDA) before I take an exam?
The Microsoft Certification Program requires candidates...
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.
June 19, 2020 at 4:37 pm
In the article you mention PoSH as well, and my tool of choice (despite the bugs I've found and live with) is Powershell Plus Professional Edition (which 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.
June 19, 2020 at 2:31 pm
I think our approaches to index creation/removal are a bit different. But if it works for you, that's good!
My thoughts though about performance are less about indexes specifically, but on...
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.
June 18, 2020 at 7:45 pm
Rob Reid - If you have the server running for a week or two and you designed the thing, you should have access to the metrics on the server, right? ...
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.
June 18, 2020 at 6:25 pm
My first recommendation is not to use Excel and VBA to pull data from the database (or push it in... I'm a little unclear on what is happening here) but...
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.
June 18, 2020 at 6:12 pm
I am glad it worked for you!
For me, intellisense has never worked well over a linked server or even cross-database on the same instance. Sometimes it gives me the list...
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.
June 18, 2020 at 4:16 pm
My personal preference is to avoid the "all in one" solutions as they often have limited features and updates have a higher chance of introducing bugs in features I use. ...
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.
June 17, 2020 at 4:26 pm
So, natively I don't think SQL Server has anything like this. That being said, getting the result you list is not an impossible task in SQL Server. Quick bit of...
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.
June 16, 2020 at 7:42 pm
The screenshots make me wonder if it is worth doing fragmentation work at all. The index size is pretty small with the largest being 15 MB. So rebuilding or reorganizing...
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.
June 16, 2020 at 4:47 pm
one thought (without downloading your code, so excuse any suggestions you already did) - put "SET NOCOUNT ON" at the start of your script and have the DBA run the...
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.
June 16, 2020 at 4:28 pm
My opinion - a SQL Server DBA is not likely to get much training from a project. A database developer would; a database architecht would, but the administration side of...
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.
June 16, 2020 at 3:42 pm
Viewing 15 posts - 1,831 through 1,845 (of 2,917 total)