hidayath_be (11/8/2010)

---

I also see sql server resource and sql server agent resource is missing in cluster administrator in one of my instance. Is there any way to recover them. Probably...

Just keep in mind to remind your san-admins to double check their LUNs to they use disk alignment !!

If they don't your db will pay the price during...

It has been a pleasure meeting you at sqlpass, as well as meeting Grant, Steve, Andy and other renowned names at SSC.

Thank you for sharing a...

Oh yes, I see, Sorry for re-opening an old thread but it served a good cause 😀

Grant in action at SQLPASS 2010

It was very nice meeting him and going to his sessions.

Job well done !

Thanks for this addition Sean :Wow:

OP: Keep in mind it is not because you can do something in a certain way, you should. Think about the consequences.

great... now you've had two answers saying No and Yes ...

That's what makes these fora good, you'll get alternatives and test hints.

I don't have time right now, but go on...

Ware still restricted to 0 and 1 😉

If you can, just do it right now to the full size. This will not take more backup space !, but you'll neede the space if you restore.

If you...

I'm pretty confident SQLserver doesn't sort wrong.

Have a look at the binary values of your columns and it'll be clear why sorting is resulting in the set you get to...

raj acharya (11/11/2010)

---

Hi,

can you help me for how to set data file or log file autogrowth.

actually till now we never faced problem of autogrowth most of database are set to...

With mirroring, only one of both databases can be available at an instance at a single point in time.

So the other is awaiting for log entries, hence in "restoring"...

I don't think so. simple reason ... this cannot be "at run time" but must be persisted, so a trigger is the only way.

I'm sorry I couldn't reply earlier, but I was in class the rest of the day.

As always I'm glad others jumped in and helped out.:cool:

- have a look at Jeff Modens article on tally tables or moving averages.

Those should get you started. http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/

- maybe row_number() can get you a good enough solution. Check books...