Tom.Thomson (6/16/2009)

---

Suggesting that "Simple servers, such as DNS, DHCP, or Active Directory Servers" are going to be easy for virtualisation seems to me a bit strange. Anyone who has...

dld (6/15/2009)

---

The recommendation also seems to be to go with servers that have virtualization built into them, which means our existing servers will be retired. All of this means...

I think many of the things you noted are good arguments FOR going virtual. It provides a layer of hardware abstraction, so with a virtual machine, moving it from...

skjoldtc (2/20/2009)

---

The sparse column itself requires no space for storage if it contains a null value. However, additional storage space is required to store non-null values in the sparse column....

There are several sources from MS or MS related that specifically say storing a null takes NO space

http://blogs.technet.com/andrew/archive/2008/02/28/sql-server-2008-sparse-columns.aspx

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

Specifically from the link above, a little...

note to self: don't take quizzes till fully caffenated.. could have sworn I was ticking a check box that said "CANNOT have a default value... grumble :angry:

Lynn Pettis (2/18/2009)

---

Maybe I am reading it wrong, but it looks to me that if the policy isn't in msdb it can't be used. If this isn't true, please...

The question is partially wrong.. Since there is an option to store the policies in an XML file, it should say "IF stored in a database.." or perhaps make...

Swirl80 (2/18/2009)

---

SQAPro (2/17/2009)

---

If you have not already tried using it, the SP_WHO2 stored proc can also reveal a lot about what processes have locks or are waiting on locks, and...

If you have not already tried using it, the SP_WHO2 stored proc can also reveal a lot about what processes have locks or are waiting on locks, and also how...

I think this might have been better asked as 'what is the correct query to return the results we want?', instead of asking what return values would be possible (which...

permission have you

:crazy: horse lead to water have I.

Drink will it not.

More I can do not, giving up I am. 😎

Paresh Prajapati (2/11/2009)

---

[Yes, they have checked from this sites and it is reserverd for external.

I think they are not able to analysis how this IP capture here even with high...

thanks for the update, that's the kind of thing that can be very helpful to someone else who comes along later, in the same situation, and is looking for answers.