Viewing 15 posts - 1,306 through 1,320 (of 7,614 total)
I believe SQL caches table variables the same way it does for temp tables. If so, an entries for them would still be in the system tables. It would be...
August 30, 2021 at 6:37 pm
For the actual tables, post the DDL, including all indexes.
For any views, post the view definition.
August 29, 2021 at 7:04 am
Agree, there's no super-easy, "automatic" way to do that. However, you can generate a script(s) that will change each column as needed, so it's not like you have to do...
August 27, 2021 at 3:18 pm
To allow me to write full code, would you provide the full DDL for the Error_Log table? The big gain will come from encoding strings as numbers using a conversion...
August 27, 2021 at 7:15 am
Of course it's optional if you make the new clustering index a PK or not.
That is, you could drop the existing PK, create the new clustering index, then re-add the...
August 26, 2021 at 9:00 pm
Get rid of the functions around the usrt_dtm_DateTime column; you don't need them and they will prevent lookup seeks, drastically harming performance:
SET @ToDate = CAST(@ToDate AS date)...
August 26, 2021 at 8:53 pm
If the Production.ProductInventory table is clustered on ProductId (and it almost certainly should be), and you specify a specific ProductId or a list of ProductIds, as in the WHERE clause...
August 25, 2021 at 10:48 pm
Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in...
August 25, 2021 at 5:53 pm
SELECT
J.Job,
J.Category,
COALESCE(C.Value, C_All.Value) AS Value
FROM Job J
LEFT OUTER JOIN Category C ON C.Category =...
August 25, 2021 at 4:31 am
Sorry, no, I just need to get time to get back to it. I should be able to do that tomorrow.
We have to reduce the overhead in the Write proc...
August 25, 2021 at 1:38 am
Actually, it depends on how the table is searched.
Do you often filter the rows by only type when SELECTing? If so, then the clus index makes sense...
August 25, 2021 at 1:37 am
Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in the...
August 24, 2021 at 7:45 pm
None of this works:
...
SELECT * INTO 2415_10_Ga_Trunking_Design_Configurator FROM 2415_12_Ga_Trunking_Design_Configurator
What about that doesn't work?
If you don't want any data in the table, use TOP (0) and/or WHERE 1 = 0...
August 24, 2021 at 6:34 pm
You're welcome. Thanks for the feedback.
If you would mark it as the answer, it could help people looking at this later, as they will then know the q has been...
August 24, 2021 at 6:31 pm
Our situation appears to be quite a bit different than yours (and no... neither is wrong, IMHO... they're just different because of different business requirements). My best friend, who...
August 24, 2021 at 6:29 pm
Viewing 15 posts - 1,306 through 1,320 (of 7,614 total)