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.

Is that official? Mar 23?

Yes, I meant stick with 2008 R2. Or stick with 2005 if you don't have a compelling reason for the upgrade.

You could use a local view or synonym, but that would be for objects, not all globally.

If these are stored procedures, why not do it the reverse way, have them...

Good question. I don't have a spare drive now I want to test FORMAT on. I think it applies only to TAPES, but I'm not positive.

Nothing in there: http://msdn.microsoft.com/en-us/library/ms186865.aspx

Disk, you...

jflynn-735049 (1/19/2012)

---

We have a large project that is using many stored procedures. The project uses multiple database so a stored procedure may call tables in another database. The issue...

Calculate the licensing costs. There isn't a set 2012 price yet, but give it a go based on the 2008R2 + 10-20% and see if the cores matter to you.

If...

jay holovacs (1/19/2012)

---

Well their control over independent software is part of the problem. But they do put a strangle hold on content providers such as magazine publishers. They contracturally mandate...

Jason has some good points. Be sure you look at licensing. The change from sockets to cores may or may not affect you. If you have high density processors (>...

Agree with what's been said. If you have a server, monitor memory, look for pressure. That's a sign you might need more.

A few links:

http://www.sqlservercentral.com/articles/Memory/74867/

http://sqlblog.com/blogs/lara_rubbelke/archive/2008/04/18/memory-pressure-on-64-bit-sql-server-2005.aspx

http://msmvps.com/blogs/bradley/archive/2009/01/15/how-to-troubleshoot-sql-server-memory-related-issues-part-1.aspx

Maybe. That's if it's a...

hnhaney2 (1/19/2012)

---

I believe in doing good things, but as for Bill Gates is concerned, his foundation is doing more damage than good. His foundation is a front for something far...

Jesus Cardenas Mercado (1/19/2012)

---

Thank you for your words Steve, it was a great and very human editorial, and to be true, I think that you have already a place in...