I think that the best thing about ITVF versus direct access to views is that you can enforce some parameters to be provided.  So even if views (indexed or not)...

Any particular reason that sp_getapplock wasn't used for this implementation?

http://msdn.microsoft.com/en-us/library/ms189823.aspx

Really depends. If you can run the profiler for extended periods, you can still easily miss something which is only used once a year.

I tend to rely...

jay-h (6/15/2012)

---

Cade Roux (6/15/2012)

---

bwillsie-842793 (6/15/2012)

.... This is very much due to the current state of wealth redistribution where wealth is being more and more redistributed to the top (to people...

bwillsie-842793 (6/15/2012)

In the US 99% of those demanding "wealth redistribution" do so based on their wants and not on their needs. It's not the greed of others that is...

I agree with the first part, but...

I don't feel guilty for being part of the technological forces which cause shifts, but I feel a tremendous anger towards those who exploit it with their greed and lies.

Our...

Paxman (9/15/2011)

---

By looking at the other posts, I think that some are confusing Primary Keys, which should only be used for referential integrity and not used by humans, and Reference...

For independent client generation, we had good success with COMBs: http://www.informit.com/articles/printerfriendly.aspx?p=25862

The problem you mention with waiting on the database for SCOPE_IDENTITY() can be mitigated now (at least for...

The problem is not Y, but LY - Hungarian has a special LY letter: http://en.wikipedia.org/wiki/Hungarian_alphabet

Apply with:

EXEC sys.sp_addextendedproperty

@name=N'name',

@value=N'value',

@level0type=N'USER',

@level0name=N'databaserole'

Query with:

SELECT *

FROM ...

AlistairNY (4/12/2011)

---

Well, in my application it seems about the same as the Outer Apply method. I only need the previous (not the next) day's value, for 5000 series of about...

_ms65g_ (4/12/2011)

No, if we change the DENSE_RANK with ROW_NUMBER the result will not be correct. You can rum my first script at my first post with row_number. So you will...

;WITH C AS

(

SELECT seq_nbr, k,

DENSE_RANK() OVER(ORDER BY seq_nbr ASC) + k AS grp_fct

FROM [Sample]

...

I don't think so, and I wasn't even able...