Suppose you are storing URL in your table and you want to apply UNIQUE contraint but as SQL allows only 900 byte limit. how can you put unique constraint for larger text ??
For this you can create a computed CHECKSUM column which is an integer vale and put constraint on it.
Example as follows
CREATE TABLE messages [...]

For Team Leads, Developer don’t listen what you say still using * in their select queries. You can restrict them using * by using deny select on object.
This all you can do by create a dummy column in table and deny it for selection. Now user can select the rest of the [...]

For creating web service in SQL server you need to understand http end points. So what is http end points ? It provide an interface using TCP or http for SOAP.

1) Geometry Data Types a. Point -  POINT ( 10 15 ) -  A point b. Multipoint  – MULTIPOINT (10 10, 50 50) – A multipoint with two points c. LineString  – LINESTRING (10 10,20 20,31 35) -  A line string with three points d. Polygon – POLYGON (( 10 10, 10 20, 20 20, 20 15, 10 10))  – A polygon e. GeomCollection  – GEOMETRYCOLLECTION ((POINT (10 15), LINESTRING (10 10,20 20)) A  collection of