2010-11-26
3,102 reads
Arup Chakraborty
2010-09-10 (first published: 2008-11-17)
32,806 reads
2010-01-20
4,563 reads
4 Ways to Increase Your Salary (Using UPDATE)
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
2009-11-26
38,720 reads
2009-10-27
3,805 reads
Twenty tips to write a good stored procedure
This article will provide some useful information to write a SP. I have emphasized on performance.
2009-08-10
52,356 reads
2009-02-24
4,117 reads
2008-12-03
3,687 reads
2008-11-19
3,137 reads
2008-11-13
3,080 reads
Blogs
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Creating a Flyway Desktop Shadow Database in PostgreSQL
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
Daily Coping 6 Feb 2023
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Forums
Future of SQL Server DBA Role
I would like to know what certifications or paths to choose in order to...
Extended Events shows each SQL command in one long line
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Group by issue
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Ask SSC