Viewing 15 posts - 931 through 945 (of 2,917 total)
I just read through the code and to me I think what I said above should be correct.
The only thing is you will likely need to open the master key...
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.
September 16, 2021 at 5:54 pm
I am 99% sure you just need to restore the database as the DMK will come across with it. Once you do that, it depends on how you were accessing...
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.
September 16, 2021 at 2:30 pm
I think the big questions that come to mind are:
1 - are you fully patched?
2 - is the latest .NET installed?
3 - how are you calling the linked server? 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.
September 15, 2021 at 9:39 pm
To me it looks like it isn't a SQL Server issue, but something with "PIPC" or "pisdk". Not sure what those are, but google makes it look like it 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.
September 15, 2021 at 7:00 pm
There is a lot of area to go with your question. Not seeing high CPU, memory, or disk queue may or may not tell you much. For example, if your...
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.
September 14, 2021 at 5:58 pm
Personally, this feels like a job for powershell, not SQL Server.
Just because SQL Server CAN do it, doesn't mean it SHOULD do it.
SQL Server is a database engine and 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.
September 14, 2021 at 5:39 pm
As a thought - are you sure it is the conversion that is causing the slowness?
What I mean is what if you take out the INSERT INTO statement and just...
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.
September 13, 2021 at 7:42 pm
I am not certain on the default trace, but I think you could set up an XE session to capture that.
How is the tool running the drop script? I am...
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.
September 13, 2021 at 7:29 pm
Everything you listed plus support and more features (SSRS, SSAS, SSIS, etc) and scalability.
Commercial tools, in general, should perform better than the free tools when properly configured. An improperly configured...
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.
September 13, 2021 at 5:49 pm
SSDT, if I remember right, allows for a lot of different things you can do with it including, but not limited to, SSRS, SSIS, SSAS, etc.
Knowing what type of project...
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.
September 10, 2021 at 6:58 pm
To me it looks like whatever process you have for populating the parameter (@DBName) is busted.
Now as to why it isn't working, you would need to look into what populates...
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.
September 10, 2021 at 6:07 pm
I agree with Grant and Piet here - there are no shortcuts with it.
One thing that can help though and I strongly recommend is to adopt a coding standard AND...
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.
September 9, 2021 at 8:02 pm
My approach would be to look at where the problem is and determine what you want to do to fix it.
What you indicated is that the string MUST end 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.
September 9, 2021 at 5:43 pm
If I am understanding your request properly, something like this should work, right:
WITH [cte]
AS
(
SELECT
[Mobile]
, [WorkTelephone]
, [HomeTelephone]
, [FirstName]
, [LastName]
, [PolicyNumber]
, COUNT(1) OVER (PARTITION BY
[Mobile]
, [FirstName]
,...
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.
September 8, 2021 at 2:39 pm
oh sorry. I misunderstood. I think that will be a bit more challenging as you are essentially going to need to rip apart the XML. I think this may fall...
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.
September 3, 2021 at 2:48 pm
Viewing 15 posts - 931 through 945 (of 2,917 total)