t-sql

t-sql

SQL Azure Incompatibilities list

While 99% of what you do in SQL is supported in SQL Azure, there is a small list of things you'll have to redesign, or at least reconsider before implementing

t-sql

SQL Azure DATETIME Functions

Microsoft SQL has always included a number of date and time functions. These results of these functions were always based on the operating system for the

Posted in: Microsoft SQL

SQL 102-SELECT * Overhead

How many of you have heard me rant against using "SELECT * FROM tableName"? If you have I'm sure you've heard me mention the following reasons why SELECT * is

t-sql

Microsoft SQL Reporting Services for PHP

In an outstanding move on Microsoft's part, Developers have released an open-source project to help PHP developers integrate SQL Server Reporting Services from

t-sql

Introducing Microsoft SQL Server 2008 R2 eBook

With the release of SQL 2008 R2 (Artoo), there's plenty to learn in order to upgrade your skills. Microsoft Press has released a free eBook that can help you

microsoft sql

Converting VARCHAR to DATETIME

Recently a post was made on LinkedIn asking how one would convert a date stored in a VARCHAR field could be converted to a DATETIME so date math could be

t-sql

Code Review

I'd like to start a new series that will help you learn some of the techniques I've used in the past. Some of these techniques are useful, some aren't. Using

t-sql

INDEX ON partition_scheme_name, filegroup_name, and default

Consider the CREATE INDEX statement below: CREATE INDEX ix_tableName_columnName ON tableName (columnName) ON { partitionSchemeName (columnName) | fileGroupName

t-sql

ASC, DESC, and Filtered Views

I know I've covered quite a bit of the CREATE INDEX statement, but there is even more to learn. Today I want to cover ASC, DESC, and the WHERE clause for

t-sql

Beginning Spatial with SQL Server 2008

I picked up this book as an introduction to the new geographic datatype in SQL 2008. I had played around with Google maps, and plotting WiFi hotspots I'd

t-sql

SQL 102 – Indexes With Included Columns

I've shown you how to create indexes, CLUSTERED versus NONCLUSTERED indexes, today I want to build on that. Let's say you have a lookup query that takes names,

t-sql

Code to Write Code

I've read "When you start writing code that writes code for you, you've moved up from a beginner to a professional." Today I'd like to walk you through an