The post I was replying to asked if there was anything to back up my theory that RBAR was slow because of the T-SQL overhead. I posted...

Matt Miller (#4) (8/14/2012)

If this is the kind of programming you're attempting to test - it's not set-based so there would be no reason to do such thing on a...

Phil Parkin (8/14/2012)

---

patrickmcginnis59 (8/14/2012)

---

Shadab Shah (8/12/2012)

---

Jeff Moden (8/10/2012)

---

Shadab Shah (8/9/2012)

---

Hi all,

I have come across various section on this website where it is mention that SQL Server is a set based...

Shadab Shah (8/12/2012)

---

Jeff Moden (8/10/2012)

---

Shadab Shah (8/9/2012)

---

Hi all,

I have come across various section on this website where it is mention that SQL Server is a set based programming language.

My...

SQL_ME_RICH (8/3/2012)

---

patrickmcginnis59 (8/3/2012)

I'm one of those who might create a denormalized database for performance, especially in the case of a web application. In these cases, performance could itself be a...

Michael Valentine Jones (7/30/2012)

---

I'm really not sure exactly what you want to discuss.

There are plenty of people that create denormalized databases and claim they did it for speed, and not...

L' Eomot Inversé (8/2/2012)

---

patrickmcginnis59 (8/2/2012)

---

Speaking for myself, I'm relatively untroubled by missing questions like this. I always answer them based on what I know at the moment of answering, without...

bitbucket-25253 (8/2/2012)

---

I am rather surprised at the low percentage of correct answers.

And the implications this could have to those...

Here's one way!

-- set up our test table and variable

create table test1 (id int, dateref datetime, groupid int)

insert into test1 (id, dateref, groupid) values (17, '2012-06-20 10:00:00.000', 463)

insert into test1...

Jeff Moden (7/18/2012)

---

Nah... it's me. Well, kind of... Original Post asked for...

I have a table which holds the next Invoice Number. What...

gerard-593414 (7/18/2012)

---

OK thanks for that.

But I dont understand how the database Engine will prevent (without additional error checking or rules) TWO ACCOUNTS WITH THE SAME NUMBER BEING ADDED. Two selects...

How about:

SET @VAR = SELECT VALUE FROM TABLE WHERE ID = 1

then

UPDATE TABLE SET VALUE = @VAR + INCREMENT WHERE ID = 1 AND VALUE = @VAR

Obviously you'd be prepared...

tinausa (7/13/2012)

---

Thanks. I did not think this was necessary info, so I did not mention it earlier.

But this query is an ASP.NET app where the user will enter from and...

I've been toying around with this construct:

CREATE TABLE [dbo].[TEST1](

[ID] [VARCHAR](10) NULL,

[VALUE] [int] NULL

)

GO

INSERT INTO TEST1 (ID, VALUE) SELECT 1, 10

SELECT 'PRE' LABEL1, * FROM TEST1

DECLARE @SAVE1 INT

UPDATE TEST1

SET VALUE...

Just wondering, why can't you just do

SELECT DISTINCT ES.locname1, ES.locname2

FROM dbo.ExternalSource ES etc etc

when selecting for your unique values at level 2?