hosting

Technical Article

RE: Any suggestion for sql query optimization in sql

  • Reply

OK, here goes: 1) Remove the INDEX HINT. Let SQL Server optimize on its own; it will usually pick the right path if the SQL is well-written. 2) Use modern SQL syntax. Much easier to pick out JOIN mistakes... 3) What on Earth is the normalized structure of your data? I know the insurance indusry […]

You rated this post out of 5. Change rating

2003-06-05

Blogs

Moving T-SQL Tuesday to Jekyll

By

I got a message a few months back that Microsoft was deprecating the MySQL...

European Microsoft Fabric Community Conference announcements

By

A TON of new features announcements at the European Microsoft Fabric Community Conference help...

RDS Connectivity

By

I travel quite a lot for work. Most of it is in the US...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers