Introduction to StudyYourServer
I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...
2020-02-04
15 reads
Eduardo Pivaral
- Website: http://www.sqlguatemala.com
New Youtube Channel
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
36 reads
New Youtube Channel
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
7 reads
T-SQL Basics: using OUTPUT
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-09 (first published: 2020-01-03)
1,046 reads
T-SQL Basics: using OUTPUT
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-03
3 reads
Xmas tree in T-SQL
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
232 reads
Xmas tree in T-SQL
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
2 reads
Refreshing dependent views after a DDL change
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-08-02 (first published: 2019-07-15)
1,177 reads
SQL Engine basics: Caching data
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-16 (first published: 2019-07-05)
1,062 reads
Refreshing dependent views after a DDL change
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-07-15
1 reads
Blogs
First Time Speaking with a Mask at an Event
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
A New Word: Apolytus
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Forums
Hardcoded filter vs filter by parameter
I am trying to set a date filter on several large transaction tables to...
Do you listen to music when you work?
Comments posted to this topic are about the item Do you listen to music...
Slow update on temp table
I have a job running each night starting at 4:30AM and usually finishing at...
Question of the Day
Read Only Replica in SQL Server Standard
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers