Tag Archives: T-SQL

SQL Azure Incompatibilities list

by on 20100602 in Microsoft SQL

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 your code on SQL Azure.  The following is a list of items that are well documented, but I want to create a more complete list.  [...]

 

Comments ( 2 )

SQL Azure DATETIME Functions

by on 20100531 in Microsoft SQL

  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 machine the SQL server was running on.  But what results will you get when you’re dealing with SQL Azure? The server(s) are all virtual. They are all based [...]

 

Comments ( 1 )

SQL 102-SELECT * Overhead

by on 20100512 in Microsoft SQL

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 evil. the more data you ask for, the longer it takes to return that data extra paging table locking hinders future attempts to create a [...]

Comments ( 2 )
Older Entries »