Florian Reischl (11/7/2009)

---

Hmm - I just had a brain trust here try to give me the...

One more question you might need to figure out (in addition to Jeff's questions): if you stretch out the time it takes to do these updates - do you...

Have you in fact verified that remote connections are allowed in SQL Server Surface Area Config tool? Using OPENQUERY treats the actual connection as "remote" even if you happen...

Two thoughts:

- if your update is fast enough, does it really matter that it might lock the table? How many times do you plan on doing this?

-...

Or - use the reports and get all tables at the same time, broken down by type of space, (break it out by partition if you like), with an option...

Glen Harland (10/28/2009)

---

It is the developer's responsibility to ensure that the correct value is used to update, and I can sympathize with your desire for an error message to keep...

By the way - retrieving 4Million rows is bound to take some amount of time, espeically if you're pulling that "over the wire", to something like a report.

You may care...

You must be referring to the VBScript "superman" objects...I had a particularly ugly offender, who would define one single object at the top and reinstantiate...

George Parker-378530 (10/23/2009)

---

All BACKUP LOG with truncate_only does is remove the commited transactions from the log. It doesn't do anything to make the size of the log data file smaller....

Also - how much data is in the source table(s)? the 90 records are summary data, so you could be pulling out 90 records, made up of 1000's of...

If the total of the timediffs is the intended result - why go through all of that trouble? In every case - that's going to be:

Max(stop time) - Min(start...

RBarryYoung (10/17/2009)

---

Matt Miller (#4) (10/17/2009)

---

Jeff Moden (10/17/2009)

---

Matt Miller (#4) (10/17/2009)

---

Anything involving the "outside world" IMO just incentivizes all of those cruel ways some folks love to torture SQL Server (e.g....

Jeff Moden (10/17/2009)

---

Matt Miller (#4) (10/17/2009)

---

Anything involving the "outside world" IMO just incentivizes all of those cruel ways some folks love to torture SQL Server (e.g. let me use my...

I'll duck in here for a minute.

I have to disagree for a second there with extending T-SQL into areas it "doesn't belong in". Jeff - I was with you...

Steve -

Is not having direct link to ask SSC from here a concious decision, or just something that hasn't happend quite yet? You know, in the navgation areas,...