Josh Ashwood (12/20/2012)

---

Can you imagine all the little humble

SELECT Foos

FROM FooBars

statements out there in the wild that would just stop working if Microsoft made the semi-colon a requirement in a...

Tune the query (may include some rewriting)

If that doesn't work, consider one of the snapshot isolation levels

Why don't you read the blog post?...

Depends what you mean by 'not in order'

Neither parallelism, nor multiple tempDB files are going to result in a query with an order by returning data out of order. Any...

pdanes (12/19/2012)

---

GilaMonster (12/19/2012)

---

pdanes (12/19/2012)

---

But what about such a table as a parameter? No business logic, but at least the fields would be strongly typed. I don't know if I would...

pdanes (12/19/2012)

---

But what about such a table as a parameter? No business logic, but at least the fields would be strongly typed. I don't know if I would get a...

Multiple users.

Maintenance (removing unneeded rows, what if the proc fails before it does...

Then that order by shouldn't need a sort. Unless there's maybe parallelism. Really need to see the exec plan

pdanes (12/19/2012)

---

Don't you get a performance hit from passing a table over the network, rather than a single string? And I think the server would parse it a lot faster...

Jon.Morisi (12/19/2012)

---

If I were in your shoes I'd start with addressing the CXPACKET waits by modifying Cost threshold for parallelism and Max Degree of Parallelism because that's a relatively easy...

pdanes (12/19/2012)

---

GilaMonster (12/19/2012)

---

I'm going to be unpopular here but...

Dependency analysis?

Regression testing?

Unit tests?

Sure, making all parameters and variables varchar(max) would work. Shall we make all table columns varchar max too (if...

I'm going to...

Rather disable the VM backup (or just the SQL portion of it). In general you should not have two separate technologies doing SQL backups. Everything in SQL or everything in...

There's no way around that.

A filtered index for deal_date > '20120401' cannot satisfy a query WHERE deal_date > @YStartDate because of the parameterisation.

The plan is cached and reused. The optimiser,...

Please post the definition of the pk (the SQL statement to create it)