The most common method used for this is shows below.
SELECT COUNT(*) FROM tablename

The same can be acheived by using the builtin SP

EXEC sp_spaceused 'tablename'

To get revords counts and its size of all the tables then use following(#Ballpark: because the sysindex table is not updated constantly.)

SELECT
[TableName] = so.name,
[RowCount] = MAX(si.rows)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U'
AND
si.id = OBJECT_ID(so.name)
GROUP BY
so.name
ORDER BY
2 DESC

As web2.0 coming to the end , a general question is what is next. I have queried google got that there is web3 and web4. Let discuss about web3.0.

Most of the Technolgy experts thinks that Web 3.0 is a friendly person who will behave like he knows about you and can understand what you want. They also teling that the period 2010 to 2020 will be the web3.0 era.

They are giving a clue that Web 3.0 is a giant database. The major differece with Web 2.0 is it uses the Internet to make connections between people, Web 3.0 will use the Internet to make connections with information.

Some experts see Web 3.0 replacing the current Web while others believe it will exist as a separate network.

so come to what web 3.0 actulay is
Here comes the term "Semantic Web"

"In its current state, the Web is often described as being in the Lego phase, with all of its different parts capable of connecting to one another. Those who envision the next phase, Web 3.0, see it as an era when machines will start to do seemingly intelligent things." - John Markoff, The New York Times

With the Semantic Web, computers will scan and interpret information on Web pages using software agents. These software agents will be programs that crawl through the Web, searching for relevant information. They'll be able to do that because the Semantic Web will have collections of information called ontologies.

In brief, the characteristics of Web 2.0 include:

The ability for visitors to make changes to Web pages: Amazon allows visitors to post product reviews. Using an online form, a visitor can add information to Amazon's pages that future visitors will be able to read.

Using Web pages to link people to other users: Social networking sites like Facebook and MySpace are popular in part because they make it easy for users to find each other and keep in touch.

Fast and efficient ways to share content: YouTube is the perfect example. A YouTube member can create a video and upload it to the site for others to watch in less than an hour.

New ways to get information: Today, Internet surfers can subscribe to a Web page's Really Simple Syndication (RSS) feeds and receive notifications of that Web page's updates as long as they maintain an Internet connection.

Expanding access to the Internet beyond the computer: Many people access the Internet through devices like cell phones or video game consoles; before long, some experts expect that consumers will access the Internet through television sets and other devices.

Think of Web 1.0 as a library. You can use it as a source of information, but you can't contribute to or change the information in any way. Web 2.0 is more like a big group of friends and acquaintances. You can still use it to receive information, but you also contribute to the conversation and make it a richer experience.

RFID based enterprise intelligence
The vision of the SixthSense project in the MNS group at Microsoft Research India is the workplace or home of the future where computing is extended to encompass non-computing entities such as people, objects, and spaces to enable rich user experiences
The key technology underlying SixthSense is Radio Frequency Identification, or RFID. The technology comprises inexpensive tags that are attached to objects and readers that are able to read these tags from some distance. RFID is widely used to track the movement of goods through a supply chain. In a typical setting, a reader installed at the entrance of a warehouse can track pallets as they are moved in or out of the warehouse.

The timeout period elapsed prior to completion of the operation or the server is not responding.

This error occured very often in Asp.net Application. There are many solutions to resolve this problem. Lets Try these solutions one by one.
Solutions 1
Try adding a Connect Timeout in the web.config
<add key="DBConnection" value="server=LocalHost;uid=sa;pwd=;database=DataBaseName;Connect Timeout=200; pooling='true'; Max Pool Size=200"/>


Solutions 2
The solution is simple, change the CommandTimeout property of your SqlCommand object.
The Connect Timeout attribute of a connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server.

Sample Code

Dim myCommand As New SqlCommand(sql, myConnection, myTrans)
myCommand.CommandType = CommandType.StoredProcedure
myCommand.CommandTimeout = 0

When 0 is for no limit.
Solution 3
The "Timeout expired" error commonly occurs when an instance of the SQL Server Database Engine is not running, when the server name was typed incorrectly, or when there are network problems or firewalls.

Following are the cause and their solutions
A- Server name was typed incorrectly.
Try again with the correct server name.
B- The SQL Server service on the server is not running.
Start the instance of SQL Server Database Engine.
C- The TCP/IP port for the Database Engine instance is blocked by a firewall.
Configure the firewall to permit access to the Database Engine.
D- Database Engine is not listening on port 1433 because it has been changed, or because it is not the default instance, and the SQL Server Browser service is not running.
Either start the SQL Server Browser service, or connect specifying the TCP/IP port number.
F- The SQL Server Browser service is running but UDP port 1434 is blocked by a firewall.
Either configure the firewall to permit access to the UPD port 1434 on the server, or connect specifying the TCP/IP port number.
G- The client and server are not configured to use the same network protocol.
Using SQL Server Configuration Manager, confirm that both the server and the client computers have at least one enabled protocol in common.
H- The network cannot resolve the server name to an IP address. This can be tested using the PING program.
Fix the computer name resolution problem on your network or connect using the IP address of the server. This is not a SQL Server problem. For assistance, see your Windows documentation or your network administrator.
I- The network cannot connect using the IP address. This can be tested using the PING program.
Fix the TCP/IP problem on your network. This is not a SQL Server problem. For assistance, see your Windows documentation or your network administrator.

Cyclomatic complexity measures the amount of decision logic in a single software module. It is used for two related purposes in the structured testing methodology.First, it gives the number of recommended tests for software. Second, it is used during all phases of the software lifecycle, beginning with design, to keep software reliable, testable, and manageable. Cyclomatic complexity is based entirely on the structure of software's control flow graph.

A set of computers that work together to provide a service. The use of a cluster enhances both the availability and scalability of the service. Network Load Balancing provides a software solution for clustering multiple computers running networked client/server applications.

Comega :Microsoft bridging relational, object, XML data models.

Comega is programming technology, which is intended to bridge the gap between relational, object, and XML data models.

Comega, is described by Microsoft as a strongly typed, data-oriented programming language to bridge semi-structured hierarchical data (XML), relational data (SQL) and the .Net CTS (Common Type System). Additionally, Comega extends C# with asynchronous concurrency abstractions.

Comega tackles the issue of having to write repetitive code based on Microsoft’s ADO (ActiveX Data Objects) .Net technology

ADO.Net is great but it's a lot of repetitive code that you have to write again and again, and Comega provides a direct way to put SQL queries in your code base without the repetitive code

The imperative language model requires the user to determine what the end result should be and also tell the computer step by step how to achieve that result.
It is analogous to asking a cab driver to drive you to the airport and then giving him turn by turn directions to get there.
SQL is different from many common programming languages such as c++ and visual basic because it is a declarative language. Languages such as c++, visual basic, c# and even assembler are imperative languages.

Declarative languages such as SQL, on the other hand let you frame problems in terms of the end result. All you have to do is describe what you want from SQL
Server via a query and trust the database engine to deliver the correct result as efficiently as possible. To continue the cab driver analogy from earlier, in a declarative language you would tell the cab driver to take you to the airport and then trust that he knows the best route.

Scaling Up Versus Scaling Out Database Server?

Scaling Up Vs. Scaling Out. When web application traffic grows there are two ways to handle it. Either Scaling Up or Scale out, what is it specially in case of Database server?

The most common approach to scaling applications is to scale them up. In essence, scaling-up simply means to keep increasing the resources (hardware) available on the server, allowing it to handle more load and user requests. The reason that this approach is so common is because it requires no change to the actual application and all of the data is in one place, which certainly helps reduce complexity and maintenance.

The second and more complex approach is scaling-out. The basic idea is to partition data across several database servers and therefore splitting the load of the application across multiple servers.

While scaling out web servers can be done quite easily, properly scaling out database servers is far more challenging.

What is strong-typing versus weak-typing? Which is preferred? Why?

Strong type is checking the types of variables as soon as possible, usually at compile time. While weak typing is delaying checking the types of the system as late as possible, usually to run-time. Which is preferred depends on what you want. For scripts & quick stuff you’ll usually want weak typing, because you want to write as much less code as possible. In big programs, strong typing can reduce errors at compile time.

Weak typing is where a language allows you to treat blocks of memory defined as one type as another (casting). Languages like C and C++, although statically typed, are weakly typed.

Languages like Perl and PHP are weakly typed because you can do things like adding numbers to strings and the language will do an implicit coercion for you.
Languages like Java, C# and Python are strongly typed - there is no way you can add a number to a string without doing an explicit conversion.

3G is a short term for third-generation wireless, and refers to near-future developments in personal and business wireless technology, especially mobile communications.

3G is include features such as:
·Enhanced multimedia (voice, data, video, and remote control)
·Usability on all popular modes (cellular telephone, e-mail, paging, fax, videoconferencing, and Web browsing)
·Broad bandwidth and high speed (upwards of 2 Mbps)
·Routing flexibility (repeater, satellite, LAN)
·Operation at approximately 2 GHz transmit and receive frequencies

3.5G is better than the much touted `3G' or third generation mobile networks where high speed data, voice and video can be exchanged.
The zippy new technology, is known as HSDPA — High Speed Data Downlink Packet Access — industry jargon which means the download speeds at which video or data can be sucked into a mobile phone could theoretically be as high as 10 mega bits per second (MBPS) — but in practice would be around a half to one-third this speed. It is the next evolutionary step in speeding up today's GSM or Global Services Mobile networks after it has upgraded to EDGE — Enhanced Data Rate for GSM and WCDMA — Wide Band Code Division Multiple Access.

some of famous 3.5g mobiles are nokia n95,nokia 6110 classic

What does the acronym UMTS stand for?
Universal Mobile Telephone System.

What is UMTS?
UMTS is one of the Third Generation (3G) mobile systems being developed within the ITU's IMT-2000 framework.

Before the .NET Framework existed, Windows had two levels of trust for downloaded code. This old model was a binary trust model. You only had two choices: Full Trust, and No Trust. The code could either do anything you could do, or it wouldn’t run at all.

The permission sets in .NET include FullTrust, SkipVerification, Execution, Nothing, LocalIntranet, Internet and Everything. Full Trust Grants unrestricted permissions to system resources. Fully trusted code run by a normal, nonprivileged user cannot do administrative tasks, but can access any resources the user can access, and do anything the user can do. From a security standpoint, you can think of fully trusted code as being similar to native, unmanaged code, like a traditional ActiveX control.

GAC assemblies are granted FullTrust. In v1.0 and 1.1, the fact that assemblies in the GAC seem to always get a FullTrust grant is actually a side effect of the fact that the GAC lives on the local machine. If anyone were to lock down the security policy by changing the grant set of the local machine to something less than FullTrust, and if your assembly did not get extra permission from some other code group, it would no longer have FullTrust even though it lives in the GAC.