Viewing 15 posts - 16 through 30 (of 1,168 total)
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
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
Viewing 15 posts - 16 through 30 (of 1,168 total)