Not sure I've understood correctly here, but if I have then you're a sysadmin on the instance - I assume you are since you need that, or something close it,...

Devanand

No it won't - provided that the operations performed by your stored procedures are only on the database and not on any drives in the operating system.

John

Phil Brammer (3/1/2012)

---

The SQL Browser service is only for named instances. If you change the default port of the default instance, you will always have to specify the new...

okbangas (3/1/2012)

---

I tend to disagree. Yes slammer hit 1433, but in my humble opinion you do not change port numbers due to security issues. If you do read about slammer,...

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