Building calendar table using MTVF
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,376 reads
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,376 reads
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2019-10-04 (first published: 2016-10-03)
479 reads
2019-10-04 (first published: 2016-10-03)
821 reads
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2019-10-04 (first published: 2017-02-21)
1,072 reads
The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.
2019-10-04 (first published: 2017-02-20)
1,793 reads
Transform your query result into an Excel file using this technique.
2018-03-05
7,277 reads
2017-07-07
1,089 reads
This article shows a few techniques with SQLCLR to to transform a query result into HTML.
2017-06-05
3,937 reads
This article shows a few techniques that help in capturing deleted records.
2016-12-19
13,113 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Hello, so I was reading on partitioning a large table, Which i successfully did,...
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...