The rule of thumb --> SQL reads extents (64k) and writes pages (8k)

For a SAN, tweaking stripe/block size only begins to show performance affects on larger databases ... by larger...

UDP 1433 ?

or is it UDP 1434 ?

I'm getting old and cannot remember ...

Do not ever discount your 'subjects' ... users, business owners and process owners ... remember, it's not just the message, but how it is delivered as well !

The overall fragmentation of either the table or the database has no bearing on the formula. It's the amount of unallocated (free) extents in the database that really count (I...

Beware ... as rulers go you can have either:

A Beneficent Oligarchy

or

A...

Some other items to consider ...

How much memory does your server have ? greater than 4 Gb ?

If so, then for the server you'll need to decide whether or...

Here's a hand link for future reference:

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#2

I've always had this one as an Internet shortcut !

The formula might not give you enough space due to database lack of total database free space and database fragmentation. I've had success 99.44% of the time with the following...

SAP = Stooge-A-Palooza

I believe that this acronym can be used to describe the software developers and software buyers of the product.

dynamic SQL or not ...

exec stored_procedure @@servername, db_name()

gives you the present server name (whether a default or named instance) and the database name of you current 'context'.

Thanks ! Have  great day !!!

Likewise on MOM - we are using MOM 2005 on 200+ servers - about 23+ (growing) are SQL Server. Also, you should check out the MSX server functionality already 'builtin' to...

Thanks for remembering the 'proper' stored procedure execution Noel !!!

Leave it no non-SQL admins to create more need for SQL admins ...

I just had to hit the "Reply" button on this one ... however, I am at a total loss of what to say ...