I think a Dates table would come in very handy here. You can create one something like this:

WITH Numbers(N) AS (

SELECT

ROW_NUMBER() OVER (ORDER BY c1.name)

FROM

master.sys.columns c1

CROSS JOIN

master.sys.columns c2

)

SELECT

DATEADD(d,N,'19000101')

INTO

Dates

FROM

Numbers

WHERE

N <=...

Kelsey Thornton (3/1/2012)

---

I don't dispute there are many reasons why this might be desirable, or even required.

My point was simply that a little background information into why the port number...

(1) Security, to prevent attacks on the default port....

I've seen backups succeed when the database has corruption in it. That's why it's important, periodically at least, to test that you can restore your databases and run DBCC...

You could use an OUTER JOIN instead, although I suspect that you may end up with the same execution plan. Have you considered indexes on the srno column in...

But your original post was about splitting the update into batches. Have you tried doing that?

John

Actually, the...

You could do that, yes, but you're only explicitly doing something that would be implicitly done anyway. The original poster says that the whole thing is done in one...

(At least) two ways of working this out:

(1) Use Profiler to run a trace while you use the GUI, so that you can find out what commands were executed in...

Since there is no question here, I'm guessing that you want someone to write the stored procedure for you? That's not generally the way it works. Please have...

Matt Miller (#4) (2/29/2012)

---

The "no effect" is focusing on how much is logged. You're going to log all changes in full and bulk-logged, so it will not changed how...

If it's all one transaction, batching it will have no effect. The transaction will...

Ananda

Just as a matter of interest, why are you wrapping a SELECT statement in an explicit transaction?

John

It's best to let your presentation layer handle things like this. If you have to do it in the database layer, you can use FOR XML to concatenate the...

It's worth having a look in the default trace next time it fails to see whether the activity is recorded in there. Another thing that's worth doing is piping...