Tech Sathia: March 2016

Friday, March 18, 2016

Void elements in HTML5.

some elements cannot have content.These are called void elements. For example, the <br> tag represents a line break and cannot have any content.

The following is a list of void elements in HTML5.

<area> Defines a hyperlink area with some text in an image map
<base> Specifies the document’s base URL or target for all relative URLs in thedocument
<br> Represents a line break
<col> Defines the properties of one or more columns within a <colgroup> element
<command> Defines a command that can be invoked by a user
<hr> Specifies a thematic change in content
<img> Defines an image
<input> Defines a typed data field that allows the user to edit the data
<link> Defines a relationship between a document and an external resource such as
<keygen> Defines a key-pair generator control for forms that is used to encrypt data
that will be passed to the server
<meta> Defines metadata that describes the HTML document KeyTerms
<param> Defines a parameter for an object
<source> Defines a multimedia resource for a
<video>
<audio>
<wbr> Optionally breaks up a large word at this element

HTML5 Element

HTML5 has more than 100 defined elements that you can use to create rich webpages and
applications.

The W3C defines the following list of these elements with a brief description.

<a> Hyperlink
<abbr> Abbreviation
<address> Contact information
<area> Image map region
<article> Independent section
<aside> Auxiliary section
<audio> Audio stream
<b> Bold text
<base> Document base URI
<bb> Browser button
<bdo> Bi-directional text override
<blockquote> Long quotation
<body> Main content
<br> Line break
<button> Push button control
<canvas> Bitmap canvas
<caption> Table caption
<cite> Citation
<code> Code fragment
<col> Table column
<colgroup> Table column group
<command> Command that a user can invoke
<datagrid> Interactive tree, list, or tabular data
<datalist> Predefined control values
<dd> Definition description
<del> Deletion
<details> Additional information
<dfn> Defining instance of a term
<dialog> Conversation
<div> Generic division
<dl> Description list
<dt> Description term
<em> Stress emphasis
<embed> Embedded application
<fieldset> Form control group
<figure> A figure with a caption
<footer> Section footer
<form> Form
<h1> Heading level 1
<h2> Heading level 2
<h3> Heading level 3
<h4> Heading level 4
<h5> Heading level 5
<h6> Heading level 6
<head> Document head
<header> Section header
<hr> Separator
<html> Document root
<i> Italic text
<iframe> Inline frame
<img> Image
<input> Form control
<ins> Insertion
<kbd> User input
<label> Form control label
<legend> Explanatory title or caption
<li> List item
<link> Link to resources
<map> Client-side image map
<mark> Marked or highlighted text
<menu> Command menu
<meta> Metadata
<meter> Scalar measurement
<nav> Navigation
<noscript> Alternative content for no script support
<object> Generic embedded resource
<ol> Ordered list
<optgroup> Option group
<option> Selection choice
<output> Output control
<p> Paragraph
<param> Plug-in parameter
<pre> Preformatted text
<progress> Progress of a task
<q> Inline quotation
<rp> Ruby parenthesis
<rt> Ruby text
<ruby> Ruby annotation
<samp> Sample output
<script> Linked or embedded script
<section> Document section
<select> Selection control
<small> Small print
<source> Media resource
<span> Generic inline container
<strong> Strong importance
<style> Embedded style sheet
<sub> Subscript
<sup> Superscript
<table> Table
<tbody> Table body
<td> Table cell
<textarea> Multiline text control
<tfoot> Table footer
<th> Table header cell
<thead> Table head
<time> Date and/or time
<title> Document title
<tr> Table row
<ul> Unordered list
<var> Variable
<video> Video or movie
<wbr> Optionally break up a large word at this element

Monday, March 14, 2016

How to see the saved password in the Google Chrome.

Click the Chrome menu .
Click Settings. - > click Show advanced settings.
Under "Passwords and forms," click Manage passwords.
Under "Saved passwords,"
You can see the all password

Thursday, March 3, 2016

Show execution plan for stored procdure

SET SHOWPLAN_ALL ON
GO

-- FMTONLY will not exec stored proc

SET FMTONLY ON
GO

exec SampleStoredProcedure

GO

SET FMTONLY OFF
GO

SET SHOWPLAN_ALL OFF
GO

How to get estimated execution plan for stored procedure

How to get estimated execution plan for stored procedure ?

SET FMTONLY ON will give the plan.

Example

SET SHOWPLAN_ALL ON
GO

SET FMTONLY ON
GO

Exec Sample procedure

GO

SET FMTONLY OFF
GO

SET SHOWPLAN_ALL OFF
GO

Boost Stored Procedure’s Performance

1. SET NOCOUNT ON/OFF in the stored procedures are help to improve the performance

Eg.

CREATE PROCEDUR dbo.SampleProcedure
AS
SET NOCOUNT ON;
--Write code here
SELECT FirstColumn FROM dbo.SampleTable

SET NOCOUNT OFF;
GO

2. Schema name with table name and stored procedure name can improve the performance

SELECT * FROM dbo. SampleTable -- Preferred use

EXEC dbo. SampleProcedure -- Preferred use

3. Don’t use SELECT * in any case. Use the column name

4. Don’t use SELECT * Use IF EXISTS (SELECT 1) for checking

5. Short Transaction block will help you to improve the transaction

6. Avoid using SQL Server cursors

7. Use the sp_executesql instead of the EXECUTE or exec

Do not use the prefix “sp_”, server will search the system procedure list.