FWIW, I haven't found support for GP to be top notch. They used to insist we run GP under "sa" until we pointed out there wasn't a reason for this....

There isn't a good way to do this. It isn't tracked per se, so you can't be sure when someone last used a database.

If you suspect no one is using...

Brandie Tarvin (1/23/2012)

---

WHEEHAW!

Delayed due to technical difficulties, Latchkeys is now out on Kindle. Here's the U.K. Kindle version and here's the U.S. Kindle version.

The Nook versions are supposed to...

Like this? 😀

Good question. I'm not sure. What would drive you to view the discussion?

We have a basic HTML5 app at http://www.sqlservercentral.com/mobile for the question of the day.

We haven't enhanced that for forums, or articles, since it is a decent sized project and we...

Gus,

I wouldn't call experimenting "jiggling". Now if you try things and then slip that code into a deployment without understanding it, which implies incomplete testing (how can you write tests...

Points have been awarded back and the answers corrected. The wrong one was selected.

My apologies.

Yep, we used to do this monthly when I worked in a large shop (JD Edwards). We...

Sean Lange (1/19/2012)

---

I agree with one small caveat. If we...

Locking this thread. This has gotten away from the original question

LOL, I know this is (was) the suggestions forum, but I can't change either of those things.

Well, I could put a .22 through Lowell's light, but it would be a...

It sounds as though you have some permissions issue with the older publications.

If you log in as "sa", can you do a sp_droppublication on the item?

http://technet.microsoft.com/en-us/library/ms188363.aspx

It's a complex subject and topic. basically the optimizer calculates a series of costs, using different execution plans. It does not consider them all, but considers a number, picks the...

Please start a new thread for new questions.