Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
Understanding and working with date/time data types in SQL Server can be complicated. Learn the basics of working with DATETIME and SMALLDATETIME in SQL Server 2005, along with an overview of TIMESTAMP, a data type often confused with these two primary date/time data types.
T-SQL performance problems and solution
SQL Server performance problems don't stem entirely from database issues. Poorly written T-SQL code can also impact your SQL Server. Rather than jumping to conclusions about memory and CPU utilization, learn about common T-SQL performance problems and solutions.
Using MAX data types in SQL Server
If you are looking for a data type capable of handling large amounts of data, the MAX data type in SQL Server can handle 2GB of data while remaining compatible with all intrinsic SQL Server string functions.
Optimize T-SQL data types in SQL Server
Data types can seem inconsequential in the grand scheme of things, but they have a huge impact on SQL Server performance as the system grows. Find out how they can affect your I/O, RAM and CPU, and ensure that you've optimized T-SQL data types in your SQL Server environment.
SQL Server stored procedures tutorial: Write, tune and get examples
SQL Server stored procedures, sometimes called the work horse of the database, provide an important layer of security between the user interface and database. However, the process of grouping T-SQL statements to create stored procedures can be complex. Learn the basics for writing stored procedures, along with methods for tuning them