Get Table Size in SQL Server | Query to Get Table Size in SQL Server 2008

Introduction:

Here I will explain how to get table size in SQL server or query to get table size in SQL server 2008.

Description:

In previous articles I explained Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to get table size in SQL server.

SQL Server - How to Get Database Size in SQL Server 2008

Introduction:

Here I will explain how to get database size in SQL server or query to get database size in SQL server 2008.

Description:

In previous articles I explained show time difference in minute ago hour ago etc in SQL Server, get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to get database size in SQL server.

what is authorization in asp.net | authorization rules in web.config to allow or deny resources to particular user or role in asp.net.

Introduction:

In this article I will explain what is authorization in asp.net, uses of authorization and I will explain setting authorization rules in web.config to allow or deny resources for particular user or role in asp.net.

Description:

Today I am writing this post to explain about authorization concept in asp.net. In one of the interview interviewer has asked question like what is authorization in asp.net and how we can use authorization concept to allow or deny resources to particular user or role in asp.net.

C# - Difference between String and Stringbuilder in C#, Asp.net

Introduction

Here I will explain what is difference between string and stringbuilder in c# using asp.net.

Description

In previous articles I explained different types of constructors in c#, difference between overloading and overriding in c#, Delegates in c# with example, difference between datareader, dataset and dataadapter in c# and many articles relating to interview questions . Now I will explain difference between string and stringbuilder in c# using asp.net.

C# - Difference between Throw and Throw ex in C# Asp.Net

Introduction

Here I will explain what is the difference between throw and throw ex in c# using asp.net.

Description

In previous articles I explained Different types of polymorphism in c#, Difference between array and arraylist in c#, can function return multiple values in sql server, Difference between char varchar and nvarchar in SQL Server, Joins in SQL Server and many articles relating to interview questions, SQL Server. Now I will explain difference between throw and throw ex in c# using asp.net.

C# - Insert Data into Database using WCF Service in Asp.net

Introduction

Here I will explain how to insert data into SQL Server database using wcf service in asp.net using C# and VB.NET.

Description

In previous articles I explained Show tooltip for gridview header columns, jQuery change tooltip style in asp.net, Add tooltip to dropdownlist items in asp.net, Create simple tooltip with jQuery UI plugin, Asp.net Interview questions, Highlight Gridview records based on search and many articles relating to Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to insert data into SQL Server database using wcf service in asp.net using C# and VB.NET.

jQuery Ajax Submit Form without Page Refresh using JSON in Asp.Net

Introduction: 

Here I will explain how to use jQuery to submit form without page refresh using ajax in asp.net or jQuery submit form without page reload using jQuery ajax  in asp.net  using c#, vb.net.

Description:
  
In previous articles I explained integrate Facebook login authentication, integrate twitter login authentication, jQuery randomly change color of div and many articles relating to jQuery, asp.net, c#, vb.net. Now I will explain how to submit form without refresh or reload page using jQuery in asp.net.

C# - How to Count Number of Online Users in Asp.Net Using C#, VB.NET

Introduction

Here I will explain how to count number of online users of website in asp.net using C# and VB.NET or how to get number of online visitors of website in asp.net using C# and VB.NET.

Description

In previous articles I explained get count of visitors website in asp.net, jQuery cascading dropdown list example in asp.net, jQuery show progressbar in button click in asp.net, Asp.net Interview questions, Joins in SQL Server and many articles relating to Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to count number of online visitors of website in asp.net using C# and VB.NET.

C# - Count Number of Visitors in Website using Asp.net in C#, VB.NET

Introduction

Here I will explain how to count number of visitors to website in asp.net using C# and VB.NET or find or get number of visitors for a website in asp.net using C# and VB.NET.

Description

In previous articles I explained Asp.net Interview questions, Export Gridview data to PDF, Send values from one page to another page using QueryString, Joins in SQL Server, Highlight Gridview records based on search and many articles relating to Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to count number of visitors to website in asp.net using C# and VB.NET.

To get number of visits for website we need to use methods in Global.asax file for that first add Global.asax file in your application

SQL Server Add Auto Increment Column or Set Auto Increment Column SQL Server Management Studio

Introduction:

Here I will explain how to set or add auto increment column in SQL server or create auto increment column in SQL server 2008 using management studio.

Description:

In many situations we will insert records in table during that time we need to set unique value for that record if we use auto increment column then automatically generate unique number for newly insert record in table (Like generate EmployeeID of each employee whenever employee record inserted).

To set auto increment column in table we have different methods