|
|
Browse by Tags
All Tags » t-sql » sql server 2008
-
My colleague Jamie Thomson posted an intriguing article on DRY SQL which you can read all about here. It raised a number of questions for me so I thought I’d post my own response to it.
Here is a list of some of these questions that sprung to my mind. Did the code change come up with the same query plan? Were the tables indexed in ...
-
SQL Server 2008 definitely has loads of improvements over previous versions, however there are some cool new features that are overlooked which could improve productivity and ease usability, so they are definitely worth having a look at.
1. Compound Operators
This new feature do make some interactions ...
-
Back in June I talked about some T-SQL enhancements that are coming our way in SQL Server 2008. One of those things is the ability to define multiple rows in an INSERT statement like so:insert t1 values (@i),(@i+1); Very cool stuff. Some people seem to be naming this feature 'row constructors'. Well Greg Duncan has been ...
-
SQL Server 2005 includes the WITH CUBE and WITH ROLLUP syntaxes that are used to display summary information for combinations of columns in the GROUP BY clause. That's useful functionality but it didn't provide particularly fine-grained control over what summaries were returned. Essentially it was all-or-nothing.
In katmai, the next ...
-
A very short post here showing some of the new T-SQL constructs in katmai.
Check out the following code snippet:declare @i int = 1;set @i += 1; create table t1 (col1 int);insert t1 values (@i),(@i+1); There are actually three syntax enhancements in there. Can you spot them? No? Let me fill you in:Initialisation at the same time as ...
|
|
|