SQL Server 2005 Implementation and Maintenance

SQL Server has the following ingredients to your function. EXP, PI, STDEV, AVG, SQRT

http://en.wikipedia.org/wiki/Normal_distribution

I think the rest is making sure the formula's order of operations plays out and that...

There are 3 exams. 70-431, 443 and 444.

I think your preparation would depend on your previous experience with the software.

The Microsoft Press books and practice exams do a nice...

Open task manager and look for the SQLserver.exe executables.

then you'll know how much your empties are consuming.

~BOT

besides lock pages in memory, you should look at the OS to see what is stealing memory from SQL Server.

From what I understand the The SQLOS memory clerks will release...

The circular reference obviously won't allow you to insert data and the isSelected bit does create problems because the app is handling the data integrity (or you'd need to write...

There are lots of reasons for OS memory starvation outside of the max server setting.

MPA + connection memory + worker thread + VAS.... all of this memory is allocated...

How about a person that has 0 mugshots. Is that allowed?

~BOT

http://msdn.microsoft.com/en-us/library/ms151230.aspx

See the section titled: Viewing Information and Performing Tasks Related to Subscriptions

You're looking for 'distributor to subscriber history'.

~BOT

I don't understand how node 2 can be failed over.

Did you mean when nodes 1 or 3 fail to node 2?

Also... is anything else running on node2 when it gets...

jcosta (8/20/2009)

---

Jeffrey,

On x64 hardware, Microsoft says that the "Lock pages in memory" right is not necessary. From this Technet article:

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

"Locking pages in memory is not required on 64-bit operating...

Have you checked replication monitor to see what the status is on the last x distribution jobs?

~BOT

How many SQL Instances are we talking and what nodes are you failing to/from?

your PLE goes down because the OS is taking memory back from SQL Server.

This happens when the...

Steve,

Your web people should have a chart of website use. I'll bet dollars to donuts it's similar to western hemisphere sleep patterns, but shortened due to time zone differences....

there's the technology way and the human-interaction way (talk to developers).

They both have a good chance of failing you.

The technology way I can recommend is to run it as a...