Honestly, this is why I personally find it easier to just store anything in UTC if I'm ever working with time sensitive data, or multiple timezones (and I include...

So, it uses the same kind of lookup table but stored in Windows Registry.

Not sure how gods is it in terms of performance, but it does not eliminate the necessity...

Does AT TIME ZONE know that it has to add 11 hours for CompletionDate from Friday but 10 hours for CompletionDate on Monday?

if yes - where does it take from?

Still does not solve the issue with DLS.

i worked with a system which was saving OrderDate as UTC datetime. And converted it to a local time on the way back...

5 developers (actually more, but 5 was a typical number of SQL developers on roster at the same time) developed a system with weekly -partitioned transaction tables. It was a...

There is no point of shrinking tempdb - it will grow back.

You need to find out which process makes it grow beyond reasonable limits and figure out how to change...

The table size usually includes the size of all indexes created on the table.

for SELECT * query you need to know the size of the index with indid=1 or 0.

It seems you already know what to do.

At least you identified the cause of the problem correctly.

Here's my analogy.  People love eating hamburgers.  Most people, however, do not care to know how the meat paddies are made.  No amount of interest piquing is going to...

Thanks for the reply.  Everything you've written is true but it doesn't help me.  And I should know (and I do) how to optimize the query.  The issue is...

It's a good question. I don't get to decide, the business do. The rules are arbitrary so I have to use a fixed table, in fact several. This (table...

Oops, I appear to have removed Sergiy's comment about Easter 2021 as being a holiday!  I meant to hit Quote not Report!

In response, Easter 2012 might be a holiday...

Not to mention - it's useless.

Local government and councils have a habit establishing they own...

That's nothing.

How about 2 multi-million rows tables (one of them is closer to billion) joined by a value extracted from an XML column?

Yes, by XML_col.value('XML path', 'int' )

The job running...

I came up with something similar prior to my previous post and rejected it as a solution on my part because of the ISNULL's.  It would be interesting to...

• This reply was modified 5 years, 8 months ago by Sergiy.