personally i prefer the function, it works on SQL Server 2005 as well and does exactly what it says on the tin. Its undocumented for a very good obvious reason...

place your Tempdb on a separate array and size it appropriately + then some. It shouldn't then get to the point where it needs to grow again. Any file shrinking\growth...

😉

Give this a try

select 'create login ' + name + ' with password = ' +

sys.fn_varbintohexstr(password_hash) + ' hashed, sid = ' +

sys.fn_varbintohexstr(sid) + ', default_database=[' + default_database_name...

best way

It's not obsolete as active\passive refers to the Windows cluster itself and not SQL Server!

Example: A 2 node Windows cluster...

if the passive node has 2 instances then it is not passive is it??????

Take...

BOL always has some inconsistencies. In the copy i have it says you can move it but not recommended as if you do it is always returned to the Binn...

Correct they are the permissions to assign in ADSIEDIT to the service account. You also need to trust the...

as far as...

george sibbald (4/7/2010)

---

Question I don't know the answer to............In SQL2008 if you restore a master database from a different server and the server the backup originated from had a different...

Satish-219904 (4/6/2010)

---

From your responses so far,

I will add make the max. memory change and add the sql service account to "lock pages in memory" option. Hopefully these two changes will...

drawlings (4/5/2010)

---

I use perfmon to monitor PLE.

Lock pages in memory is advised only in cases where it proves to improve performance, experiment! In theory the setting should not be required....

yes its only user dbs and model, msdb to worry about

Hi

the values all have different meanings. The buffer cache hit ratio should be compared against buffer cache hit ratio base. Take buffer cache hit ratio and divide by the base...