1. Everyone of us know that, In SQL Server 2008 maximum we can create only 1024 columns in a table. But also we can create 1,00,000 more Sparse columns. These columns will not be counted in 1024 columns. So totally we can create maximum 1,00,000 Sparse columns and 1024 regular(Non Spare) columns.
2. @@ROWCOUNT can work for maximum of 2 Billion records. It we want to count more than 2 Billion, we need to use @@ROWCOUNT_BIG.
3. SQL Server was developed in C and C++.
4. The GUID which we generate from our computer can not be generated from any other computer in the world.