Viewing 15 posts - 1 through 15 (of 1,161 total)
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
Thank you, this is informative. Throughout I notice the word user and log in/login used interchangably maybe ?
From Microsoft: http://learn.microsoft.com/en-us/sql/t-sql/statements/alter-authorization-transact-sql
"Server objects (such as databases) must be owned by a server...
August 18, 2023 at 6:44 pm
I think that is a good point. Review what the developer has actually submitted, not other stuff. Obviously there are some "It depends" scenarios. Restricting the blast radius is...
August 3, 2023 at 9:48 pm
This is indeed an nice high level overview into Redshift. A couple of points I would like to make
July 25, 2023 at 6:42 am
"
STudents (StudentID PK, Language, SuperKey (StudentID,Language)), - OK
Teachers (TeacherID PK, LAnguage, SuperKey (TeacherID, LAnguage)), - OK
StudentTeachers (teacherID , StudentID , Language), PK (TeacherID, StudentID),
FK1 (TeacherID,LAnguage) to Teachers (TeacherID, LAnguage0)
FK2 (StudentID,LAnguage ...
July 14, 2023 at 8:46 pm
Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query...
July 14, 2023 at 8:43 am
I would see a materialized view being handy in a data warehouse environment where the data is pre-made and not expected to change during some amount of time. When it...
June 27, 2023 at 2:28 am
Your table looks to be clustered first (probably only) on ID. Add add_date after ID in the clus index to help that type of query.
That is correct. If there...
June 8, 2023 at 10:30 pm
Viewing 15 posts - 1 through 15 (of 1,161 total)