dwain.c (7/9/2013)

SELECT TOP 10000000 @Bitbucket=ROW_NUMBER() OVER (ORDER BY (SELECT CAST(0 AS NVARCHAR(MAX))))

FROM sys.all_columns ac1, sys.all_columns ac2, sys.all_columns ac3

But oddly it seems to perform in the same approximate time...

I suppose it comes down to the majority of cases...

by the way I had a laugh over the $ controlling the order of things 😀

The only thing I could think of is the size of the datatype used and I don't think that would have any noticeable difference on the speed.

Having a...

wolfkillj (7/9/2013)

---

Carlo Romagnano (7/9/2013)

---

L' Eomot Inversé (7/9/2013)

---

Nice straightforward question. Good to see a question about another new feature in SQL 2012.

However, introducing a weird ODBC function into T-SQL seems...

Hi

Another one to add to the mix. Not any quicker, but slightly less in the IO stats

DECLARE

@StartDate DATETIME2(7),

@EndDate ...

No problem ... I'm glad it helped. It based on the work of smarter people than me.

Essentially it came down to a gaps and islands problem. This ...

Hi

I think the following will do the trick for you

with adBrandPostion AS (

select AdDate, AdTime, FK_StationId, brandflag

,COUNT(*) OVER (PARTITION BY BrandFlag, FK_StationID, AdDate) NumAds

,ROW_NUMBER() OVER (PARTITION BY BrandFlag, FK_StationID, AdDate...

Hi

Unfortunately this will leave double...

Hi

Not sure if this is anywhere close to what you are experiencing, but recently I saw a situation where a cluster was moved to new (faster and better) hardware. ...

I like it ... seems more readable

Hi

A while back I got told by someone to avoid using additional functions on the XML if possible as they can have a big impact on the performance.

For example on...

Jeff Moden (6/27/2013)

---

mickyT (6/27/2013)

---

To be honest I thought it would perform like a dog:-). but using the following setup to test it and using a physical Tally table rather than...

Hi

Playing around with this, I came up with the following variation

WITH

Tens (N) AS (SELECT 0 UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL...

Here's a recursive CTE method as a iTVF that could work.

I would like to come up with a none recursive method, but brain fade is setting in and I'm not...