EdVassie (7/19/2010)

---

In the main, you have to accept the poor code that some third-party products give to you.

If performance is really killing you, then escalate this to management. Give...

Michael Valentine Jones (7/9/2010)

---

It appears from this that only dbcreator and securityadmin are required:

SharePoint Server 2007

Plan for administrative and service accounts (Office SharePoint Server)

http://technet.microsoft.com/en-us/library/cc263445(office.12).aspx

I never looked into this before. ...

Steve,

I use to be a SharePoint fan but now that I have to be in charge of the SQL Boxes SP is a bit of a nightmare. Not only...

UGGGHHHH! I hate that rascally wabbit of a software vendor.

I was afraid I would get that kind of feedback.

Thanks Lynn & Grant for chiming in.

UPDATE:

After some digging around and some aksing around I have discovered that much of the SQL code used in our application is being auto-generated. When a developer adds some...

Eugene Elutin (7/7/2010)

---

David Portas (7/6/2010)

---

...

Is that the real statement actually being issued or did you simplify it by substituting literal values where there would have been variables? Assuming there are...

David Portas (7/6/2010)

---

YSLGuru (6/30/2010)

---

With the above table as the example, why the heck would someone construct an update statement like this? It just doesn;t make any sense to me...

You know its funny you should mention this because this is exactly...

Dan.Humphries (6/30/2010)

---

that about sums it up. I even have a few DB's with what I refer to as a self destruct table.

The best example is a progrma I will...

Dan.Humphries (6/30/2010)

---

I saw something like this once.

What I discovered was what I considered to be lazy programming but basically there was a trigger that fired on upate. The belief was...

jvanderberg (6/21/2010)

---

Well, you could add the appropriate maintenance plan task to the SSIS package directly. That's pretty modular since it only takes a few parameters, and does all the...

nelsonj-902869 (6/21/2010)

---

Boy, perhaps I am missing the problem here but.....

Why can't you run each of the individual index rebuild one at a time to determine the approximate length of runtime...

Tom.Thomson (6/19/2010)

---

GabyYYZ (6/18/2010)

---

The two main points about this article for me, as I see it NOW, are:

1. Do I still think cursors are, how shall we say it, sub-optimal?...

jvanderberg (6/21/2010)

---

Asynchronous actually means "independently of the main program flow". This is the exact opposite of what you think it means. Synchronous events are events that happen one...

To all who are pro-Cursor fans that for whatever reason just refuse to listen to or simply can’t grasp the concept and therefore choose to ignore the advice that many...