Okay well first off you should get into the habit of defining your keys as PK_FieldName rather than FieldName_PK as the former allows you to seemlessly use them in conjunction...

• This reply was modified 1 year, 3 months ago by  Dennis Jensen. Reason: Fix Typo
• This reply was modified 1 year, 3 months ago by  Dennis Jensen. Reason: fix typo

Yes we have already done this -- but you will also need a job that updates your Holiday table for each new year. We store the previous year, the current...

• This reply was modified 1 year, 3 months ago by  Dennis Jensen. Reason: fix typo
• This reply was modified 1 year, 3 months ago by  Dennis Jensen. Reason: Fix typo

The best way to track this information is have it be part of the Stored Procedure you are running and have a table that houses this information in a logical...

Grant I am with your first statement but ours was not a database related issue but more of a business application issue. The splitting was decided as being the best...

• This reply was modified 1 year, 4 months ago by  Dennis Jensen.

IF the split means that you can "reduce" the number of rows in one of the tables due to "duplicate information" then you should do it if savings are...

Okay well then I will share this information with my colleague as that was not his understanding and of the two of us he has dealt with that far more...

Okay I checked with my colleague as I remembered we looked into this in MS SQL so here we go. One cannot use a Columnstore in conjunction with a Table...

Thanks nice to know, but like I said the partitioning can be a bit sensitive in regards to other things so do becareful with that aspect.

Okay I do not recall all the details but a word of warning. With a Partitioned Table you have to include that partition within everything you do or you totally...

I am not sure if your issue is anything like ours but we have stored procedures that need to be ran by a specific system account and also need to...

All I can say to you Anders is I do not envy your situation but I do empathize as I have and am sort-of working with something similar but we...

I do not know what fields your tables have but doing CONTAINS(JobHistory.*,'"FN21HDA*"') or CONTAINS(Job.*, '"FN21HDA*"') or CONTAINS(Component.*, '"FN21HDA*"') seems extremely wasteful. As I think you mean it to do (which...

• This reply was modified 1 year, 5 months ago by  Dennis Jensen. Reason: Extra clarification

I've learned to appreciate diversity more and differences, not being as judgy when someone doesn't work or interact as I wish they did. If they accomplish the tasks well,...

• This reply was modified 1 year, 5 months ago by  Dennis Jensen. Reason: clarification

Thanks, and yeah GETDATE( ) or actually NOW( ) would be basically correct, I believe.

Note I have worked with so many languages sometimes the exact function names get a bit...

• This reply was modified 1 year, 5 months ago by  Dennis Jensen.

If you have SSMS, you could just run the SELECT by itself and it would show you how long it took.

However, if you need that via runtime, then you would...

• This reply was modified 1 year, 5 months ago by  Dennis Jensen. Reason: Added clarification