Building calendar table using MTVF
This script is a small extension to this excellent article
http://qa.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,331 reads
This script is a small extension to this excellent article
http://qa.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,331 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)
457 reads
2019-10-04 (first published: 2016-10-03)
761 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)
843 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,504 reads
Transform your query result into an Excel file using this technique.
2018-03-05
6,574 reads
2017-07-07
1,085 reads
This article shows a few techniques with SQLCLR to to transform a query result into HTML.
2017-06-05
3,656 reads
This article shows a few techniques that help in capturing deleted records.
2016-12-19
11,539 reads
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers