Never used DTA.

All I have ever done is drop indexes created by users who used the DTA,(both physical and hypothetical indexes en masse)

When looking at results, always always remember the...

Have a look at the index column order of your nonclustered index. It is redundant since you have a table already sorted on partitionid.

Does your query need to do the...

Just take note that rollbacks are single threaded.

So an index rebuild may take 1 hour using parallelism, but if you do a rollback, at minute 50, you may be in...

Find the queries that are doing hash matches and rewrite them.

Has someone done something silly like create a temp table which holds Gigs of data?

Shrinking temp db may only be...

I would say look out for nulls.

Also, if your result set has millions of rows, do temp tables and forget about table variables.

Stay away from this unless you know you...

I had a similar issue building DacPacs cos it seems like it does validation on build.

The workaround was to execute sqlpackage using command line as validation default is off with...

would this work?

CREATE FUNCTION dbo.TVF_CsStatus

...

Here is a good article by her imminence.

http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

I would say that it looks fine to me, but I have had an issue once before where the not exists was running...

Is there a positive reason why you are using global temp tables?

Are the columns of the table the correct data type to store the biggest value defined in the business requirements?

You could just select out converted values, leaving the base table...

ChrisM@Work (12/14/2015)

---

MadAdmin (12/14/2015)

---

I have seen pivot and the Group By create different plans. In one specific case I got the pivot...

serg-52 (12/9/2015)

---

Pivot is just a convenience method to say

select id,title,

ParentIdLevel1 = max(case ParentLevel when 1 then ParentId end),

ParentTitleLevel1 = max(case ParentLevel when 1 then ParentTitle end),

ParentIdLevel2 = max(case ParentLevel...

55 indexes?

Excuse the french but, gudddddamn!##^#^@^@^@2

Gets my blood boiling.

Proof is in the pudding always. Try the set based and measure. Then try the rbar and measure. Especially when the advice sounds odd.

np. It is very simple but I am very very lazy 🙂