How many of what kind of indexes do you have on the target table?  Also, what is the total number of rows in the source table?

One thing I couldn't do easily was to deal with dates (that are date values in excel). These would show as "44649.94918" in the values table. When you would...

With the understanding that I don't use Analysis Services, can you use T-SQL in SSAS?  There are some very fast methods for calculating MEDIAN in T-SQL.

SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more...

Thanks for posting the solution that you found for your own question.  It's going to help others, for sure.

Is it possible to create a temp table when setting a query?

For example:

DECLARE 
@Category    varchar(100), 
@SubCategory varchar(100),
@Query      ...

What did you end up doing to solve your problem?

Doing only a quick glance at the execution plans, this looks like it could be a parameter sniffing issue.  You could go all surgical on this but I'm thinking that...

I like that chart Jeff, I might add it to my favourite argument I trot out every time I am faced with a short password requirement that forces numbers,...

Grant is spot on but I'll add an "old dude's" take on it...

Which ever turns out to be the best "architecture" for your data, none of it will matter for...

It's amazing to me how much incorrect information there is posted in posts containing a list of interview questions.

My recommendation to people using such lists is to only look at...

Hi All,

(see attached waits) I have a very slow sql server, it seemed to happen over night and queries are still slow. index rebuild/reorg and statistics have been updated....

It's looking great right now, sample attached with redactions.

I kept cteCalendar as you designed it, and changed ctePreCrossTab to use my attendance table.

It correctly merges the data correctly, one...

As to putting FKs on an audit table... don't EVER do that.  There's not reason to because the rows have already survived the INSERTs and UPDATEs for FKs and...

3) I created a quick table in SSRS and sure enough, it does depict a calendar style matrix with the month dates and the value in ##Attendance (screen snip...