Differences between varchar and nvarchar in SQL Server
The broad range of data types in SQL Server can sometimes throw people through a loop, especially when data types like varchar and nvarchar seem to be highly interchangeable. Learn how these two data types are stored differently, how to mix and match them and what changes were made to varchar and nvarchar in SQL Serve 2005r.
Clustered and non-clustered indexes in SQL Server
Rules for using a clustered index vs. a non-clustered index in SQL Server are tough to decipher. Discover the fundamentals to consider when making your choice, along with an overview of tradeoffs and proper index implementation.
Temporary tables in SQL Server vs. table variables
Once you've written your T-SQL code, it's time to execute it. If you are going to use a table to store data temporarily, find out about your options while learning the pros and cons of using temporary tables vs. table variables in SQL Server.
Stored procedures vs. functions
Sometimes, the debate between using stored procedures and functions is irrelevant, as both can often accomplish the same tasks. However, there is a fundamental difference between the two - stored procedures are designed to return their output to the application.
Stored procedures vs. dynamic SQL: When should you use each?
Stored procedures and dynamic SQL each have their place in SQL Server. You must consider the parameters used, the tables being queried, the number of databases and so forth. There is often a definitive answer when deciding to use either stored procedures and dynamic SQL