table SYSCOLUMNS is the system table (contains all other tables) Creating A New Table The easiest way to create a new table is using SQL Server management Studio.  To implement creation in cod you can create the table without saving and use menu > Table Designer > Generate Change Script to get the SQL code […]

As well as selecting a primary key for each table you may also specify other columns to be indexed. Indexes speed up searching, but slow down adding and deleting of records (indexes are effectively another table that’s created but is hidden from you). Open a table in Design View. Press the toolbar ‘Manage Indexes & […]

Maximum Number Of Databases Databases per instance of SQL Server = 32,767 (http://msdn.microsoft.com/en-us/library/ms143432.aspx) The total number of databases on a particular server is not all that relevant. What is important is how busy each of the databases are (and to a certain degree, the size of the databases in relation to the size of the […]

User roles explained: http://sqlserverpedia.com/wiki/Database_Security_Tutorial