Back To Basics: Tables, without them we have nothing to do
Tables are the core of any database platform. Without tables we would be able to process data, but we would have no way to store the data. In the simplest terms tables look like Excel sheets. They both have columns and rows.
SQL Server 2008 changes the way that CONVERT/CAST works
Normally when running a query against a table and using a CAST or CONVERT function against a datetime field any index is made useless. In SQL Server 2008 this problem is fixed. Microsoft has come up with a way for SELECT statements which use CAST or CONVERT against a column of the datetime datatype to […]
New INSERT syntax in SQL Server 2008
One of the very cool new feature which SQL Server 2008 gives us is an change to the INSERT statement. Now you can specify multiple rows to insert into a table from a single insert command.
New Article: Tips for scheduling and testing SQL Server backups
Get expert advice for scheduling backup jobs in SQL Server via SQL Server Agent using a crafted BACKUP DATABASE command or maintenance plan. If you’re using SQL Server Express Edition, you’ll learn how to schedule backups with Microsoft Windows Task Scheduler. This tip also shows you how to test your backups for successful restores and the best method for securing SQL Server backups.