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...

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...

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...

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...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale.

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...

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...

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...

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...

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...

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...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale.

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...

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...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale. Reason: changing some "my"s to "our"s, I's to we's and fix some grammar

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...

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...

Quick and easy fix to this - need to mark the variable as an OUTPUT variable in the parameter assignment part of sp_executesql.

In your EXEC statement, change:

@xml=@xml

to

@xml=@xml OUTPUT

Something to note...