we have started virtualizing some stuff using the free vmware server ontop of one of our file servers so no big deal to just setup anothing virtual machine to run...

Thanks for all the advice guys!

We had a meeting yesterday to go over all this. looks like we're going to virtualize our dev server (which is an identical spec...

ALZDBA (2/11/2009)

yes the dblevel is set to sql2005 (90)

I've done some testing and it seems to be an issue that...

LOL Yea about 7-8 years ago they migrated this whole system from access to sql server and it's just kept growing like it is. :crying:

I guess I should have just...

Here is our sql server version.

Microsoft SQL Server 2005 - 9.00.3239.00 (X64) Apr 9 2008 22:41:28 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition...

Has anyone heard anything about when SP3 will be released finally?

We just upgrade from direct storage to a Dell EqualLogic PS5000 (14x15k 450GB SAS + 2 Hot Spares).

We were running Raid 10 on the direct storage (4x15k 150gig sas) but...

changing the max dop does not require a restart and is an instant change.

I know it's not fun playing with a production box but it's really the only way. it's...

try setting the max dop to 2 to start and see what happens. then if that doesn't help try slowly adjusting the cost threshhold up a bit at a...

check what your parallelism settings are and keep an eye on what's running and check for heavy processes that are using parallelism. That has been the major contributor the high...

There will always be a need for triggers but it is something that should be used sparingly and only when you truly have no other option.

In our company we do...

I'm going to voice a me too that percentage based resizes are bad IMO... A good DBA should be monitoring every database and be aware of not only size but...

yes over on the MSDN forums someone gave some code although it is very specific to c# and .net

private bool IsInSubnet (string ipAddress, string cidr) {

string [] parts...

Thanks for the cool script Chris,

I've been looking to build some sort of auditing system for my company for a while now but haven't really thought much about how to...

Is anyone else going to the tech fest?

Almost the entire IT dept here at my company is going.