Gaurav, this might help you!

Update tablename

SET

PPT = CASE WHEN ISNULL( NULLIF(PPT,0), 1) = 1 THEN 1 ELSE PPT...

Peter, i can somewhat visualize your existing system and i guess i have a code that might get u there, but as Henrico said, we need to see "physically" how...

Nice to hear your issue is fixed! You're welcome, faheem! 🙂

C'est Pras! 😎

If you want to avoid negative condition, go the postive way... I quite dint understand what your requirement is! The question is too vague, friend! Please be more specific!

😎

I will give u this, buy some back-up restore software! I guess Redgate has got a good one; i officially use Quest Software's LietSpeed! Back-up all the databases, put them...

Suresh, your issue s exactly similar to the one posted under this:

http://www.sqlservercentral.com/Forums/Topic920770-392-1.aspx

I have given a code that will work for the requirement! Please go through that , Suresh!

Its an INT column where u are going to stuff your final output!

INT takes 4 bytes of space regardless of the "number" present in the row!

So assuming, after your...

Sure , Jones!

If it's a dev box, I'd be wary of load testing under VMs. You want to load test...

Gianluca Sartori (5/13/2010)

---

I read in MVP Deep Dives that Hyper-V seems to be good at performance, but I don't have hands-on experience.

My latest fight with a database engine on a...

😛

Dig into the VM and look for pressure in memory or IO and...

Wow Jones himself replying a thread is such a gift, thanks first of all for the reply, Mr.Editor!

Now for your questions:

Steve Jones - Editor (5/13/2010)

---

How is the VM setup? On...

Try this then (assuming your from_date is 8 digits long and 5 and 6th digits represent months):

;WITH DATE_CTE AS

(

...

No idea, Gian! As i said above, i am just a junior dev, so not much into hardware/network related things!...

sql_lock (5/13/2010)

---

Gianluca Sartori (5/13/2010)

---

Heh, Mr. Coffee, virtual machines are horribly slower than physical machines.

There's a virtualization layer between your system and the physical resources: CPU, disks and memory must...

Jaffer, no while loops/cursors :-).. didn't my code work for you??