The following code will update a column to varchar(max) only, when it does not already have the varchar(max) length.
-- Update column 'Name' length, it should be varchar(max).
-- Note: varchar(max) has length '-1'.
and COLUMN_NAME = 'Name'
) <> -1
alter table dbo.Table1 alter column Name varchar(max) not null
If you want to know the amount of elapsed minutes in the current quarter, you can use the following T-SQL code:
declare @CurrentDateTime datetime = '2014-03-27 10:56:10'
declare @MinutesPassedInHour int = convert(int, datepart(minute, @CurrentDateTime))
declare @quarterCount int = @MinutesPassedInHour / 15
declare @MinutesPassedInQuarter int = (@MinutesPassedInHour - (@quarterCount * 15))
-- Result: 11
If you want to clear the appCache for a site in Google Chrome, browse to:
Then click on the remove button for the specific site.
When mapping a collection to a local folder in Microsoft Visual Studio 2013, I was getting the error:
The working folder … is already in use by the workspace … on computer …
To solve this problem I had to delete the workspace:
- Close Microsoft Visual Studio 2013.
- Open en command prompt in Administrator mode.
- cd "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE"
- tf workspace /delete /server:http://220.127.116.11:8080/tfs/MyCollection MyComputerName;MyDomain\MyUserName
- Open Microsoft Visual Studio 2013. Mapping to local folder should now work.
For more information:
To list all workspace use:
tf workspaces /owner:* /computer:* /server:http://18.104.22.168:8080/tfs/MyCollection
To list detailed information on all workspaces, use:
tf workspaces /server:http://22.214.171.124:8080/tfs/MyCollection /computer:MyComputerName /owner:* /format:detailed
In a specific case, deleting the workspace on the client was not enough. I had to execute the same command on the TFS server itself to delete both the client and de server workspace.
In production we use Application Cache, to distribute a new version of a Single Page Application.
<remove fileExtension=".woff" />
<mimeMap fileExtension=".woff" mimeType="application/font-woff" />
<mimeMap fileExtension=".appcache" mimeType="text/cache-manifest" />
<!-- To disable appCache during development, comment line above and uncomment line below. -->
<!--<mimeMap fileExtension=".wrongAppcache" mimeType="text/cache-manifest" />-->