John Oliver DesignStreaks
DesignStreaks
/ sp_helpindex2.sql
Last active
November 29, 2022 22:43
Modified version of the Sql Server sys proc `sp_helpindex` that also shows include columns
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| if object_id('dbo.sp_helpindex2') is not null | |
| drop procedure dbo.sp_helpindex2; | |
| go | |
| create procedure dbo.sp_helpindex2( | |
| @objname nvarchar(776)-- the table to check for indexes | |
| ) | |
| as | |
| begin | |
| -- PRELIM |
DesignStreaks
/ Reformat PluralSight Course list
Last active
August 29, 2015 14:14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| javascript:(function () { | |
| var newSS, coreStyles = 'h5.title a {color: blue;}'; | |
| var elementStyles = ' .row {max-width: 100%;} '; | |
| if (document.createStyleSheet) { | |
| document.createStyleSheet("javascript:'" + coreStyles + elementStyles + "'"); | |
| } else { | |
| newSS = document.createElement('link'); | |
| newSS.rel = 'stylesheet'; |
DesignStreaks
/ Reformat CodeProject Article
Last active
May 12, 2016 22:39
Format a CodeProject article.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (function () { | |
| var styles = 'body,p,li,tr,td,th,dd,dt {font-size:12px;margin:0px;} h1{font-size:24px !important;} h2{font-size:20px !important;margin-bottom: 0px;margin-top:4px;} h3 {} h4{margin-bottom:4px} code{font-size:10pt !important;} pre{font-size:8pt !important;} img{max-width:50% !important;height:auto !important;} .article .summary {padding-top:0;} .author-wrapper{min-height:0;padding-left:0;}'; | |
| if (document.createStyleSheet) { | |
| document.createStyleSheet("javascript:'" + styles + "'"); | |
| } else { | |
| var newSS = document.createElement('link'); | |
| newSS.rel = 'stylesheet'; | |
| newSS.href = 'data:text/css,' + escape(styles); | |
| document.getElementsByTagName("head")[0].appendChild(newSS); |
DesignStreaks
/ gist:7610257
Last active
December 29, 2015 03:49
I have been an avid reader of .Net Magazine for a number of years. With the recent migration of all articles from .Net Magazine to CreativeBloq, the document format has become, in my opinion, a nightmare. As such, I have created this little bookmark-let that will update the page. So what does this bookmark-let do?
To put it bluntly, it removes t…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (function () { | |
| var newSS, styles = 'body { font-size: 12px; } h1 { font-size: 1.5em !important;} h2 { font-size: 1.4em !important;} h3 { font-size: 1.3em !important;} h4 { font-size: 1.2em !important;} .page-content { width: 100%; max-width: 100%; } #page-canvas {max-width: 100%; } .content { max-width: 100% !important; } .copy { font-size: 12px; } .node .copy p {margin-bottom: 1em !important; } .geshifilter { font-size: 1em !important; } .de1 { font-family: Consolas,"Courier New",Courier,monospace !important; } .video-player { width: 535px !important; padding-bottom: 270px !important;}'; | |
| if (document.createStyleSheet) { | |
| document.createStyleSheet("javascript:'" + styles + "'"); | |
| } | |
| else { | |
| newSS = document.createElement('link'); | |
| newSS.rel = 'stylesheet'; | |
| newSS.href = 'data:text/css,' + escape(styles); | |
| document.getElementsByTagName("head")[0].appendChild(newSS); |