foscsamuels (3/18/2013)

---

Our max server memory was unlimited. Consultant said he limited max server memory for another client with a similar issue.

After this discussion, I set max server memory...

UncleBoris (3/18/2013)

---

Thanks for the replies.

So if a DB server totally dies and it is not recommended that the Master is restored on another machine then what would be the normal...

SQL doesn't page out it's own memory. The OS may page SQL out if its under memory pressure. Older versions of the OS (Server 2003) were more agressive about this,...

Err, huh?

No conflict.

SQL Server 2005 SP 4 X64 Standard...

What little thing that you're interested in?

You're running into this: http://www.benjaminnevarez.com/2011/05/optimizer-statistics-on-linked-servers/

http://sqlblog.com/blogs/linchi_shea/archive/2010/11/22/linked-servers-permissions-and-distributed-query-performance.aspx

The size of the database has little to do with mirroring. The volume of transactions will affect what kind of connection you need between the servers.

There's something in that column that won't convert to date.

Try this, see what you get:

SELECT CONVERT(CHAR(8), EZACDT)

FROM SYM_SPT_SNI_01.dbo.DBA_MVX_CINACC00

WHERE EZCONO = 2

AND EZDIVI = '001'

AND ISDATE(CONVERT(CHAR(8), EZACDT)) = 0;

Not a...

Don't move master databases from one server to another, asking for trouble.

As for how you fix the missing model problem:

http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

How is your guideline of leaving 2GB for the OS and monitoring accordingly different from Jonathan's guideline of leaving an amount of memory dependant on the total server memory and...

Active /active (which really is a tern that shouldn't be used any longer) is just 2 active/passive SQL server failover instances on the same cluster.

More correctly called 'multi-instance cluster', it...

Please note: 3 year old thread.

Dynamic SQL is the only way you can do that.

I strongly recommend you do not go this route. Procedures should have a well-defined function, not do whatever based on a...

Errrr....

SQL is not Access. It's not a file-based database that sits on a share. It's a...