Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » transact-sql   (RSS)

New T-SQL 2012 scalar functions (all but 1) work in SQL Azure

Back when I was saw SQL Azure was producing an @@version string that mentioned version 11 (that's SQL Server 2012's major version number), I'd started looking at the version number every week or so. And looking for SQL Server 2012 functionality Read More...
Posted 11 februarie 2012 09:44 from Bob Beauchemin's Blog | (Comments Off)

SQL Denali T-SQL features in SQL Azure now

Earlier this month I noticed that SQL Azure, with the latest upgrade has a version of 11...something (actually 11.0.1467.26, to be exact). And I wondered, aside from the long-touted new spatial library, if there were any Denali T-SQL enhancements that Read More...
Posted 22 septembrie 2011 11:46 from Bob Beauchemin's Blog | (Comments Off)

SQL Azure "version 11" arrives on my server

I've been trying this out every day or so since I'd heard about the update (originally named the July 2011 Service Release ), but I'd forgotten about it for about a week. So I don't exactly know when this happened on my SQL Azure server. Read More...
Posted 5 septembrie 2011 21:44 from Bob Beauchemin's Blog | (Comments Off)

Window clause, range specification, and missing values

In the previous post , I insinuated that allowing LAG/LEAD to be sensitive to value RANGEs might help with series of data with missing values. It won't do that unless there's some logic that allows the offset that LAG/LEAD uses to be calculated Read More...
Posted 18 august 2011 12:12 from Bob Beauchemin's Blog | (Comments Off)

Remember: LAG function in SQL Server Denali uses rows

You've heard my rant before "measure what you think you are measuring". If not, follow the link . Here's an example using the LAG function, new in SQL Server Denali, to measure sales trends. We'll start with a view from AdventureWorksDW2008R2 Read More...
Posted 17 august 2011 13:52 from Bob Beauchemin's Blog | (Comments Off)

Denali window clause followup question

So, quickly on the heels of the first window clause and last_value() question, came a followup: OK smartie, why does last_value work fine here? I didn't have to change from the default window. What gives? select SalesPersonID, SalesOrderID, first_value(SalesOrderID) Read More...
Posted 1 august 2011 12:04 from Bob Beauchemin's Blog | (Comments Off)

An FAQ about the window clause in SQL Server Denali

I've been working with the new Denali T-SQL windowing functionality and ran into someone who asked about this "problem". It's almost sure to become an FAQ. Why does last_value not always "work right"? Take, as an example, the Read More...
Posted 1 august 2011 10:47 from Bob Beauchemin's Blog | (Comments Off)

TRY CATCH THROW: Error handling changes in T-SQL

When SQL Server 2005 introduced BEGIN TRY and BEGIN CATCH syntax, it was a huge improvement over the previous error handling based on @@ERROR check after each statement. Finally, T-SQL joined the rank of programming languages, no more just a data access Read More...
Posted 22 noiembrie 2010 19:42 from rusanu.com | (Comments Off)

Using tables as Queues

A very common question asked on all programming forums is how to implement queues based on database tables. This is not a trivial question actually. Implementing a queue backed by a table is notoriously difficult, error prone and susceptible to deadlocks. Read More...
Posted 26 martie 2010 21:02 from rusanu.com | (Comments Off)