Viewing 15 posts - 1,861 through 1,875 (of 2,917 total)
I think in this case if I understand things right, windowing functions are going to be your friend.
something like:
SELECT [site],
ISNULL([LCRate],0) as LCRate,
SUM([Eligible]) OVER (PARTITION BY [site]) AS...
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 10, 2020 at 10:03 pm
My opinion (we run things on physical hardware with a SAN handling the physical disk, not VMs), and my understanding is that the datastore makes no difference; you want things...
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 10, 2020 at 4:42 pm
To add to what Phil said, I think it also depends on what files you are storing in the database. Are they plain text or are they PDF and ZIP...
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 9, 2020 at 6:31 pm
As a guess, how much memory do you have free when you run that? SSIS runs in its own memory space, so it is possible (and is my current best...
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 9, 2020 at 6:23 pm
I agree that this is a confusing one. Fun little tidbit, changing the - to + yields the same result as the QOTD 0.1000000:
SELECT +100/+100*10.0
To me, this...
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 9, 2020 at 5:39 pm
Curious_sqldba:
I can see where your IT team may not want you installing software on your PC without their approvals, but something like git (or SVN or CVS) should be deployed...
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 9, 2020 at 4:52 pm
Quick google and I found this blog post:
https://blog.sqlauthority.com/2010/07/24/sql-server-find-queries-using-parallelism-from-cached-plan/
Pinal Dave has a query there that will pull all parallel plans from the plan cache (not from the query store). I would...
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 9, 2020 at 4:15 pm
Quick look at your execution plan, it looks like your slow operations are in your loop. The insert is the highest cost operation. That being said, you should get 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.
June 9, 2020 at 3:37 pm
Thanks for the article. It was very informative and you demo'ed the tool that we actually use at work (sourcetree).
There are some things that I think are 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.
June 8, 2020 at 9:26 pm
I am glad they got things fixed. Something to note though - depending on what type of audits you have and certifications your company has (SOX, ISO, etc), having technical...
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 8, 2020 at 7:39 pm
That is a long stored procedure, but I will offer some input.
First, my advice is unless you NEED a query hint, don't use them. The SQL optimizer generally will take...
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 8, 2020 at 6:15 pm
Thanks for the article. It was very informative and you demo'ed the tool that we actually use at work (sourcetree).
There are some things that I think are not clear 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.
June 8, 2020 at 5:54 pm
Thanks Tim and Phil!
It is nice to hear that our setup isn't anything out of the ordinary and that other experts have similar issues with it that we do.
Our plan...
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 8, 2020 at 4:56 pm
I imagine you could. I am currently not using Query Store on my servers (too old... need to do upgrades), but my understanding is that it stores the execution plan...
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 8, 2020 at 4:17 pm
Pretty sure the problem there is with the XML NameSpace (xmlns). You are defining a namespace in the XML, but then not specifying the namespace in the SQL. You have...
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 5, 2020 at 7:17 pm
Viewing 15 posts - 1,861 through 1,875 (of 2,917 total)