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...

Well, I can't take...

You don't need the dynamic sql in the cursor solution if you change the the table from sys.sysfiles to sys.sysaltfiles.

But I'd look at the code I provided above.

Give this code a try:

select

db.name as DBName,

mf.name as DBFileName,

mf.growth as Growth

from

sys.databases db

...

Change this:

set @DbGrowth =(select top 1 cast((growth) as varchar(30)) from sys.sysfiles)

to this:

set @DbGrowth =(select top 1 cast((growth) as varchar(30)) from sys.sysfiles where name = @DbName)

Please note, this is untested. ...

Matt,

Nice explanation. I'm not too familiar with the XML features, but when I took a closer look at the the data I could see that the reason book2 was...

Jack, I know what that is like. Your family will be in our prayers.

sqlservercentral.w.micmurphys (10/23/2009)

---

join is shorthand for inner join, there are other kinds of joins though: LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, so if you wanted to be explicit, you'd...

I do find that quite sexist. I happen to work with a group of female developers and they work quite while and do their research. I have also...

Betty and I bought Proud Mom and Dad sweat jackets Thursday and were wearing them today coming back from the grocery store. We were coming up in the elevator...

One of her fellow soldiers was sitting next a lady who at the end of the flight handed her (not Kassondra) a note that said "thanks for serving" along with...

Well, the graduation ceremony was great. We got to spend quite a bit of time with Kassondra Thursday and Friday, but it was a bit difficult saying goodbye again...