Teratrax - teratrax.com - TeratraxTeratrax |
General Information:
Latest News:
Understanding VARCHAR(MAX) in SQL Server 2005 & 2008 14 Apr 2012 | 02:14 am
In SQL Server 2000 and SQL Server 7, a row cannot exceed 8 KB in size. VARBINARY column can only store 8000 bytes (assuming it is the only column in a table), a VARCHAR column can store up to 8000 cha...
SQL Server Data Types and Ranges 14 Apr 2012 | 02:11 am
Quick reference for SQL Server data types Applies to: SQL Server 2000, SQL Server 2005, SQL Server 2008 Saving disk space is not the only benefit of properly selected data types for SQL Server columns...
Connecting to SQL Server 2005 and SQL Server Express 14 Apr 2012 | 02:09 am
Protocol configuration and firewalls play an important role when you are trying to establish a connection to any database server. SQL Server 2005 and SQL Server 2005 Express are no exception. The grea...
Understanding SQL Server Backup Types 14 Apr 2012 | 02:00 am
Applies to: SQL Server 2000, SQL Server 2005 Database backups are at the core of any SQL Server disaster recovery planning for any production system. Backups may be used to provide a means of recovery...
sp_spaceused: Determine SQL Server table size 11 Apr 2012 | 12:10 am
Have you ever wondered which tables take the most disk space in your database? Using the...
