Maximum Capacity Specifications for SQL Server 2005

there is no row limit in the sql sever 2005 ...

find more in below link ...

http://msdn2.microsoft.com/en-us/library/ms143432.aspx



1. 32,767 database per instance of sql server
2. 2 billion tables per database
3. 1024 columns per table
4. 65,535 secondary datafiles per database
5. 256 filegroup per database
6. bytes per row - 8060
7. clustered index per table - 1
8. columns per index - 16
9. columns per select statement - 4096
10. files per database - 32,767
11. maximum file size of data - 32 TB
12. nested subqueries, transactions, Stored Procedures, triggeres - 32
13. rows per table - limited to storage space
14. tables per select statement - 256
15. Non clustered index - 249

If u want laugh continuously ....just see the links

போக்கிரி(பேக்கரி)

http://www.youtube.com/watch?v=h8bOpkqJAPA - Part I
http://www.youtube.com/watch?v=_pNK9jT2NWc - Part II
http://www.youtube.com/watch?v=ffqh8uAdqhA - Part III

Validation using asp.net validation control ....

These are the examples how to validate the input by using RegularExpressionValidator ...


Expressions --------- > Validation

\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)* ---------> E- Mail validation

http(s)?://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)? ---------> webURL validation with htttp

([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)? ---------> webURL validation without htttp

\w{4}.* --------->Atleast 4 digits validation ( password )

^\d{6}$ ---------> Atleast 5 Numeric values ( pincode )

[a-zA-Z0-9\-_]{3,15} 3 to 15 range ... a to z lower & upper case allowd plus '-' allowed u
should a ' &' and other spl char means u should add like this
[ a-zA-Z0-9\-&*$_]

.Net FAQ ( o4g )

.Net FAQ ( o4g )

http://forum.only4gurus.org/index.php?showtopic=1756&hl=computer+architecture

.Net collection

http://www.giuciao.com/books/sort.php?by=dotNET


http://www.dotnetuncle.com/Framework/27_dotnet.aspx


http://www.defaultdotaspx.com/Default.aspx

File DownLoad in asp.net ....

if u have upaloaded file path in dbtable means u can download that file using the following code .....

Put a Link Button in Gridview ....



tr
td align="left"
b Attachment : /b
asp:LinkButton ID="lnkbtnpath" runat="server" CommandName="test" CommandArgument=%#Eval("Filepath")% CausesValidation="false"
DownLoad
/asp:LinkButton
/td
/tr



call that file path in Rowcommand Event of Gridview ......

Protected Sub gvAppealperson_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles gvAppealperson.RowCommand
Dim filepath As String
Dim fileobj As FileInfo

' checking the Linkbutton's commandname is valid or not
If e.CommandName = "test" Then

' getting the commandarugment as path from database ( <%#Eval("Filepath")%>) in a string
filepath = e.CommandArgument

' assigning that string to FileInfo's object
fileobj = New FileInfo(filepath)
Response.Clear()

'Add the header that specifies the default filename for the Download/SaveAs dialog
Response.AddHeader("Content-Disposition", "attachment; filename=" & fileobj.Name)

'Add the header that specifies the file size, so that the browser can show the download progress
Response.AddHeader("Content-Length", fileobj.Length.ToString())

' Specify that the response is a stream that cannot be read by the client and must be downloaded
Response.ContentType = "application/octet-stream"

' Send the file stream to the client
Response.WriteFile(fileobj.FullName)
Response.Flush()

' Stop execution
Response.End()
End If
End Sub