rudy komacsar - Doctor "X" (7/27/2010)

---

Here are a two suggestions:

Why use individual users, how about using Active Directory groups ?

(This may take a bit of analysis and lunch for the...

Jim McLeod (7/13/2010)

---

A possible option is to make it a rule to never click on the "Logins" node in Object Explorer without right clicking it and selecting "Filter" first. ...

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