SSIS is probably what most people use. You could absolutely do all this using Powershell though.

You may want to also look to sys.dm_exec_query_stats. The DMV you're referencing, sys.dm_exec_procedure_stats, only has statistics for stored procedures and parameterized queries. Any ad hoc or dynamic queries are in...

Table statistics are there because at least one query has referenced a column in such a way that the statistic was needed to determine the execution plan. If those statistics...

It's likely that either or both of those queries are part of a larger batch that has other parts that are still holding resources. However, as Gail says, no way...

jasona.work (9/21/2016)

---

So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for why computer...

The bigger concern is going to be the lowest common denominator T-SQL that the API is going to generate. About 90% or so will be fine. That last 10% will...

No more than entry level. Most of the time, hiring a DBA from outside the company, you're looking for someone with experience, not just a certificate. Within an organization people...

I suspect this is an extension on the concepts around an ORM (Object-Relational Mapping) tool. Instead of writing T-SQL, you just access the API and the API generates any and...

I had this exact discussion with Adam Machanic once. We came down on the side, apart from index maintenance and storage (and we're ignoring some pretty big issues), as far...

CELKO (9/19/2016)

---

All display formatting in SQL is done in a presentation layer, never in the database. If you will read the SQL standards, you will find that we use only...

I'm not completely sure I understand the question.

You're saying that you use local variables instead of parameters?

What happens with this is that you are taking away the optimizers ability...

That is a big number. Usually, but not always, that would indicate that the statistics are out of date or incorrect.

It's the table valued function, FullTextMatch. It says the estimated cost is zero, but I wouldn't believe that at all.

Can you post the execution plan? Save the .sqlplan file, not a picture. We need to be able to see the properties.

You'd need to experiment with both. Usually, but certainly not always, a compound index is better. This is because the higher degree of selectivity caused by the compound index makes...