Viewing 15 posts - 16 through 30 (of 1,165 total)
"
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
Aggregation versus sorting. A lot less work to sort than aggregate. Also, a join operation versus none.
Also, you can get much more accurate measures if you use Extended Events.
This...
June 8, 2023 at 9:48 pm
Thank you everyone for your good input. The message I am getting is to use Extended Events to measure performance since Batch and even Statistics are not always accurate to...
June 8, 2023 at 9:46 pm
Thank you for the elaborate description on Google cloud databases. Somehow towards the end the backend database switched from a mySQL to a SQL Server without notice. Or did I...
June 1, 2023 at 9:03 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 performance:
May 19, 2023 at 1:21 am
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 performance:
May 19, 2023 at 1:09 am
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 performance:
...
May 18, 2023 at 8:34 am
My thoughts on this are that this article is quite shallow and lacks breadth.
May 18, 2023 at 8:26 am
Thank you for breaking things down so well. This is well put. I do recall coming across the ability to email HTML reports from the SQL Server agent in the...
May 3, 2023 at 6:35 am
The verical resutls feature is a nice one to have. Though I have seen this in powershell with the invoke sql command(let). Powershell seemingly decides for you to present in...
April 22, 2023 at 6:46 pm
I have a feeling people want to test with real data because I suspect the database is not in a normalized state. That is, there is probably a repeat of...
April 12, 2023 at 10:53 pm
This is not much to go on as the schema of your tables is unknown. I suspect you would benefit from a classic Calendar table which comes with columns for...
April 12, 2023 at 12:38 am
Viewing 15 posts - 16 through 30 (of 1,165 total)