Gift Peddie (10/27/2009)

---

I was working along today and ran into something interesting with SQL Server that I didn't know before. It's not obscure or only limited to specific environments or...

Most of our databases servers are running SQL Server 2005. We have one server running SQL Server 2000 but are hoping to retire that application by moving it into...

I'd say submit it. Don't worry about the flaming. You have already piqued my curiosity.

Your question is pretty open-ended. It would help us in helping you if you could provide more specifics regarding your problem. Please take the time to also read...

Mark Marinovic (10/5/2009)

---

Gotcha - and...

I'll second this as...

Bob Hovious 24601 (10/26/2009)

---

Jack, the last time I swapped emails with Flo, they were getting ready to launch a big project at his place of work. He told...

Nope, washed out...

First, look up SET ROWCOUNT in BOL (Books Online, the SQL Server Help System), it will explain everything you need to know about SET ROWCOUNT that would want to know...

Don't you just love people that only read half the error message?

2Tall (10/26/2009)

---

Hi to all. I am attempting to configure an Endpoint in a virtual lab.

CREATE ENDPOINT [Mirroring]

AUTHORIZATION [lab\sql]

STATE=STARTED

AS TCP (LISTENER_PORT = 5034, LISTENER_IP = (x.x.x.1))

FOR DATA_MIRRORING (ROLE = PARTNER,...

LOOKUP_BI-756009 (10/26/2009)

---

Thanks All,

Matt : Yes I knew that I had to include 'Use databasename , go , and then the Select statment but was not too sure how to do...

I would write the code more like this:

DECLARE @RowsUpdated int;

SET ROWCOUNT 4000000;

WHILE 1 = 1

BEGIN

UPDATE t1

SET Qty = t2.Qty

...

Krasavita (10/26/2009)

---

SET ROWCOUNT 4000000;

WHILE 1 = 1

BEGIN

UPDATE t1

SET Qty = t2.Qty

FROM dbo.Table1 t1

INNER JOIN dbo.Table2 t2 ON t1.KU = t2.KU

WHERE t1.Qty IS NULL;

IF @@ROWCOUNT < 4000000 BREAK;

END;

Why are you...

Slight change to my original code, might be nice to know if the growth is a precentage or not.

select

db.name as DBName,

mf.name as...