As normal

update statistics XYZ on table on primary node.

you could try doing left joins if the query isn't fast enough.

It may give better speed, but be careful of the possibility of duplicating rows.

His example gives you a way of seeing the type of issues you could have with differing collations.

If you don't understand enough of collation to understand the...

TheSQLGuru (5/3/2016)

---

Gail is spot on as usual.

I have been consulting on SQL Server since the mid-1990s and I can count on two hands the number of times I have seen...

Hi

Yes seems to not work in this case, strangely. I am guessing cos the CTE is making multiple roots to...

your partitioning function will tell you how the data is split.

You can find that under storage in that dataase.

Tried this, seems...

do you need SysKey?

I'm testing out this scenario where the later date is earlier in the insert and syskey for the later date will have a lower value.

The max(syskey) requirement...

Is it not possible to rank over the table once, and get everything you ever need from that table, instead of PolicyAudit self join (select top 1 PolicyAudit...

I have had this issue and it turned out to be user defined scalar functions operating...

What should the results for these test cases be?

SELECT age FROM dbo.YearsApart('2/28/2002','02/28/2003');

SELECT age FROM dbo.YearsApart('2/28/2003','02/28/2004');

SELECT age FROM dbo.YearsApart('2/29/2004','02/28/2005');

SELECT age FROM dbo.YearsApart('03/01/2004','03/01/2005');

Edit : Seems that how you handle leaplings depends on...

Jeff Moden (4/25/2016)

---

MadAdmin (4/25/2016)

---

Jeff Moden (4/25/2016)

---

Thanks for the answers, folks. Everything is pretty much as I thought but had to make sure. Lot's o' experienced folks out there...

Jeff Moden (4/25/2016)

---

Thanks for the answers, folks. Everything is pretty much as I thought but had to make sure. Lot's o' experienced folks out there and I've not...

Mike Good (4/25/2016)

---

Lack of index on FK column has bitten me when the parent table was one where the data was occasionally deleted. Deletion of rows in the parent...

mike.dinnis (4/25/2016)

---

Jacob Wilkins (4/25/2016)

---

You'll either need to look at simplifying the query (maybe explicitly querying the underlying tables from the view that you need instead of forcing the optimizer to...