2016-08-11 (first published: 2015-06-12)
3,585 reads
2016-08-11 (first published: 2015-06-12)
3,585 reads
2016-08-10 (first published: 2015-05-05)
4,944 reads
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-08 (first published: 2014-12-29)
6,896 reads
Generates # of dates in before/after current year.
No more hardcoded date ranges.
2016-08-08 (first published: 2016-07-28)
588 reads
Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.
2016-08-08 (first published: 2015-03-03)
5,289 reads
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
7,169 reads
This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.
2016-07-29 (first published: 2014-06-21)
2,370 reads
A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.
2016-07-28 (first published: 2014-06-06)
2,323 reads
Based upon todays date as suffix and chosen string as prefix, select data from predefined table into dynamically named new table. Script is properly error handled with most common errors
2016-07-27 (first published: 2015-05-04)
2,316 reads
2016-07-26 (first published: 2014-11-20)
2,190 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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