Steve Jones - SSC Editor (1/28/2013)

---

Grant Fritchey (1/28/2013)

---

I'm starting to pull my hair out over on Ask. Can the super beings of this discussion take a look please? And be...

Here's how to manually update statistics. You'll need to use the WITH FULLSCAN option. This documentation is for 2005, but the 2000 syntax is the same (if I remember correctly).

One point worth making to the management team, elimination of foreign key constraints also takes choices away from the optimizer. I have an example up on my blog[/url].

And I'm...

If the query plans are truly identical, it doesn't sound like bad parameter sniffing. Are you sure they're absolutely identical or do they just have the same operators? Look at...

Not for a query that is running, no. You can use the plan handle to recompile a query in cache, but if it's actively running, it will have to complete....

Every one of these

CHARINDEX(',' + (CAST(parent.vWorkSpaceId AS varchar(1000))) + ','

Is absolutely going to kill performance. Functions against columns in the WHERE clause requires scans and there is no way around...

While yes, there are a million things I'd do to tune that query, it's not so complex that you should be seeing memory issues. I'd say you may want to...

NOCHECK only applies to foriegn keys and check constraints, not unique constraints. Details are in the Books Online. In order to satisfy the value UNIQUE, it kind of has to...

I'm starting to pull my hair out over on Ask. Can the super beings of this discussion take a look please? And be nice. I think the person on the...

Yes, the default behavior is that 20% of the data must be modified before statistics are updated automatically (for those desperate to correct me, yes, I know it's more complex...

opc.three (1/26/2013)

---

Grant Fritchey (1/25/2013)

---

Since you're on SQL Server 2012, I would advise avoiding trace events. Instead focus on extended events. They're more light weight and much more programmable. There's no...

bitbucket-25253 (1/25/2013)

---

NO, NO, NO,...

Even on large systems, it comes down to the code, the indexes and the statistics. You've got to structure the indexes appropriately to support the queries you need to run....

sqlnaive (1/25/2013)

---

Grant, in addition to this, does it means just declaring internal parameters won't resolve parameter snififng ? Is updating stats mandatory (I know there's always "as per situation" criteria...

Are there? Sure, but what you want is pretty simple. Extended Events is a snap to set up and will do exactly what...