Yes, that query is incorrect.

Use SELECT DISTINCT..., not SELECT ','+DISTINCT...

Cheers!

The scope of your DISTINCT is incorrect. You're enforcing a DISTINCT set of values for the outer SELECT, but at that point the concatenated list is the value of a...

Not directly, no. FILLFACTOR is not an option for single partition rebuilds https://msdn.microsoft.com/en-us/library/ms188388.aspx.

You could try to achieve this indirectly using the method in Thomas Kejser's answer here: http://dba.stackexchange.com/questions/86588/shrinking-old-partitions

Cheers!

I might be misunderstanding you, but if you're starting with the integer value (it sounds like you are?), then I find this method a bit more straightforward, using bitwise comparison:

=IIF((ValueToCheck...

Yes, that works. That's the version he gives in the answer that is supposed to work, because the order of the table valued constructors has changed. Try the...

edwardwill (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time. Seems to be...

edwardwill (1/13/2016)

---

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time. Seems to be a bit of...

Thanks, that helps a bit.

Let me know if the code below does what you need. For this solution, the TOP (N) in the tally will have to be enough for...

The requirement's still not so clear.

Specifically, with a frequency of 2, there should be an appointment every seven days. However, are those appointments occurring every seven days from the...

That code is not actually retrieving/calculating the cost of some existing product; he's just using that to generate unique costs for each item.

The idea is that you can use constructions...

This shouldn't be too hard to do without a cursor.

Before I dive in too deeply, what are the expected results for that sample data and some parameter values you would...

I understand your reasoning, but that's not the correct scope for the OR in that English construction.

The construction "X, whether Y or not-Y", is equivalent to "IF (y OR not-Y),...

Rich Mechaber (1/11/2016)

---

Jeff Moden (1/10/2016)

---

Also notice that I've removed the drops of the Temp Tables from the end of the code because that will actually slow SQL Server down a...

This seems relevant as well: http://www.sqlskills.com/blogs/kimberly/nonclustered-indexes-lookup-key-btree/

Cheers!

A couple big things are worth pointing out.

First, a high percentage of CXPACKET waits doesn't necessarily mean there's a problem. The only thing you know for sure from seeing CXPACKET...