Recently I navigated through the Maximum Capacity Specifications for SQL Server 2008
I found something interesting which says that,
Max columns per 'non wide' table : 1024
Max columns per 'wide' table : 30,000
Where non wide tables are regular database tables and wide table is a table which uses column sets and sparse columns. It still follows the same width restrictions per row i.e. 8019 bytes. So you would typically use it only when most of your columns data in a particular row is NULL.
Refer to below link for more information.
Special Table Types
Reference: DP ( http://dptechnicalblog.blogspot.com/ )
I found something interesting which says that,
Max columns per 'non wide' table : 1024
Max columns per 'wide' table : 30,000
Where non wide tables are regular database tables and wide table is a table which uses column sets and sparse columns. It still follows the same width restrictions per row i.e. 8019 bytes. So you would typically use it only when most of your columns data in a particular row is NULL.
Refer to below link for more information.
Special Table Types
Reference: DP ( http://dptechnicalblog.blogspot.com/ )
------------------- below code for common js file -----------------
ReplyDelete//*********************
// showtimer()
//*********************
function showtimer ()
{
if(strTime>0)
{
if(cnt>1)
{
displayalert();
}
cnt=cnt+1;
timerID = setTimeout("showtimer()",strTime*60*1000);
}
}
/* ************************************************************************
function displayalert Display Alert Message before User Session Expires
*************************************************************************/
function displayalert()
{
if (window.opener)
{
self.close();
return false;
}
var thepage;
thepage="/showexpired.asp";
thetitle="Exp";
var w = 300;
var h = 200;
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
windowprops = 'width='+w+',height='+h+',top='+wint+',left='+winl+',location=no,scrollbars=no,menubar=no,toolbars=yes,resizable=no';
window.open(thepage, thetitle, windowprops);
}
------------------- below function call should be in asp,aspx pages-----------------
< script LANG UAGE="JavaS cript" >
var strTime,cnt;
cnt=1;
strTime="30";
showtimer();