You can find how to accomplish the same here
Monday, June 6, 2016
Tuesday, January 12, 2016
The timestamp syntax is deprecated, use rowversion instead
The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Have a look here https://msdn.microsoft.com/en-us/library/ms182776.aspx
Have a look here https://msdn.microsoft.com/en-us/library/ms182776.aspx
Sunday, December 6, 2015
How to set default page in umbraco?
Setting default page is a tricky process, as umbraco always defaults to
the first page in document structure. Sometimes, the first page in your document
structure may not be the default document you. In such case you can use the below
approach.
In the template of the first document (or create new document type for
tis and use this for creating a root document), add java script redirection as
below .In my case it will redirect to index.html.
Tuesday, December 1, 2015
How to pre compile a website using aspnet_compiler?
Just use the below command to precompile your website
aspnet_compiler -p physicalOrRelativePath -v / targetPath
More information regarding the same can be found here
How to Delete/Rebuild Umbraco cache?
How to Delete/Rebuild Umbraco cache?
Umbraco maintains the content in
two places. One in database and the other in file system as cache in xml.
The file system (cache version) can be cleared by hitting at the below link.
Delete/Rebuild umbraco based website cache from direct url:
http://<Yoursitename>/Umbraco/dialogs/republish.aspx?xml=true
http://<Yoursitename
Saturday, November 28, 2015
How does href attribute of anchor tags works?
I Just found the following site that I think does a really good job explaining the
http://www.mediacollege.com/internet/html/hyperlinks.html
href attribute of anchor tags and how it interprets URL paths. It shows a lots of examples to illustrate the differences between the path types:http://www.mediacollege.com/internet/html/hyperlinks.html
Thursday, February 26, 2015
How to force a query to recompile every time in SQL server.
If you want to clear execution plan and cache, you could
use the below commands
DBCC FreeProcCache
DBCC DropCleanbuffers
If you want to force query compilation each time, just add the below to the end of the query
DBCC FreeProcCache
DBCC DropCleanbuffers
More details here
https://msdn.microsoft.com/en-us/library/ms174283.aspxIf you want to force query compilation each time, just add the below to the end of the query
OPTION (RECOMPILE)
Subscribe to:
Posts (Atom)