Viewing 15 posts - 1 through 15 (of 1,168 total)
It is better to not just designate an arbitrary integer as your clustering index. But instead consider how the table will join to other tables and be filtered.
If you are...
April 26, 2024 at 12:39 pm
Aside from what been said, If your data has changed then see if you need to update index stats especially on your heavily used tables.
April 26, 2024 at 12:19 pm
What ever your rules for matching are , For example address matching, you will need to join the table with itself. Something like ? >
Select t1.custNo, t2.*,...
April 26, 2024 at 12:05 pm
ALTER TABLE test_table
ADD CONSTRAINT test_table_R01 FOREIGN KEY (parent_id)
REFERENCES test_table (table_id);
Seems to me that the first row can only reference itself, so would have to watch the order...
April 24, 2024 at 10:14 pm
Are you lookging for something like
SELECT
CONCAT(s1.Product_code, s2.serialNumber) as newProductCode
s2.SerialNumber
...
April 24, 2024 at 10:09 pm
Are you lookging for something like
SELECT
CONCAT(s1.Product_code, s2.serialNumber) as newProductCode
s2.SerialNumber
...
April 24, 2024 at 10:08 pm
"Select emp.vid,pt,dn,dcode,dcat,dtime,dlocation "
IF you are selecting all the columns from just your base table, and non from the other join tables, you could try removing the joins and instead employ ...
April 24, 2024 at 9:53 pm
Thus every row will have this 14 bytes of extra storage , regardless if that row gets updated later?
February 23, 2024 at 5:46 pm
Defintley looks like this was ChatGpt assisted at the least. Very non specific and lacking use cases.
January 11, 2024 at 10:20 pm
Having that extra lookup table with unecrypted data will no doubt mean it will require extra column level security at the least. Preventing unauthorized access will be the primary importance.
January 2, 2024 at 4:02 am
I have to wonder about moving tables from one schema to another and how that would impact applications accessing established data. I imagine a synonym coming into the equation at...
November 6, 2023 at 6:52 am
Finely written article. And well explained, thank you. I do have a question or two.
with open('c:\data\currencies.csv', 'r') as csv_file:
...
November 6, 2023 at 6:39 am
Now that I've looked more carefully, the rows are a little over a 1,000 bytes each, most of that in one varchar(1000) field so it probably covers three pages. I'll...
September 29, 2023 at 12:50 am
Now that I've looked more carefully, the rows are a little over a 1,000 bytes each, most of that in one varchar(1000) field so it probably covers three pages....
September 29, 2023 at 12:50 am
Good article thank you. An important item to note > Microsoft Docs itselft mentions that forced plans are a temporary solution as a optimized plan today may not be the...
September 8, 2023 at 1:13 am
Viewing 15 posts - 1 through 15 (of 1,168 total)