As in most development the code should speak for it self, and you should use:

Source control (containing change documentation)

Formatting tool/formatting rules

Good and describing naming rules

Your procedure should...

Steve,

Will that actually work in a stored procedure?  I'm thinking "not" and that it could only work from a "routine" (if you understand the difference) but I could be wrong.

We are small shop and we don't get to hire any dedicated consultant for performance tuning.  Everything has to be done by us!

Thanks everyone. Forgive me if I...

I was always told to do the same... until they saw the format and the content. Lynn has...

As in most development the code should speak for it self, and you should use:

<li style="list-style-type: none;">

• Source control (containing change documentation)

<li style="list-style-type: none;">

• Formatting tool/formatting rules

...

Thanks Jeff and John for the help.  I ended up rewriting the vw_pos_period_dim as a materialized view.  Still not sure why that worked since the view itself performed well,...

On the subject of questions getting worse, here's what it has finally come to.  Notice in the zip file that there is absolutely everything that one might need to get...

In your case, I would use the ISO-8601 week-date format. You can downoad such a calendar from the internet. The format is yyyyW[0-5][0-9]-[1-7] where the week is 01-53, depending...

Sam,

Rewriting to use ANSI Joins instead of older Equi-Joins isn't going to fix it nor the apparent total absence of any indexes to support the code.  Returning more than 600...

Hi All,

We are trying to creating a clustered idx on a HEAP. It is almost 45 mins, its still running. Heap is around ~400 GB. Is it expected ?...

Be REALLY careful with the code posted so far (all of it... the original post and all coded answers).  It contains a Triangular Join and that's a huge drain on...

Hi Kherald,

Thanks allot for your response. I have an issue with your sample query.

SELECT COALESCE(a.id, b.id, c.id, d.id) id

, a.name, b.dept_id, c.mail, d.contact

FROM #Table1 a

FULL JOIN #Table2 b ON...

Team

I have a scenario in SQL Query. If I Give a day, The output should say which day and how many days crossed in a given month

For Ex

...

Try the date of '7 Dec 2019' and see that it comes up...

Team

I have a scenario in SQL Query. If I Give a day, The output should say which day and how many days crossed in a given month

For Ex

<li...